7 réponses à ce sujet

[DanielSioli]

Hi,

I am unable to install DA Toolset because of a SQL Server Error that happens when the Microsoft SQL Server 2005 Setup is int the status "Configuring components..." for the "SQL Server Database Services" product.

I get the following error message: SQL Server failed to execute a command for server configuration. The error was [Microsoft] [SQL Native Client][SQL Server] Incorrect synthax near '='.. Refer to the Server error logs and Setup logs for detailed error information".

The options are "Retry" or "Cancel".

If I click "Retry", the same message appears. If I click "Cancel", it finishes the setup process, but the toolset doesn't work.

The log only says:"
MSI (s) (C4:14) [20:52:44:876]: Note: 1: 1708
MSI (s) (C4:14) [20:52:44:876]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

MSI (s) (C4:14) [20:52:44:876]: Windows Installer installed the product. Product Name: Microsoft SQL Server 2005 Express Edition. Product Version: 9.3.4035.00. Product Language: 1033. Manufacturer: Microsoft Corporation. Installation success or error status: 1603."

Can anyone help me? I'm running Windows 7 with UAC disabled. Thank you very much.

[Glowster]

I ran into a similar problem when I tried to install my DA toolset. I used google to look for answers and I did find a solution, I run Vista though:

Create a file in c:\\ called fixwmi.cmd (Text editor -> Save as -> Fixwmi.cmd)

@echo on
cd /d c:\\\\temp
if not exist %windir%\\\\system32\\\\wbem goto TryInstall
cd /d %windir%\\\\system32\\\\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End

:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer

:SkipSrv
goto End

:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End

Remember to run the file as Admin!

That fixed that problem, but then I ran into another one...

Modifié par Glowster, 27 décembre 2009 - 11:50 .

[DanielSioli]

Thanks for the reply. As you said you run into other problems, I've decided to google for more possible fixes. Don't know if version 1.01 works with no troubles. I'm still downloading it. Will report here.

I'll try this fix now: http://angrygamer09....windows-64-bit/

Just give me a second and I'll report here.

I'm using the Steam version of Dragon Age and my Windows is 64 bits.

Modifié par DanielSioli, 28 décembre 2009 - 01:44 .

[ladydesire]

You might have better luck with 1.01, since they relocated where the toolset database is stored in that version. You may also want to download the latest version of SQL server Express (2008) and try using that if 2005 still fails to install.

[DanielSioli]

No good.



I don't know if the guy meant for us to be using " or ', but none of them worked.



Tomorrow I'll try this one: http://www.evansims....-7-x64/#article



If that doesn't work, I'll try yours and see what next problem is...

[DanielSioli]

Worked!

When I've copied the line that guy wrote, I was getting the " character. But the correct character is '. So the correct line is:

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

and not

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

(don't know if the diference is noticible...)

In a nutshell, the fix that worked for me was:

1. Stop whatever you are doing when the error message appears;
2. Go to file C:\\\\Program Files (x86)\\\\Steam\\\\steamapps\\\\common\\\\dragon age origins\\\\tools\\\\toolssql\\\\MSSQL.1\\\\MSSQL\\\\Install\\\\sysdbupg.sql
3. Change the line

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

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

4. Save the file
5. Click "Retry"

Watch out for the ' character. It's ' not " (single, not double)

Modifié par DanielSioli, 28 décembre 2009 - 02:15 .

[DanielSioli]

ladydesire wrote...

You might have better luck with 1.01, since they relocated where the toolset database is stored in that version. You may also want to download the latest version of SQL server Express (2008) and try using that if 2005 still fails to install.

I'll try 1.01 too. I hope I won't step in any trouble, but I'll post here what happens. Thanks.

[DanielSioli]

Yep. 1.01 works fine. No fix needed.



The problem is restricted to version 1.00