Aller au contenu

Photo

Unable to connect to database


  • Veuillez vous connecter pour répondre
156 réponses à ce sujet

#76
Ogre78

Ogre78
  • Members
  • 26 messages
Start-->Control Panel-->Administrator-->Services   scroll down and find SQL list then right click-->proprietes

#77
Ogre78

Ogre78
  • Members
  • 26 messages
sry, ........triple post....... how to cancel?

#78
adembroski11

adembroski11
  • Members
  • 189 messages
Something to try, worked for me (thanks to EvilEdison for this fix)



Assuming you currently have a failed install of SQL and the



Toolset...



* Uninstall toolset via Add/Remove Programs

* Uninstall all files related to SQL via Add/Remove Programs

* Remove remaining SQL related items via Windows Install Cleanup

* Uninstall MSXML6 via Add/Remove Programs (this may or may not work,



move on regardless)

* Remove any instances of MSXML remaining in Windows Install Cleanup

* Reinstall Toolset



You should see a configuration screen at some point during the SQL



install. If that runs successfully, the toolset should run.

#79
sirkaracho

sirkaracho
  • Members
  • 52 messages
didnt work for me, as i said i had to format my pc because of the endless reboot cycle anyway, so everything was clean anyway, i got no error installing the toolset, still no database

#80
Kayiela

Kayiela
  • Members
  • 1 messages
I've tried to write this, with my directions in CMD:

"C:\\Program (x86)\\Microsoft SQL Server\\90\\Tools\\Binn\\"sqlcmd -S .\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\Program (x86)\\Dragon Age\\tools\\dbbak\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\Program (x86)\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_Log' TO 'C:\\Program (x86)\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.ldf'"

Yet, it does not work, keeps complaining that the path does not excist.
Does anyone know what I did wrong, or just have a slight hint?

Modifié par Kayiela, 10 novembre 2009 - 11:04 .


#81
sirkaracho

sirkaracho
  • Members
  • 52 messages
may sound a little basic, but make sure the path exists ^^



for example C:\\\\Program (x86)\\\\Microsoft SQL Server\\\\90\\\\Tools\\\\Binn



and kill those \\\\ - its alsways only \\ not two of them



for me for example it has to be c:\\progamme\\microsoft sql server\\90\\tools\\binn

#82
Awildawn

Awildawn
  • Members
  • 225 messages
ok, !i tried with my steam version, uninstalled it, used Ccleaner then reinstalled the cd of my collector edition and i still got database errors. I don't know what to do anymore. Plus, I can't seem to add administraztor rigthts for SQL to my computer so well, I'm lost.

The only thing I have left to do is a clean reinstall of windows 7 64 on my PC but I feel that it is over the top...

Is anybody at Bio considering doing another, more user friendly installer ? One that doesn't assume I know a lot about windows and mysql ?

#83
Lord Sinner

Lord Sinner
  • Members
  • 16 messages
Awildawn, you are aobsolutely right. Bioware has released a TOOL****.

#84
Lord Sinner

Lord Sinner
  • Members
  • 16 messages
TOOLS H I T

#85
KREUGER44

KREUGER44
  • Members
  • 37 messages
GAHH!

#86
Twofortea

Twofortea
  • Members
  • 2 messages

Kayiela wrote...

I've tried to write this, with my directions in CMD:

"C:\\\\Program (x86)\\\\Microsoft SQL Server\\\\90\\\\Tools\\\\Binn\\\\"sqlcmd -S .\\\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\\\Program (x86)\\\\Dragon Age\\\\tools\\\\dbbak\\\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\\\Program (x86)\\\\Dragon Age\\\\tools\\\\toolssql\\\\Data\\\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_Log' TO 'C:\\\\Program (x86)\\\\Dragon Age\\\\tools\\\\toolssql\\\\Data\\\\bw_dragonage_content.ldf'"

Yet, it does not work, keeps complaining that the path does not excist.
Does anyone know what I did wrong, or just have a slight hint?


I had to change the \\\\90\\\\ to \\\\100\\\\ on my system. 

Found the path, but now I get timeout errors.

#87
NunoEsguelha

NunoEsguelha
  • Members
  • 7 messages
I'll just unistall this crap and wait until this is patched up. I don't wanna screw with something that may **** up the game itself and the campaign.

#88
twincast

twincast
  • Members
  • 829 messages

Neuzl wrote...

Let see if i can sum this up.
--------------------------------------------------------------------------------------------------------
First go to C:/Program Files (x86)/Dargon Age/tools/toolssql

Right klick the Data folder and then go to properties , go to the security tab and then edit give full access.

Data -> properties -> security tab -> user -> edit -> full access

Then press ok, close the window and open the CMD.

In vista:

Start -> search bar -> type cmd
OR
Windows button + R -> type cmd and then press enter

In XP:

Windows button + R -> type cmd and then press enter
OR
Start -> run -> type cmd and then press enter
--------------------------------------------------------------------------------------------------------
Now when you are in cmd copy and paste this command:

"c:\\\\Program Files (x86)\\\\Microsoft SQL
Server\\\\90\\\\Tools\\\\Binn\\\\SQLCMD.EXE" -S .\\\\BWDATOOLSET -E -Q "RESTORE
DATABASE bw_dragonage_content FROM DISK = 'C:\\\\Program Files
(x86)\\\\Dragon Age\\\\tools\\\\dbbak\\\\bw_dragonage_content.bak' WITH MOVE
'bw_dragonage_content' TO 'C:\\\\Program Files (x86)\\\\Dragon
Age\\\\tools\\\\toolssql\\\\Data\\\\bw_dragonage_content.mdf', MOVE
'bw_dragonage_content_log' TO 'C:\\\\Program Files (x86)\\\\Dragon
Age\\\\tools\\\\toolssql\\\\Data\\\\bw_dragonage_content.ldf'"

Include both " "

Remove \\\\ so you only have one after each path.


If you have installed the Microsoft SQL
Server on another location edit the command so its match yours.
Example:
d:\\\\Program\\\\Microsoft SQL
Server

But if you get permission denied in database ´master´

go here and follow the guide:

http://www.sqlserver...permission.html
--------------------------------------------------------------------------------------------------------
I hope this clear some things up.                   

This comprehensive combined explanation finally made it work for me. You (and the others that provided the partial solutions before) can consider yourself hugged and squished and near-ravaged if you want. =]

#89
Montana

Montana
  • Members
  • 993 messages
None of this works for me :(

I guess it's too much to ask for an install that actually installs the program correctly.

And now i've got a migrane because of the toolset....

#90
Wl0fer

Wl0fer
  • Members
  • 2 messages
All of you Windows XP SP3 users out there... This works for me

http://support.microsoft.com/kb/968749

The problem is that in SP3 the msxml 6 -file is the problem, so you have to uninstall it and the try to install the toolset again. So you need to install "Windows Installer CleanUp utility"... which you can find from that link and information on how to use it.

Modifié par Wl0fer, 19 novembre 2009 - 01:08 .


#91
Wl0fer

Wl0fer
  • Members
  • 2 messages
------

Modifié par Wl0fer, 19 novembre 2009 - 01:08 .


#92
SteamPunks

SteamPunks
  • Members
  • 537 messages
I am constantly receiving this error :( Does this mean I do not have administrative rights? I set both folders to allow writing.



HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

allow remote connections..

Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

#93
Despzh0r

Despzh0r
  • Members
  • 26 messages
My toolset was working perfectly untill today and now I can't connect anymore, my data folder has *_content files in it etc.

I tried uninstalling and reinstalling but then I get

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.


Checked if any service was still running, but nope. Anyone managed to bypass that for a 2nd install?

Modifié par Despzh0r, 19 novembre 2009 - 10:51 .


#94
Adaram

Adaram
  • Members
  • 464 messages
If I uninstall MSSQL will I lose my data from my main campaign? Or does that get stored with the saved file and relaoded into the database when I load the game?



I am now getting this error as well. I uninstalled the toolset -- wasn't getting this error the first time -- and after reinstall of the toolset I am now getting the error ... :(


#95
twincast

twincast
  • Members
  • 829 messages
So it worked fine, but then I shut down my laptop, travelled home and tried to work/play some more in it and that darn error's back.
The files are still there, but it doesn't let me do the following anymore:

Neuzl wrote...

If you have installed the Microsoft SQL
Server on another location edit the command so its match yours.
Example:
d:\\\\Program\\\\Microsoft SQL
Server

But if you get permission denied in database ´master´

go here and follow the guide:

http://www.sqlserver...permission.html

--------------------------------------------------------------------------------------------------------

It is possible that your SQL service has no administration rights. Try
changing this in control panel -> administration -> services
-> properties of "SQL Server (BWDATOOLSET)" -> login tab ->
check "local system account".

Also go to Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager.

Then
SQL Server 2005 Service, on the other side you will see SQL Server
(BWDATOOLSET) make sure the state is Running, if not right clickand then start.
                


:huh::unsure::crying:

#96
grallonsphere

grallonsphere
  • Members
  • 60 messages
The image below shows where I am with this ... effort.  Despite telling the SQL Management Studio where to take the database and whoere to put it - the program keeps looking for it under c:\\Program Files...

This is gone beyond frustration to try to make this POS software run.  D they intend to fix it at soome point?



G.
-----
Posted Image

#97
Konkawak

Konkawak
  • Members
  • 3 messages
Hello there,

sigh...   - Both first paths are correct and exist
              - I have full access to "Data"

But still....entering my code here always gives me the error message "Path not found", even though its fully customized to my paths

*deleted*

anything I forgot?

Rgds


Edit:  hmm..now all of a sudden the console did do sth after having "Proramme (x86)" back in english..but now...-.-
still unabled to connect to database

THough I do have now  both bw_dragonage_contend SQL files in  that "Data" folder

Edit 2:  Nice...I just had to get back to the ConfigureToolset and fix sth there. Working now <3   been trying since yesterday

Modifié par Konkawak, 22 novembre 2009 - 02:25 .


#98
twincast

twincast
  • Members
  • 829 messages
Well, I re-installed, had the old problems and got rid of them through the old means. If I have to do this every time I shut down my laptop I'll get tired of it very soon, though.

#99
PainFruit

PainFruit
  • Members
  • 8 messages
Whenever I try to install it I get an error along the lines of "could not do something or other to file Uninstall Dragon Age.exe - Abort, Retry, Ignore"



Is that something to worry about? I can't uninstall the toolset (don't really care so far), but will that cause other problems? I have all the above problems too.



*cries* This is so complicated.

#100
Shadow_Storm

Shadow_Storm
  • Members
  • 1 messages
Wooot!!! Look what I found! =) (Worked for me)
http://social.msdn.m...d3-01785c9f99d1

This is if you get the following message while installing: "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine [Your Computer Name] Error:2147749896 (0x80041008)."


(If like everyone else, you find the "/" are duplicated, just compare the address I posted here with the address in your browser for this site, then remove any extra / you find) =) Good Luck and Have fun!

Modifié par Shadow_Storm, 23 novembre 2009 - 06:58 .