Wednesday, November 11, 2009

Installing the Dragon Age: Origins toolset with Windows 64 bit

A lot of people that purchased the game via Steam are getting the following error when they go to install the toolset:

"SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft] [SQL Native Client] [SQL Server]Incorrect syntax near '='. "

While there is a thread on the Bioware site to fix this it is like reading a post on the WoW forums about nerfing paladins. 6 pages of shit followed by maybe one page of good advice.

Here is what I did for the install to work. Run the setup and it will hang when you go to install MS SQL Server.

Stop what you are doing WHILE THE ERROR is on the screen and point yourself to (Windows Vista 64 bit):

C:Program Files (x86)Steamsteamappscommondragon age originstoolstoolssqlMSSQL.1MSSQLInstallsysdbupg.sql

Edit that with notepad.

Find the line

SELECT @certificate_name = QUOTENAME(@certificate_name, '''')

Replace it with

SELECT @certificate_name = '''' + REPLACE(@certificate_name, '''', '''''') + ''''

Save the file. If you cannot save the file, congrats on running your own operating system as a non administrator. Please uninstall Windows and learn to PC!

Hit the RETRY button.

Now it should run. It is important to leave the error window up as you do this, edit the file save it then hit RETRY. After all is said and done you will get one last error saying it cannot write to C:Program Files (x86)Common FilesBioware.

Simple fix here is go to C:Program Files (x86)Common Files and create the folder Bioware, then hit retry.

A pain in the ass I know but until Bioware fixes this that hack will have to do. The Bioware thread is here:

http://social.bioware.com/forum/1/topic/8/index/109796/3