November 3, 2008 at 6:00 am
[font="Verdana"]Hi,
We have got an issue in SQL server 2005 installation. We have Windows 2003 Server and Regional settings as English(United Kingdom). While installing the SQL server 2005 the default Collation setting is selected as "SQL_Latin1_General_CI_AS". Since all our SQL servers are using "SQL_Latin1_General_CP1_CI_AS" collation format, We have selected "SQL_Latin1_General_CP1_CI_AS" as the collation. But after completing the installation the master database has the collation format as "SQL_Latin1_General_CI_AS" instead of one we have selected "SQL_Latin1_General_CP1_CI_AS".
Please suggest what we need to do?
Thanks in advance..:)[/font]
November 3, 2008 at 7:15 am
You would need to ensure the server collation is set to what you would expect and rebuild your master database (and any others).
http://support.microsoft.com/kb/325335
Read the section on rebuilding master. It sounds like its a new server and not production yet, if so there’s not much to lose.
Out of curiosity though, why bother? The other servers have the default collation for 2000 (guessing they are 2000 servers). This is the default for 2005. Why do you want/need to change?
Good luck 😎
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 4, 2008 at 3:31 am
In order to change the collation for the master database you need to rebuild the system database using the installation procedure through the command prompt. Copy the SQL Server software installation files to a local directory on your server (e.g. C:\Temp), open a command prompt and enter the following command:
start /wait C:\Temp\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="Enter password" SQLCOLLATION="Enter Collation"
Remember, if you've installed service packs you will need to reapply these, and if you've moved the system databases you will need to move them following this procedure. The above code also assumes that it's the default instance you want to change and not a named instance.
All the info you need you should find here:
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx#rebuilddatabase
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply