SQL SERVER FAILOVER CLUSTER INSTALLATION 1

[UPETEK]

I have a Win2K cluster installation by 2 nodes.Cluster system is working properly and I want to install MSSQLSERVER 2000 to the cluster system.When I start to installation I come to the "SERVICES ACCOUNTS" screen and I have to select "Use Local Settings Account", but thet option is unable.How can I use that option?
Although it is diasabled I have installed SQLServer 2000, but "sa" pasword gets automatically password.Althoguhn I have select balnk password option it doesn't accep it.How can I set "sa" w/out password?

Ugur PETEK

 

[tlbroadbent]

The Services Accounts are Windows logins, not SQL Server logins. SQL Server must start as a service in WIN2K and uses a WIN2K account to do so. You cannot use SA unless it is also a Windows login but this is not recommended.

I don't use clustered servers but have read that the SQL Server Service Accounts must be Domain accounts rather than local accounts when installing SQL Server on a cluster. That is why the Local option is disabled.

I recommend that you give the SA login a secure passwaord. Leaving it null opens the entire server to anyone who can get to the server. Anyone logging in as SA will have full System Administrator priveleges. This would not be good in any environment but is very bad when the server is open to a WAN or the Internet. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.