Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Domain Authantication and SQL Server

We have 3 Windows Server 2003 boxes on our domain and we are having the following issue.   One box is a SQL server (2000), the other two are DC's.   One of the DC's holds all the roles except for operations master.  When that machine is rebooted all the requests to SQL DB fail since we are using domain accounts to access the DB.   Is this the way it is supposed to work, or should the authentication requests from SQL just goto the second DC when DC #1 is unavailable?  Do I have to change a setting in SQL to get this to work differently?
0
pamsauto
Asked:
pamsauto
  • 3
1 Solution
 
KCTSCommented:
Please explain what you mean by >> except for operations master <<
Do you mean ALL of the FSMO roles, if so it it safe to assume that another DC (or DCs) are available that are aslo Global Catalog Servers and DNS servers.
0
 
pamsautoAuthor Commented:
Yes the DC #1 has all the FSMO Roles.  Both DC are GC Servers and DNS Servers.  
0
 
Eugene ZCommented:
it is not good
your AD setup is not finished - you need to setup DC replication, etc - so if 1 DC is down 2nd will take primary role and you can login on box and sql server
Let say - you need AD admin to do it
As alternative for now - set sql logins instead of NT login...

as per post above
http://en.wikipedia.org/wiki/Flexible_single_master_operation
0
 
pamsautoAuthor Commented:
Can you point me to any atriles about DC replication
0
 
pamsautoAuthor Commented:
Articles that is!
0

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now