SQL Server 2000 -collation.

[Former Member]

Hi,

If its important collation in SQL Server 2000, i have - SQL_Latin1_General_CP850_BIN(master, msdb, model etc.), but DB <SAP> haves SQL_Latin1_General_CP850_BIN2.

I try to change collation on the server by instcoll.exe but i have error:

C:\col\instcoll_i386>instcoll.exe -S server\DB

Trying to connect...

Could not connect to .. Trying to start the server.

[SQL-DMO]Service Control Error: The specified service does not exist as an inst

alled service.

Server and remote connection working.

BR,

T.

[clas_hortien]

Hi,

the syntax is wrong. Use

instcoll -S server -D database

See note 600027 for the exact syntax.

Regards

Clas

[Former Member]

Yes, is mandatory

[Former Member]

Hi,

Thanks for help, but im read this note and still not working, im use:

instcoll.exe -s<server>\<DBinstance> -D<dbname>

or

instcoll.exe -s<server>\<DBinstance>

And im still have error:

C:\col\instcoll_i386>instcoll.exe -s<server>\<DBinstance>

Trying to connect...

Could not connect to .. Trying to start the server.

[SQL-DMO]Service Control Error: The specified service does not exist as an inst

alled service.

Failed to start the server. Retrying.

[SQL-DMO]Service Control Error: The specified service does not exist as an inst

alled service.

Could not connect to .

NOTHING DONE!

BR,

T.

[Former Member]

Hi,

ececute only instcoll.exe on host where SQL server 2000 install.

on command prompt execute as follows, make sure SQL server is running

c:\col\instcoll.exe

regards,

kaushal

[clas_hortien]

Hello,

do you have a named instance installed and what is the name of the instance ?

What does the query

select @@servername

return ?

What is the name of the SID ?

Regards

Clas

[Former Member]

hi,

Thanks, its working. Im have changed sp4 on sp3 with hotfix 929, and everything its ok

BR,

T.