Weird Windows XP/IIS5/MSSQL 2000 Authentication Issue

[Josh T]

Hello,

For the past couple of days, I've been having a weird problem. I get the
following error when accessing web applications, both with Firefox or IE,
using Windows Integrated/Negotiate authentication:


Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/absentee/calendar.asp, line 53


As far as I can tell this problem is isolated to just myself, no one else
has called me to complain. What's weird is when this happens, I can
switch from my Windows XP PC to my Linux PC, connect to the web
application with Firefox and Basic Authentication and it works normally,
then switch back to my XP PC, reload the page and the error goes away and
the page loads as normal for a couple minutes. Does IIS cache
authentication or something? I can also, on my XP PC, configure Firefox
to use Basic auth instead of Negotiate, and it works & IE automatigally
works for a couple minutes as well as Firefox switched back to Negotiate.

My setup is:
Web Browser: up to date Mozilla Firefox or Internet Explorer, both using
Windows Integrated Authentication
OS: Windows XP SP2
IIS: IIS5 under Windows 2000 Server, programmed with VBScript/ASP Classic
DB: SQL Server 2000 under Windows 2000 Server

IIS and MSSQL are on separate servers and configured to pass Windows
Authentication from IIS to MSSQL. I have IIS set up to accept
Negotiate and Basic auth, no NTLM, as NTLM cannot be passed to MSSQL.

Database connection string is:

"Provider=SQLOLEDB;Server=SQLSERVER.mydomain.local;Database=Absentee;
Trusted_Connection=Yes;Network Library=dbnmpntw;"


Anyway, can anyone help pinpoint the cause of this issue? I'm guessing
its some sort of problem with Windows XP authentication libraries, but
could it also be IIS or MSSQL related?

Thanks,
Josh

 

[Tom Kaminski [MVP]]

Hello,

For the past couple of days, I've been having a weird problem. I get the
following error when accessing web applications, both with Firefox or IE,
using Windows Integrated/Negotiate authentication:


Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/absentee/calendar.asp, line 53

Start here:
http://www.aspfaq.com/show.asp?id=2009

 

[Josh T]

Start here:
http://www.aspfaq.com/show.asp?id=2009

Well, that didn't help at all. But anyway, I think I got it fixed. I
remembered that Windows XP is Microsoft Windows so I rebooted my PC and I
haven't had the problem in about a day now...

Thanks,
Josh

 

[Josh T]

For the past couple of days, I've been having a weird problem. I get the

following error when accessing web applications, both with Firefox or IE,
using Windows Integrated/Negotiate authentication:


Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/absentee/calendar.asp, line 53


As far as I can tell this problem is isolated to just myself, no one else
has called me to complain. What's weird is when this happens, I can
switch from my Windows XP PC to my Linux PC, connect to the web
application with Firefox and Basic Authentication and it works normally,
then switch back to my XP PC, reload the page and the error goes away and
the page loads as normal for a couple minutes. Does IIS cache
authentication or something? I can also, on my XP PC, configure Firefox
to use Basic auth instead of Negotiate, and it works & IE automatigally
works for a couple minutes as well as Firefox switched back to Negotiate.

My setup is:
Web Browser: up to date Mozilla Firefox or Internet Explorer, both using
Windows Integrated Authentication
OS: Windows XP SP2
IIS: IIS5 under Windows 2000 Server, programmed with VBScript/ASP Classic
DB: SQL Server 2000 under Windows 2000 Server

IIS and MSSQL are on separate servers and configured to pass Windows
Authentication from IIS to MSSQL. I have IIS set up to accept
Negotiate and Basic auth, no NTLM, as NTLM cannot be passed to MSSQL.

Database connection string is:

"Provider=SQLOLEDB;Server=SQLSERVER.mydomain.local;Database=Absentee;
Trusted_Connection=Yes;Network Library=dbnmpntw;"


Anyway, can anyone help pinpoint the cause of this issue? I'm guessing
its some sort of problem with Windows XP authentication libraries, but
could it also be IIS or MSSQL related?

Well, I rebooted my PC on Thursday and this problem went away for a while,
but it came back on Monday afternoon. Anyone know a more permanent fix
than just to reboot everytime it happens?

Thanks,
Josh