By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,414 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,414 IT Pros & Developers. It's quick & easy.

What happens to Windows Authentication if domain failure occurs?

P: n/a
Hi,

I have a peculiar problem (or maybe not). I have SQL clients installed
on XP boxes. These XP boxes are a member of let us say "XYZ" domain.
SQL Server is installed on one of the boxes having Windows 2000 Server
in the same network. The installation has been done on local domain
account. Since SQl Server has been installed with Windows
authentication, what happens if the XYZ domain fails. Will it be
possible for all clients to access the database present on SQL Server
in the Win 2K box. I think I have made myself clear upto some extent.
Please throw light on how to accomplish the connectivity between SQL
clients and server in case of domain failure.

Regards,

Vinodi

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Vinodi" <vi***********@gmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Hi,

I have a peculiar problem (or maybe not). I have SQL clients installed
on XP boxes. These XP boxes are a member of let us say "XYZ" domain.
SQL Server is installed on one of the boxes having Windows 2000 Server
in the same network. The installation has been done on local domain
account. Since SQl Server has been installed with Windows
authentication, what happens if the XYZ domain fails. Will it be
possible for all clients to access the database present on SQL Server
in the Win 2K box. I think I have made myself clear upto some extent.
Please throw light on how to accomplish the connectivity between SQL
clients and server in case of domain failure.

Regards,

Vinodi


This seems more like a general Windows networking question - can clients
authenticate to a specific server when no domain controller is available? As
far as I know, clients which have already connected to the server can
continue to do so, because the server will have cached their credentials;
clients which have not yet connected will not be able to.

But I must admit that I'm not 100% sure about that, so you may want to ask
in a Windows networking forum. In any case, assuming you have multiple
domain controllers and you are able to respond quickly when one goes down,
then it should be difficult to lose the whole domain.

Simon
Jul 23 '05 #2

P: n/a
Thanks for your advice. I will also post it in the Windows networking
forum.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.