NS and SQL 2005

dominique · 08-28-2008, 09:14 PM

Hello,

My server SQL Server 2005 Enterprise SP 2 was configured with a collation Latin1_General_CP1_CS_AS and when I restored the database from the old server SQL 2000 SP4 collation Latin1_General_CP1_CI_AS the NSSetup failed during the installation complaining about a incompatibility between the two collations.

Now I am trying to uninstall SQL 2005 Server with ARPWrapper /Remove which is giving tons of errors...
The Local Groups have been deleted.
the folders have been deleted
the Virtual Directory and Application Pool have been deleted.
the services are disabled.
(Microsoft KB How to uninstall an instance of SQL Server 2005 manually)

but still something is not clean...

If I try to install SQL2005 again it will not give me the option to change the collation.
How to clean up SQL Server 2005 ?

What did I miss?

Thanks

dominique · 08-29-2008, 01:17 PM

As there is no easy way to do it, having a clean uninstall of SQL 2005 Server (dixit msdn) I will start rebuilding the server completely from the OS, SQL, etc...

BTW does anybody knows which collation should be there as SQL_Latin1_General_CP1_CS_AS does not collaborate well with old Altiris DB SQL_Latin1_General_CP1_CI_AS ?

What will be the changes to be done to move from one collation to the other when upgrading to NS 7 as it seems ONLY SQL_Latin1_General_CP1_CS_AS is advised...?

Thanks,