Aller au contenu

Photo

Unable to connect to database


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

#26
Fenriz132

Fenriz132
  • Members
  • 14 messages
The command doesn't work, i don't know why. Maybe i don't have the access to the /data folder, how am i supposed to have it?

#27
AnTeevY

AnTeevY
  • Members
  • 109 messages
Another solution may be:

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".

But even then you probably would have to execute that loong command mentioned above to get the two database files.

#28
Fenriz132

Fenriz132
  • Members
  • 14 messages
Nothing abnormal here..

#29
Fenriz132

Fenriz132
  • Members
  • 14 messages
----------- double post

Modifié par Fenriz132, 07 novembre 2009 - 12:22 .


#30
Malcroix

Malcroix
  • Members
  • 360 messages
Yep, I'm also missing the files in the "Data" folder.

Thing is, I don't even HAVE bw_dragonage_content.bak anywhere on my hard drive. I got the digital download copy from STEAM. Apparently, this solution doesn't even apply to such cases, since they make reference to the DVD installation files.

PROBLEM NOT SOLVED. BIOWARE?

Modifié par Malcroix, 07 novembre 2009 - 02:04 .


#31
casadechrisso

casadechrisso
  • Members
  • 726 messages
I tried alll these suggestions, also with setting new permissions in the Control panel as suggested above. Nothing works, the last error I got (after typing this epic command for the fifth time) is simply Sqlcmd: Error: Microsoft SQL Native Client : Client unable to establish connection due to prelogin failure.

I'm so utterly frustrated right now.... hell, what does the toolset even need MySQL for? For me that's always been the border between creativity and nerd stuff I will never understand in my life.... scares me off. :((

Oh please Bioware, give me a simple step-by-step for Dummies, or a simple fix.

#32
Cromalic

Cromalic
  • Members
  • 114 messages
Did you restart your computer after checking the 'Local System Account' and saving it? You have to.
I had the exact same problems, but after changing the admin rights on SQL Server (BWDATOOLSET) it worked for me. :)
Beware, takes a while to launch!

Modifié par Cromalic, 07 novembre 2009 - 04:01 .


#33
sirkaracho

sirkaracho
  • Members
  • 52 messages
just give us the files in the data folder to download or something, i have also an empty data folder, but first things first:



i get that msxml6 error when i install the toolset, but i dont have the program i am supposed to clean up, i just have a msxml6 parser, cleaning up that didnt help, and its also back there



i just clicked ok and everything installed fine, only the data folder is still empty, so the toolset doesnt want to start



i rightclicked on the datafolder for making sure i can write there, i did that sql command thing (making sure i am using the right paths and stuff) i got the same error as casadechrisso two postings above this one



after installing my windows twice because of that reboot-loop i thought i can finally use the toolset

and yes i know there is a game to play, but the toolset is the reason i bought it


#34
Kyelll

Kyelll
  • Members
  • 3 messages
The command doesn't work for me either. Help! That's really frustrating especially when you've waited for the toolset so long, installed it in a hurry at 2am, all this to see an error message ....

Nobody wants to give a try to the possible fix sirkaracho exposed in another thread ?

#35
Neuzl

Neuzl
  • Members
  • 7 messages
Ok i finaly fixed it thanks to Smergo and Taltherion.
But if you get permission denied in database ´master´ follow this guide, then run the cmd and the command again.

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

#36
Radimov

Radimov
  • Members
  • 13 messages
I have the same problem in Windows 7, when i type de Smergo line the cmd returns this error "Sqlcmd: Error: Microsoft SQL Native Client: Client unable to establish connection due to prelogin failure."

#37
Radimov

Radimov
  • Members
  • 13 messages
...

Modifié par Radimov, 07 novembre 2009 - 11:30 .


#38
Malcroix

Malcroix
  • Members
  • 360 messages
....

Modifié par Malcroix, 07 novembre 2009 - 11:59 .


#39
Ogre78

Ogre78
  • Members
  • 26 messages
actually no solution to me, i'll try to download sql2008 at the moment...

#40
Malcroix

Malcroix
  • Members
  • 360 messages
ALL RIGHT, THIS WORKED FOR ME!



But boy, did it involve some frustration...



1. First of all, the bw_dragonage_content.bak is a hidden or system file and Vista doesn't automatically find it in searches. So you have to make sure it includes hidden/system files while searching.



2. Second, the command provided on the BioWare Toolset wiki Support page for THIS EXACT PROBLEM is WRONG. It has wrong syntax or whatnot. Only using the command provided in THIS THREAD worked for me.



3. Third, I had to change the administrative rights for Microsoft SQL, and set BTOOLSET to Local Service, all like described in this thread.



Finally, after all this shamanism, the toolset launched.



Thanks, guys!






#41
King_Orius

King_Orius
  • Members
  • 12 messages
I´ve tried to make all things posted here but nothing :(( is unable to connec to the database, writting this code C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\"sqlcmd -S .\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\EUTS_Install\\data\\bw_dragonage_content.bak' WITH MOVE 'bw_da_content_euts_Data' TO 'C:\\Program Files\\Dragon Age\\toolssql\\Data\\bw_dragonage_content.mdf', MOVE 'bw_da_content_euts_Log' TO 'C:\\Program Files\\Dragon Age\\toolssql\\Data\\bw_dragonage_content.ldf'



i recieve a msg error MSG 102, level 15 ,State 1 server BERBELIAS1\\BWDALTOOLSET, Line 1 Incorrect syntax near RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\EUTS_Install\\data\\bw_dragonage_content.bak' WITH MOVE 'bw_da_content_euts' and i still recieve this error message and cant execute toolset, can anyone help me please?

#42
Highlen

Highlen
  • Members
  • 70 messages
ever since I open the database in VS2008 using its database connection i couldnt connect to database beause the database is still in the data folder.

?!?!

I have vista x64 btw

Modifié par Highlen, 07 novembre 2009 - 01:52 .


#43
sirkaracho

sirkaracho
  • Members
  • 52 messages
doesnt work for me, i get an error message when i try to set the option to local service :(



maybe i can do something else:



as i said when i try to install the toolset i get an error that says something like it cant update my msxml6r.dll because windows is protecting it and i should update my system, but everything is updated (only internet explorer 8 isnt installed)



so what exactly have do i have to do to make windows remove the protecting and the installer able to update this file?

#44
BigMitts

BigMitts
  • Members
  • 4 messages
Possible quick fix. I had the SQL database error. First I uninstalled the toolset. Then I went here:



http://www.microsoft...s/sql/download/



Then I reinstalled the toolset and it worked. When installing the toolset, still choose to install SQL SP3 when it asks.

#45
Highlen

Highlen
  • Members
  • 70 messages

Neuzl wrote...

Ok i finaly fixed it thanks to Smergo and Taltherion.
But if you get permission denied in database ´master´ follow this guide, then run the cmd and the command again.

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

I did that but guess what it will not stay I hit ok and once i run the toolset I still get the unable to connect ....so i checked the SQL Server Surface Area Configuration it will not stay it always goes back to avaible privalges

#46
Fenriz132

Fenriz132
  • Members
  • 14 messages
Same thing here

#47
Highlen

Highlen
  • Members
  • 70 messages
does the toolset have to be in the same folder as the game

#48
Fenriz132

Fenriz132
  • Members
  • 14 messages
Yes i think

#49
Neuzl

Neuzl
  • Members
  • 7 messages
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

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

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.


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

I hope this clear some things up.








                  

Modifié par Neuzl, 07 novembre 2009 - 04:46 .


#50
MoxinRift

MoxinRift
  • Members
  • 13 messages
Haven't read all of this, so may be superfluous - but I got on the right path after reading Smergo's post. His command didn't work for me though, so I did the following:



1. Make sure you have all rights to the whole Dragon Age program folder (I really hate Vista sometimes ..)

2. Uninstall the toolset.

3. Run the installer as administrator.

4. Set the toolset to run as administrator.

5. Run the damn thing.



This finally worked for me. Thanks a lot to Smergo.