December 7, 2009 at 10:39 am
We added Adding Local Domain User Group to SQL LOGIN in non-cluster server and it added fine but when we try to add in active/active cluster node it gives following error msg:
Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'SQLNEWSERVER11\TSOperator' not found. Check the name again.
Cluster virtual names are:SQLNEWSERVER11 and SQLNEWSERVER10
Physical names:SQLNEWSERVER7 and SQLNEWSERVER8
December 7, 2009 at 11:33 am
The user would need to exist in a place where both nodes could reach it. In a cluster, you would be better served to add a Domain User. Here you are trying to add the local user from one server in the cluster that does not exist in the second server in the cluster.
Another thread with similar question
http://sql-server-performance.com/Community/forums/p/17229/100834.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply