Weird Windows XP/IIS5/MSSQL 2000 Authentication Issue



Josh T
07-10-2005, 02:52 AM
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]
07-10-2005, 02:52 AM
"Josh T" <josht@ihatespam.invalid> wrote in message
news:pan.2005.05.19.14.57.05.117588@ihatespam.invalid...
> 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

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserver2003/community/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS

Josh T
07-10-2005, 02:53 AM
On Thu, 19 May 2005 11:06:14 -0400, Tom Kaminski [MVP] wrote:
> 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
07-10-2005, 02:53 AM
> 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


Weird Windows XP/IIS5/MSSQL 2000 Authentication Issue