If you bought Dragon Age: Origins digitally you may encounter problems installing the Toolset. Bioware is working the problem, but in the meanwhile here’s what I did to get it installed.
Run the installer. The problem happens while installing MS SQL Server, and specifically while configuring it. You’ll encounter an error with an ignore/retry prompt. Leave that floating on screen.
Open:
C:\Program Files (x86)\Steam\steamapps\common\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Install\sysdbupg.sql
(substituting paths as required; I did this on Windows 7 Home 64-bit)
Search for:
SELECT @certificate_name = QUOTENAME(@certificate_name, ””)
and replace the line with:
SELECT @certificate_name = ”” + REPLACE(@certificate_name, ””, ”””) + ”’
Now hit Retry. You will probably get a new error along the lines of “Unable to Create database.”
Now open:
C:\Program Files (x86)\Steam\steamapps\common\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Data
and delete these files:
temp_MS_AgentSigningCertificate_database.mdf
temp_MS_AgentSigningCertificate_database_log.LDF
if they exist.
Finally go back to your installer and click on Retry again.
The installation *should* proceed smoothly. If it doesn’t, check the error logs in:
C:\Program Files (x86)\Steam\steamapps\common\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\LOG
to see if you can tell what’s tripping things up.
There’s also a problem where the installer tries to write the uninstall.exe file to the wrong directory. Haven’t found a fix for that yet, but hitting Ignore lets you finish the installation and run the tools. Might mean some manual registry cleaning some day when you uninstall the tools though.
More details can be found here:
http://social.bioware.com/forum/1/topic/8/index/109796/1
and here:
http://social.bioware.com/wiki/datoolset/index.php/Installation_with_Steam
I tested this on my Steam install but forum denizens say it works for Impulse as well.
[Updated the steps to take out a shortcut that may have been causing problems (see comments.)]
soooo how do you delete the temp_MS_AgentSigningCertificate_database_log.LDF files while the downloader is running it wont let me delete them
Hmm, I compressed two steps to make it simpler and maybe it won’t work that way.
What I actually did was get the first error, made the changes to sysdbupg.sql and hit Retry. I then got a new “Unable to create Database” error which led me to look at the error logs and discover what files I needed to delete.
So maybe try it that way?
I’m going to edit the original post to take out the ‘shortcut’.
Two things:
I found the correct line to replace with is this:
SELECT @certificate_name = ”” + REPLACE(@certificate_name, ””, ”””) + ””
Basically instead of ” you type two of ‘
And another thing about the Uninstaller, just create the folder BioWare in Common Files and it will put the Uninstaller there without an error.