What happens to Windows Authentication if domain failure occurs?

Vinodi

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

Subscribe Reply

1494

Simon Hayes

"Vinodi" <vi***********@ gmail.com> wrote in message
news:11******** **************@ c13g2000cwb.goo glegroups.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

Vinodi

Thanks for your advice. I will also post it in the Windows networking
forum.

Jul 23 '05 #3

Similar topics

699

34298

Python syntax in Lisp and Scheme

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 capabilities, unfortunately. I'd like to know if it may be possible to add a powerful macro system to Python, while keeping its amazing syntax, and if it could be possible to add Pythonistic syntax to Lisp or Scheme, while keeping all of the...

Python

23202

Active Directory Authentication in ASP

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 that seems to work in a majority of environments I have tested it in. I am posting it for the benefit of other developers trying to solve the same problem. Best regards,

ASP / Active Server Pages

4543

SQL Server 2000 and Windows 2003 SBS

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: 'HY000' SQL Server Error: 0 Cannot generate SSPI context. Any ideas? Is this a bug?

Microsoft SQL Server

2633

Windows Credentialing Security Problem

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 is not able to access a specific network resource and I just can't figure out why. First of all, let me say this worked fine with IIS running on Win2000 Server. This has not worked since I upgraded to Windows Server 2003. My Platform: Windows...

ASP.NET

1838

Anonymous access + Windows Authentication

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 file server. How can I use a fixed domain account to upload the files to the file server while still preserving the users' Windows integrated authentication on the web server?

ASP.NET

434

Windows Authentication through Active Directory

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 Pop up windows Authentication box so that user will give his userId, Password & domain name for authenticaion. After that I want to take these three info of user and make a search in Active Directory.

Visual Basic .NET

13808

About the web service using Integrated windows authentication

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 service run in an application pool which runs under a domain user, this domain user has permissions of accessing database and the connection to database is trusted connection. All these work well. The web application will be used in internet (not...

.NET Framework

1625

Running Console application from Windows Service on Win2k03

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 called executable. In event viewer I am seeing a two entries of below separated by 2 seconds: Event Type: Failure Audit Event Source: Security Event Category: Privilege Use

.NET Framework

5806

Asp Ldap authentication and redirection based on OU

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 this sorted to complete the intranet. Thx I've found the following code on this website and manage to get the username and password authentication working just need to figure out how to redirect to the OU. Thanks <!DOCTYPE HTML PUBLIC...

ASP / Active Server Pages

9734

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10395

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9211

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7673

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6895

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5561

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5700

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3874

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3026

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General