July 30, 2009 at 8:50 am
I have found little documentation and none that was helpful on this question. Here's the scenario, we're porting 2000 databases to 2005. The collation on all of the ported databases is: SQL_Latin1_General_CP1_CI_AS We don't have an option to change these as they come over (would involve some massive testing to make sure nothing is broken). We have a 2005 dev server we setup with the collation Latin1_General_CI_AS at the server level. Sometimes when a stored procedure uses a temp table an error gets thrown. After doing some research, I discovered that the error was related to incompatiable collations. I tested this by modifying the database collation to match the server. It worked perfectly after this, so it is a collation issue.
NOW TO THE QUESTION:
The 2005 server is running SP3. I need to change the collation. 2005 has the command line setup utility which should do just this. I got it to work with sample 2005 RTM and SP3 server, but when I try to rebuild the master on this one server I get the error:
"SQL Server Setup did not have the administrator permissions required to rename a file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again."
If I create a copy of the mssqlsystemresource1.ldf file and hit the retry it will continue, but I get some other strange errors down the line. I'm not sure that will do proper justice to the process either. Has anyone else had this issue or have some suggestions?
Cheers,
Brian
July 30, 2009 at 10:42 am
I had been there and tried what you are saying. But failed. You keep getting error now and then.
Finally, uninstalled 2005 from server and re-installed it with desired collation and its good now.
SQL DBA.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply