Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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