MartinCroft
Programmer
We have a clustered SQL Server 2005 Enterprise SP2 instance where we cannot change the server collation using the following command
start /wait Z:\setup.exe /qb INSTANCENAME=SERVERNAME\SQL2005 REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=****** SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS AGTACCOUNT=DOMAIN\TEST_SQLAgent AGTPASSWORD=****** SKUUPGRADE=1 ADMINPASSWORD=****** SQLACCOUNT=DOMAIN\TEST_SQLsvr SQLPPASSWORD=******
We have tried various combinations of the above. Password removed for obvious reasons.
We have tried from the original location and tried other locations.
The steup runs through and when checking the log file in
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summay.txt is
Setup succeeded with the installation
however the collation does not change. Tried stopping starting SQL / running on Cluster/ each node, running without SQL Started. Same result seems to go through but no collation change
Dont believe this is a cluster issues as have replicated on another server (non clustered )with another SQL install (developer version) with the same results.
start /wait Z:\setup.exe /qb INSTANCENAME=SERVERNAME\SQL2005 REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=****** SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS AGTACCOUNT=DOMAIN\TEST_SQLAgent AGTPASSWORD=****** SKUUPGRADE=1 ADMINPASSWORD=****** SQLACCOUNT=DOMAIN\TEST_SQLsvr SQLPPASSWORD=******
We have tried various combinations of the above. Password removed for obvious reasons.
We have tried from the original location and tried other locations.
The steup runs through and when checking the log file in
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summay.txt is
Setup succeeded with the installation
however the collation does not change. Tried stopping starting SQL / running on Cluster/ each node, running without SQL Started. Same result seems to go through but no collation change
Dont believe this is a cluster issues as have replicated on another server (non clustered )with another SQL install (developer version) with the same results.
