Tuesday, July 28, 2009

Change SQL Server Collation in a clustered environment

start /wait D:\Servers\setup.exe /qn VS=[VIRTUALSERVER] INSTANCENAME=[MSSQLSERVER] REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=[CURRENT USERPASS] SAPWD=[sapassword] SQLCOLLATION=[NewCollation] SQLACCOUNT=[domain acct] SQLPASSWORD=[domainpass] AGTACCOUNT=[domainacct] AGTPASSWORD=[domainpss]

Make sure that ADMINPASSWORD is the current user's password and this user should have admin rights on all involved nodes.

3 comments:

Anonymous said...

Hi, I think your site might be having internet browser compatibility problems.
Whenever I take a look at your blog in Safari, it looks fine however when opening in Internet
Explorer, it's got some overlapping issues. I just wanted to provide you with a quick heads up! Apart from that, great website!

my webpage ... Replica Watches

Anonymous said...

Hey very interesting blog!

Feel free to surf to my web site - Replica Rolex Watches

Anonymous said...

Whats up are using Wordpress for your site platform? I'm new to the blog world but I'm trying to get started and create my own.
Do you require any html coding expertise to make your own blog?
Any help would be greatly appreciated!

Feel free to surf to my weblog: weight loss programs