Difference between revisions of "Installation into a directory with a long path name"
(→Workaround) |
|||
| (11 intermediate revisions by 9 users not shown) | |||
| Line 1: | Line 1: | ||
| + | *'''Version found:''' 1.0.982.19<!-- put the version number of your toolset here --> | ||
| + | *'''Status:''' Fixed. Version 1.01 of the toolset installer installs the SQL instance to a shorter path to avoid this issue. It now installs to Program Files\DAODB\ | ||
| + | |||
| + | == Description == | ||
| + | <!-- Describe the bug here including as many details as possible. What situations trigger it and what effects it causes are the most important. --> | ||
| + | |||
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 | 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 | ||
| Line 5: | Line 11: | ||
"SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft] [SQL Native Client] [SQL Server]Incorrect syntax near '='. " | "SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft] [SQL Native Client] [SQL Server]Incorrect syntax near '='. " | ||
| − | + | == Workaround == | |
| − | Open the file \ | + | A workaround has been developed that allows installation to work correctly. |
| + | |||
| + | Open the file C:\games\BioWare\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Install\Sysdbupg.sql | ||
Find the line [it's near the bottom] that reads: | Find the line [it's near the bottom] that reads: | ||
| Line 21: | Line 29: | ||
Re-install toolset. | 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 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. When attempting to save the modified version you may encounter a message saying that the file cannot be saved because it is in use. In this case save the edited file elsewhere with the same name (Sysdbupg.sql), then drag the the modified version into the correct folder and select the copy and replace option. Then click "retry" on the error message. |
| − | + | Alternatively, if you can't find these files due to the \tools\toolssql\ folder only containing one empty folder named Data, you may need to uninstall MSXML6 SP2 (which was improperly installed during a Windows Update) using the [http://support.microsoft.com/kb/290301 Microsoft Windows Installer CleanUp Utility], before reinstalling the toolset. | |
| + | If you still run into problems, Delete temp_MS_AgentSigningCertificate_database.MDF and LDF from C:\games\BioWare\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Data | ||
You may also run into the following error message: | You may also run into the following error message: | ||
| Line 32: | Line 41: | ||
This one can be worked around by replacing the Sysdbupg.sql file with a blank file of the same name. | This one can be worked around by replacing the Sysdbupg.sql file with a blank file of the same name. | ||
| + | How to edit sql files for the technologically challenged: | ||
| − | + | *Copy the Sysdbupg.sql file to your desktop. | |
| − | + | *Open it with Notepad. You will probably have to select Notepad manually from the list. | |
| − | + | *Make changes. | |
| − | + | *Save to your desktop. | |
| − | + | *Cut/paste the Sysdbupg.sql from your desktop back into its original folder. | |
| − | + | *Choose to replace the file. | |
| − | [[Category: | + | [[Category:Closed bugs]] |
Latest revision as of 03:44, 24 November 2010
- Version found: 1.0.982.19
- Status: Fixed. Version 1.01 of the toolset installer installs the SQL instance to a shorter path to avoid this issue. It now installs to Program Files\DAODB\
Description
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 '='. "
Workaround
A workaround has been developed that allows installation to work correctly.
Open the file C:\games\BioWare\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Install\Sysdbupg.sql
Find the line [it's near the bottom] 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. When attempting to save the modified version you may encounter a message saying that the file cannot be saved because it is in use. In this case save the edited file elsewhere with the same name (Sysdbupg.sql), then drag the the modified version into the correct folder and select the copy and replace option. Then click "retry" on the error message.
Alternatively, if you can't find these files due to the \tools\toolssql\ folder only containing one empty folder named Data, you may need to uninstall MSXML6 SP2 (which was improperly installed during a Windows Update) using the Microsoft Windows Installer CleanUp Utility, before reinstalling the toolset.
If you still run into problems, Delete temp_MS_AgentSigningCertificate_database.MDF and LDF from C:\games\BioWare\dragon age origins\tools\toolssql\MSSQL.1\MSSQL\Data
You may also run into the following error message:
"SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed."
This one can be worked around by replacing the Sysdbupg.sql file with a blank file of the same name.
How to edit sql files for the technologically challenged:
- Copy the Sysdbupg.sql file to your desktop.
- Open it with Notepad. You will probably have to select Notepad manually from the list.
- Make changes.
- Save to your desktop.
- Cut/paste the Sysdbupg.sql from your desktop back into its original folder.
- Choose to replace the file.
