27 réponses à ce sujet

[indio]

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '='.. Refer to the server error logs and Setup logs for detailed error information.

For help, click: http://go.microsoft....upg.sql@119@x66

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------

Modifié par indio, 06 novembre 2009 - 07:41 .

[indio]

Well, it won't let the toolset start, as it turns out. Looking for a solution now.

[CID-78]

the toolset require a working MSSQL database but i am not sure if that command will break it.

[Neon0x]

Let me guess. You got DA:O off steam?





Appears to be a problem with where the game install, as it installs it in a directory that is longer then 58 characters long, and the SQL server cant be installed when that's the case.

[carlosjuero]

Make sure to check this page: http://social.biowar...troubleshooting for help on installation.



I had no issues installing but then I already had MSSQL installed for my development work.

[indio]

Neon0x wrote...

Let me guess. You got DA:O off steam?


Appears to be a problem with where the game install, as it installs it in a directory that is longer then 58 characters long, and the SQL server cant be installed when that's the case.

It's from Steam, yes.

Any ideas on what to do, besides buy another copy?

[Wannabeuk]

So, currently steam users cannot install it?



Or is there a fix available for this issue floating around? as the help suggesting installing it to a shorter path is not an option.

[Neon0x]

indio wrote...

Neon0x wrote...

Let me guess. You got DA:O off steam?


Appears to be a problem with where the game install, as it installs it in a directory that is longer then 58 characters long, and the SQL server cant be installed when that's the case.

It's from Steam, yes.

Any ideas on what to do, besides buy another copy?

Wait for Bioware to fix it I suppose. If they can.


Maybe they will release the toolset on steam, specificly made for it, that would be nice.

[Allan Smith]

don't go buying another copy, it looks like a directory length issue with SQL Server. We are working on it.

[indio]

Neon0x wrote...

indio wrote...

Neon0x wrote...

Let me guess. You got DA:O off steam?


Appears to be a problem with where the game install, as it installs it in a directory that is longer then 58 characters long, and the SQL server cant be installed when that's the case.

It's from Steam, yes.

Any ideas on what to do, besides buy another copy?

Wait for Bioware to fix it I suppose. If they can.

I physically flinched when I saw this.
I will do no such thing. In the best spirit of capitalist excess I shall march down to my computer store and buy a physical copy.

Edit: Or I could wait....but knowing the toolset is out and not being able to use it is about more than I can bear.

Modifié par indio, 06 novembre 2009 - 07:03 .

[Neon0x]

indio wrote...

Neon0x wrote...

indio wrote...

Neon0x wrote...

Let me guess. You got DA:O off steam?


Appears to be a problem with where the game install, as it installs it in a directory that is longer then 58 characters long, and the SQL server cant be installed when that's the case.

It's from Steam, yes.

Any ideas on what to do, besides buy another copy?

Wait for Bioware to fix it I suppose. If they can.

I physically flinched when I saw this.
I will do no such thing. In the best spirit of capitalist excess I shall march down to my computer store and buy a physical copy.

But Allan says not ot buy another copy... Would you defy him?

edit: Bleh, you edit

Modifié par Neon0x, 06 novembre 2009 - 07:05 .

[Wannabeuk]

It just need a code change in the Sysdbupg.sql, however we can get access to the file as its inside the .exe, this is a SQL server issue NOT a toolset issue.



However information can be found here :

http://support.microsoft.com/kb/935371

[indio]

I don't want to:

a) Defy Allan

Buy another copy

c) Wait another day to use the toolset



I pre-odered a physical copy anyway, and I own 3 copies of BG, 2 of NWN, so buying anoither cop was always on the cards. I'll just do it today rather than later.

[Jake_Farrell]

carlosjuero wrote...

Make sure to check this page: http://social.biowar...troubleshooting for help on installation.

I had no issues installing but then I already had MSSQL installed for my development work.

as i had the same issues..

first : yes my version is from steam , and if that is an issue, i hate it ...

second : "login required" , and account creation is not possible... so i cant read it


i hope this thing will be very soon fixed..
if not , my plans are all gone ..

[indio]

They'll need to edit the exe, and then have it pass through their QA stream, and it's about to be the weekend. In about 4 hours I'm buying my physical copy.

[pl1ght]

Just saw the message they are working this, but still chiming in that I am another Steam user with this issue. Thanks.

[Hazado22]

Wannabeuk wrote...

It just need a code change in the Sysdbupg.sql, however we can get access to the file as its inside the .exe, this is a SQL server issue NOT a toolset issue.

However information can be found here :
http://support.microsoft.com/kb/935371

Doing this fix does not work, I just tried it.

the file sysdbupg.sql is located at C:\\Program Files (x86)\\Steam\\steamapps\\common\\dragon age origins\\tools\\toolssql\\MSSQL.1\\MSSQL\\Install

[indio]

Hazado22 wrote...

Wannabeuk wrote...

It just need a code change in the Sysdbupg.sql, however we can get access to the file as its inside the .exe, this is a SQL server issue NOT a toolset issue.

However information can be found here :
http://support.microsoft.com/kb/935371

Doing this fix does not work, I just tried it.

the file sysdbupg.sql is located at C:\\\\Program Files (x86)\\\\Steam\\\\steamapps\\\\common\\\\dragon age origins\\\\tools\\\\toolssql\\\\MSSQL.1\\\\MSSQL\\\\Install

Pretty sure when he says "Can" he means "Can't".

[Hazado22]

Okay This fix does work! Do what is says there



http://support.microsoft.com/kb/935371

the file sysdbupg.sql is located at C:\\Program Files (x86)\\Steam\\steamapps\\common\\dragon age origins\\tools\\toolssql\\MSSQL.1\\MSSQL\\Install



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

[indio]

Hazado22 wrote...

Okay This fix does work! Do what is says there

http://support.microsoft.com/kb/935371
the file sysdbupg.sql is located at C:\\\\Program Files (x86)\\\\Steam\\\\steamapps\\\\common\\\\dragon age origins\\\\tools\\\\toolssql\\\\MSSQL.1\\\\MSSQL\\\\Install

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

Trying now.

[Astorax]

The issue is the length of the path that Steam uses to install...it's longer than 58 characters, which is beyond the limit that SQL servers are setup to handle.

[snakehunta]

Yup, got it to work. However, the uninstaller for the toolset failed to copy over, but whatever.

[Hazado22]

Astorax wrote...

The issue is the length of the path that Steam uses to install...it's longer than 58 characters, which is beyond the limit that SQL servers are setup to handle.

http://support.microsoft.com/kb/935371

[indio]

Thanks Hazardo22. You're my hero, mate.

[xCantoniousx]

indio wrote...

Hazado22 wrote...

Okay This fix does work! Do what is says there

http://support.microsoft.com/kb/935371
the file sysdbupg.sql is located at C:\\Program Files (x86)\\Steam\\steamapps\\common\\dragon age origins\\tools\\toolssql\\MSSQL.1\\MSSQL\\Install

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

Trying now.

Just confirming that this works.