Ask a Question related to ASP Database, Design and Development.
-
bob N #1
IIS not connecting to SQL 2K
Hello all,
I am being puzzled by an error that I receive when connectiong to a
SQL box, from an ASP page.
Here is the situation:
SQLBox runs SQL 2K 8.00.534 (SP2) on Win2K SP3 ; SQL runs under a
domain account with local admin privileges.
IISBox runs IIS ( I don't know what version, I think it's 4, it does
not look like 5; it's what came with Win2k) on Win 2K SP3 ; IIS runs
under lsa.
My (simple) ASP code looks like this (stored in myTest.asp in
wwwroot\myTestDir:
<%@ Language = "VBScript" %>
<html> <head> <title> test page </title> </head>
<body>
<%
set cn= CreateObject("ADODB.Connection")
cn.Open ("Provider=SQLOLEDB;Data Source=SQLBox;Initial
Catalog=master;Integrated Security=SSPI;Network Library=DBMSSOCN")
cn.close
%>
</html>
And what I get looks like (among other things):
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
SQL access is OK; connecting with Win authentication from Query
analyzer is perfect.
The IIS settings seem to be OK (Directory security/Authentication
methods set to "Integrated Windows Authentication")
And the fun part:
Nothing could fix this, except logging locally on IISBox and browsing
to http:://localhost/myTestDir/myTest.asp
From anywhere else, browsing to http:://IISBox/myTestDir/myTest.asp
will raise the same connect error.
Our DC is still NT4 (I don't know more details).
I strongly suspect that somehow the credentials are not being passed
properly between the browser, IISBox and SQLBox.
Searching usenet, the MS Kb, aspfaq.com ,etc. etc. did not yield any
result (or drowned me in too many)
Anybody having an idea ?
Thanks for reading (and replying).
BN
PS Switching to SQL standard security is not an option.
bob N Guest
-
connecting...
we're having a hard time connecting to the server so we can let others make changes to the pages. we know we can connect to the server through our... -
Connecting without RDS? Please help!
Hi there, I'm trying to connect to an Access database through Dreamweaver. My hosting is on a shared server and so they won't give me access to... -
connecting VS.NET to IIS-what do I have to do
Using the first version of VisualStudio.NET and, I believe, IIS 5 (the one that comes with Server 2000) when I launch the ASP.NET application... -
ASP.NET connecting to SQL DB
I'm having trouble connecting to an SQL database in Dreamweaver. I've typed in the correct parameters, but I get an "Http Error Code 403 Forbidden"... -
Connecting G5 to a TV
I am thinking of ordering a G5 but have only the money to buy the machine plus software. I want to replace my 3 year old imac. Since I have an... -
Bob Barrows #2 Re: IIS not connecting to SQL 2K
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;176377[/url]
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;307002[/url]
HTH,
Bob Barrows
bob N wrote:> Hello all,
>
> I am being puzzled by an error that I receive when connectiong to a
> SQL box, from an ASP page.
> Here is the situation:
>
> SQLBox runs SQL 2K 8.00.534 (SP2) on Win2K SP3 ; SQL runs under a
> domain account with local admin privileges.
> IISBox runs IIS ( I don't know what version, I think it's 4, it does
> not look like 5; it's what came with Win2k) on Win 2K SP3 ; IIS runs
> under lsa.
>
> My (simple) ASP code looks like this (stored in myTest.asp in
> wwwroot\myTestDir:
>
> <%@ Language = "VBScript" %>
> <html> <head> <title> test page </title> </head>
> <body>
> <%
> set cn= CreateObject("ADODB.Connection")
> cn.Open ("Provider=SQLOLEDB;Data Source=SQLBox;Initial
> Catalog=master;Integrated Security=SSPI;Network Library=DBMSSOCN")
> cn.close
> %>
> </html>
>
> And what I get looks like (among other things):
>
> Microsoft OLE DB Provider for SQL Server (0x80040E4D)
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>
> SQL access is OK; connecting with Win authentication from Query
> analyzer is perfect.
> The IIS settings seem to be OK (Directory security/Authentication
> methods set to "Integrated Windows Authentication")
>
> And the fun part:
> Nothing could fix this, except logging locally on IISBox and browsing
> to http:://localhost/myTestDir/myTest.asp
> From anywhere else, browsing to http:://IISBox/myTestDir/myTest.asp
> will raise the same connect error.
>
> Our DC is still NT4 (I don't know more details).
> I strongly suspect that somehow the credentials are not being passed
> properly between the browser, IISBox and SQLBox.
> Searching usenet, the MS Kb, aspfaq.com ,etc. etc. did not yield any
> result (or drowned me in too many)
>
> Anybody having an idea ?
>
> Thanks for reading (and replying).
> BN
>
> PS Switching to SQL standard security is not an option.
Bob Barrows Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
