Unable to connect to Database
#1
Posté 10 novembre 2009 - 05:45
The toolset isntalled fine as far as I can tell but when I try to run it I get the
"Unable to connect to the database.
Run the toolset configuration program and verify
your settings or search the toolset wiki http://social.biowar.../wiki/datoolset to help with this issue.
This toolset must now exit."
I tried running the config program with no success. There is nothing in my toolssql folder except for an empty data folder.
I am running Windows 7 and got the digital deluxe version from the EA store.
I saw the fixes for the steam issue but I never got an error when I installed the toolset so wasn't sure if it applied to me.
Thanks!
AR
#2
Posté 10 novembre 2009 - 06:42
I believe the cause of my issue was trying to sync the databases between 2 computers using a file sync program. The only solution I've found was to uninstall the sql server, then reinstall the toolset to recreate the databases.
Hope this helps.
#3
Posté 10 novembre 2009 - 08:49
#4
Posté 10 novembre 2009 - 02:44
The ever handy run as administrator doesn't help any.
And the solutions on the wiki mostly confuse me.
Since my data folder is empty, I suspect this command should help, but where the hell am I supposed to enter it? It's too long for the standard "run".
C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\"sqlcmd -S .\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\Program Files\\Dragon Age\\tools\\dbbak\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\Program Files\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_Log' TO 'C:\\Program Files\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.ldf'
Modifié par twincast, 10 novembre 2009 - 02:46 .
#5
Posté 10 novembre 2009 - 02:58
Possibly relevant infos:
win7 fresh install
game is going onto a separate drive ( G: vs C: )
toolset worked perfectly fine prior to reinstall
#6
Posté 10 novembre 2009 - 02:59
twincast wrote...
Same here. (Vista-32, CE)
The ever handy run as administrator doesn't help any.
And the solutions on the wiki mostly confuse me.
Since my data folder is empty, I suspect this command should help, but where the hell am I supposed to enter it? It's too long for the standard "run".
C:\\\\Program Files\\\\Microsoft SQL Server\\\\90\\\\Tools\\\\Binn\\\\"sqlcmd -S .\\\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\\\Program Files\\\\Dragon Age\\\\tools\\\\dbbak\\\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\\\Program Files\\\\Dragon Age\\\\tools\\\\toolssql\\\\Data\\\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_Log' TO 'C:\\\\Program Files\\\\Dragon Age\\\\tools\\\\toolssql\\\\Data\\\\bw_dragonage_content.ldf'
run -> "cmd" -> then paste that command in
#7
Posté 10 novembre 2009 - 04:13
bioware, fix it.
#8
Posté 10 novembre 2009 - 04:31
Link to the other thread on this topic. None of the solutions there worked for me, but they did work for others.
#9
Posté 10 novembre 2009 - 07:05
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.
Modifié par adembroski11, 10 novembre 2009 - 07:07 .
#10
Posté 10 novembre 2009 - 07:14
#11
Posté 10 novembre 2009 - 07:40
No idea what caused it. Didnt do/change anything on my Comp.
#12
Posté 10 novembre 2009 - 08:04
Anyone an Idea what I can do?
Btw. When i run the cmd i get this error message as well:
Msg 262 Lvl 14,Create Database permission denied in database "master" AND
Msg 3013,Lvl 16,State 1,Server XXXXXXXX,Line 1
Restore Database is terminating abnormally
Modifié par Silas TNA5CoDe, 10 novembre 2009 - 08:20 .
#13
Posté 13 novembre 2009 - 06:45
Thanks!





Retour en haut






