Difference between revisions of "Installation into a directory with a long path name"

Revision as of 21:29, 6 November 2009

MSSQL Express 2005's installer has a limitation that prevents it from installing to a directory path that's longer than 58 characters. Microsoft's Knowledge Base has details here: http://support.microsoft.com/kb/935371

Unfortunately, the default installation path used by Steam goes over this limit. When you hit this error you'll get the error message

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

A workaround has been developed that allows installation to work correctly, however.

Open the file \Steam\steamapps\common\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Install\Sysdbupg.sql

Find the line that reads:

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

Replace it with the following line:

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

Re-install toolset.

If you can't find these files, you can try doing it while the installation process is ongoing. When the error message above pops up, edit the Sysdbupg.sql file and then click "retry" after you save the modified version.

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