473,320 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

What happens to Windows Authentication if domain failure occurs?

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
2 1474

"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
Thanks for your advice. I will also post it in the Windows networking
forum.

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

699
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...
0
by: Michael B. Murdock | last post by:
I have been attempting to find a script that works in a variety of AD implementations to authenticate a user from a form in ASP. After many failed attempts I developed the following test script...
3
by: !!bogus | last post by:
I have XP workstations and windows 2003 SBS. I setup an ODBC for an application (tried both User and System DSN), but after a few usage, I get the following error: Connection failed: SQLState:...
2
by: Joseph Geretz | last post by:
I'm having a credentialing problem in my web application. Actually, I don't think this is an IIS security issue, since I'm able to access the page I'm requesting. However, the executing page itself...
11
by: Eric | last post by:
Hello, I have a web app that uploads files to a file server (different box than the web server). The application uses NT integrated authentication, but no users should have permissions to the...
0
by: Hriday | last post by:
Hi there, Please help me..It is urgent This is Hriday, working on windows authentication with Active Directory... My requirment is when a user sends a request to my web Applicatoin I want to...
3
by: =?Utf-8?B?RGFuZGFuIFpoYW5n?= | last post by:
Now I have a web application, a web service and a SQL Server database. The Web application will invoke the web service, the web service invokes the SQL Server stored procedure. I let the web...
0
by: =?Utf-8?B?U3RldmUgTWFydGlu?= | last post by:
I am attempting to launch a console application from a service under a different set of credentials running on Windows Server 2003. I am getting an error "0xC06D007E: Module not found." from the...
3
by: Genius79 | last post by:
Hi I'm trying to do an ASP authentication using Ldap and would like to have the users directed to pages based on the Organizational Unit. My ASP knowledge is pretty basic but would really like to get...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.