Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Cluster, how to add local server account to virtual server? Expand / Collapse
Author
Message
Posted Thursday, May 7, 2009 3:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 8:23 AM
Points: 9, 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)


Post #712466
Posted Thursday, May 7, 2009 10:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:16 PM
Points: 2,922, Visits: 2,521
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.



Post #712622
Posted Thursday, May 7, 2009 10:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 8:23 AM
Points: 9, 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
Post #712625
Posted Friday, May 8, 2009 3:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:16 PM
Points: 2,922, Visits: 2,521
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.




Post #712752
Posted Monday, May 11, 2009 9:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 8:23 AM
Points: 9, 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.
Post #714226
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse