SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Cluster, how to add local server account to virtual server?


SQL Server Cluster, how to add local server account to virtual server?

Author
Message
hrhenja
hrhenja
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 106
I recently set up 2 Clustered Nodes (SQL Server 2005) on 2 Windows 2008 boxes, and the cluster works fine. Prior to me clustering the 2 SQL Servers, the single SQL server that was in place had one local user account which we must keep locally on the server ... As I expected, I created the local user on each node in the cluster and when I try to add it to the Virtual Server logins, I get the error below ... Is there any work around to add a Windows local user to a cluster without using a domain account?

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Login '********'. (Microsoft.SqlServer.Smo)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Windows NT user or group '********' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
happycat59
happycat59
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8453 Visits: 3281
It does not make sense to me for you to add a local user to an instance of SQL Server on a cluster. You really need to consider that the resources etc that are required should be resources that will be available when one of the servers in the cluster has failed.

Hence, if your cluster consists of serverA and serverB and you create a user on serverA. What do you expect to be able to do when the active node is serverB and serverA is down ? You certainly cannot expect to be able to logon with that user because you cannot validate the credentials of the user.



hrhenja
hrhenja
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 106
Thank you very much for your reply, and I certainly share your concern about what would happen when one node fails over to the other. I probably should have done a better job explaining the situation. Before clustering the server, the single SQL server node was communicating with a web server on a specific application which by design required the use of a local user account on the SQL server, which I will check into as I also believe it should be changed ... After I installed the cluster, I added that local user account to both nodes ... hoping that the virtual SQL Server would let me add that local account as a user ... which now that I think about does not make much sense :-) one is because although the 2 users accounts are identical on both servers they user different sids of course and two, from what I read so far, in clustering, only domain accounts should be used ... I would appreciate any other suggestions.

Thanks,

-Sean
happycat59
happycat59
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8453 Visits: 3281
your options are either a domain account or a sql server login. The web application should be able to handle both - it should have a configuration setting somewhere that allows you to set this up. It is fairly common to use a single sql server login for web applications althoug, if you can, use a domain account.



hrhenja
hrhenja
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 106
I appreciate you reply. We ended up making some changes and used a domain account for that purpose ... the problem is solved.

Thank you for the insight, it was very helpful.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search