Toolset and Steam (Resolved)
#26
Posté 06 novembre 2009 - 08:38
That worked, thanks.
#27
Posté 06 novembre 2009 - 08:43
"Unable To Connect to the database. Run the Toolset configuration and verify" etc etc
I had a pre-existing SQL 2005 installation. When I setup the connection and test it I am successfully able to connect to the database.
#28
Posté 06 novembre 2009 - 08:49
C:\\Program Files (x86)\\Steam\\steamapps\\common\\dragon age origins\\tools\\toolssql\\MSSQL.1\\MSSQL\\LOG
And look for a line like this one:
2009-11-06 15:24:10.78 spid51 Cannot create file 'c:\\program files (x86)\\steam\\steamapps\\common\\dragon age origins\\tools\\toolssql\\MSSQL.1\\MSSQL\\DATA\\temp_MS_AgentSigningCertificate_database.mdf' because it already exists. Change the file path or the file name, and retry the operation.
I had to delete temp_MS_AgentSigningCertificate_database.mdf & temp_MS_AgentSigningCertificate_database_log.LDF manually after which the install was able to proceed.
#29
Posté 06 novembre 2009 - 09:02
#30
Posté 06 novembre 2009 - 09:15
#31
Posté 06 novembre 2009 - 09:18
#32
Posté 06 novembre 2009 - 09:22
Or change areas in existing saves.
Modifié par Medet, 06 novembre 2009 - 09:28 .
#33
Posté 06 novembre 2009 - 09:25
#34
Posté 06 novembre 2009 - 09:26
#35
Posté 06 novembre 2009 - 09:27
#36
Posté 06 novembre 2009 - 09:32
#37
Posté 06 novembre 2009 - 09:38
Wannabeuk wrote...
Yep, it did work just as posted above.
For the lazy:
open file \\\\\\\\Steam\\\\\\\\steamapps\\\\\\\\common\\\\\\\\dragon age origins\\\\\\\\tools\\\\\\\\toolssql\\\\\\\\MSSQL.1\\\\\\\\MSSQL\\\\\\\\Install\\\\\\\\Sysdbupg.sql
Find:
SELECT @certificate_name = QUOTENAME(@certificate_name, '''')
Replace With:
SELECT @certificate_name = '''' + REPLACE(@certificate_name, '''', '''''') + ''''
Re-install toolkit
#38
Posté 06 novembre 2009 - 10:10
#39
Posté 06 novembre 2009 - 10:14
Wannabeuk wrote...
Yep, it did work just as posted above.
For the lazy:
open file \\\\\\\\Steam\\\\\\\\steamapps\\\\\\\\common\\\\\\\\dragon age origins\\\\\\\\tools\\\\\\\\toolssql\\\\\\\\MSSQL.1\\\\\\\\MSSQL\\\\\\\\Install\\\\\\\\Sysdbupg.sql
Find:
SELECT @certificate_name = QUOTENAME(@certificate_name, '''')
Replace With:
SELECT @certificate_name = '''' + REPLACE(@certificate_name, '''', '''''') + ''''
Re-install toolkit
I can confirm that this worked for me - thanks Wannabeuk!
Vista 64bit, in case it matters. When I got the error message from the sql installer, given the options 'retry' or ''cancel', I opened notepad as administrator and edited the file as required, then hit 'retry'. Toolset installed and launches without any issues. Now to try it out!
#40
Posté 06 novembre 2009 - 10:24
SnipeyMcGee wrote...
Not letting me delete the files mid-install, or to save the changes I made following the microsoft instructions. I'm assuming that's my OS (Vista), so I'm trying to find a workaround to *that*. Anyone know how?
Maybe run the editor as admin, then open the file and edit. That's what I did with Vim.
#41
Posté 06 novembre 2009 - 10:39
#42
Posté 06 novembre 2009 - 10:49
#43
Posté 07 novembre 2009 - 12:45
Is this related to the whole MSSQL thing? Or something completely different?
Modifié par Archangel3d, 07 novembre 2009 - 12:45 .
#44
Posté 07 novembre 2009 - 01:30
The fix worked for me by going here:
C:\\Program Files (x86)\\Electronic Arts\\Dragon Age Origins\\tools\\toolssql\\MSSQL.1\\MSSQL\\Data
#45
Posté 07 novembre 2009 - 02:36
After the toolset was finally installed, it refused to launch due to the known "Unable to connect to database" bug. Apparently, I'm missing files in my "Data" folder.
Problem is, the known solution does not work for me as it requires the file bw_dragonage_content.bak which I don't have anywhere on my HD (yes, I searched). Perhaps it's a Steam thing.
BioWare?
#46
Posté 07 novembre 2009 - 02:43
#47
Posté 07 novembre 2009 - 02:53
It installs the MSSQL, yet has a bunch of errors, which ends up with it just shutting down the SQL install, I'm left with C:\\Program Files\\Steam\\steamapps\\common\\dragon age origins\\tools\\toolssql being blank; there's no MSSQL folder in there to go and edit.
I guess I should just wait until BioWare comes out with a working version at this point, since I apparently have 2-3 different issues.
#48
Posté 07 novembre 2009 - 03:34
SnipeyMcGee wrote...
Mmmm, I think I'll hold off on my enthusiasm for the editor for a few more days. I'm hoping the Bioware guys will get in touch with steam/microsoft and get a seperate installer- with the go-arounds I'll have to do to make this fix work I'm not going to go for it. Hopefully you guys will have a seperate, Steam enabled toolset download soon for us customers from there. Until then, I'll keep plowing through the campaign.
Ya man for real, gotta be a comp expert to get it to work, aint worth it IMO. Loving the game. But Biowares release of a working toolset with the the game is an epic fail.
#49
Posté 07 novembre 2009 - 04:47
#50
Posté 07 novembre 2009 - 06:15
Hazado22 wrote...
FIXED! Do what is says there
http://support.microsoft.com/kb/935371
the file sysdbupg.sql is located at C:\\\\\\\\Program Files (x86)\\\\\\\\Steam\\\\\\\\steamapps\\\\\\\\common\\\\\\\\dragon age origins\\\\\\\\tools\\\\\\\\toolssql\\\\\\\\MSSQL.1\\\\\\\\MSSQL\\\\\\\\Install
If you still run into problems, Delete temp_MS_AgentSigningCertificate_database.MDF and LDF from C:\\\\\\\\Program Files (x86)\\\\\\\\Steam\\\\\\\\steamapps\\\\\\\\common\\\\\\\\dragon age origins\\\\\\\\tools\\\\\\\\toolssql\\\\\\\\MSSQL.1\\\\\\\\MSSQL\\\\\\\\Data
I hit cancel the first time and let it complete the toolset install then tried to reinstall may be why I have these files above.
Yes i have the steam version and the toolset is working for me after i did the above fix
This, and then the "for the lazy" post below it, got it workin for me. Thanks a ton.




Ce sujet est fermé
Retour en haut






