Pau Lo
asked on
cluster setup for HA and security
I am new to SQL Server clusters for HA, but from a security angle, say for example you have 10 SQL Servers in the cluster, and Server 1 dies, do Server 2 takes on the databases in Server 1 - how are the logins in Server 1 carried over so users can still login and access their databases? Or do you have to clone all accounts on all servers so they can still login to any server. This seems hugely unsecure to me, as users who need access to a DB on server 1 will have no requirement to access DB's on other servers in the node. So how does it work? Please keep answers basic for someone new to this.
ASKER
Will take a read through, although I have no involvement in DB management, nor setting up a failover cluster, and I just wanted to know the answer to the security related question above. I'll read through and see if it answers my question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would like to refer you to a wonderful article by microsoft that explains how to create a failover Cluster. I think you will find it very informative for your needs :)
http://msdn.microsoft.com/en-us/library/ms179530.aspx
In addition refer to the other articles in this series to move forward :)