Logon-problems with asp to SQL-Database

Hi,

i want to connect my asp-application to a database running on a ms-sql-2000-server. These application is running only in our intranet. I've selected on the SQL-Server and on the IIS the Windows- Authentification. If I connect MS-Access with the DSN to the database, it works without problems. The NTFS-Authentification to the application is also no problem. But I can't connect the ASP-Application to the SQL-Database, caused by insufficient rights.

I got the following Error-Message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei der Anmeldung für den Benutzer 'NT-AUTORITÄT\ANONYMOUS-ANMELDUNG'.

/lmk/test.asp, line 12

An extract of the code with the error:
strConn = "DSN=W2K08_LMK"
set conn = server.createobject("adodb.connection")
conn.open strConn

I'm logged in as Domain-admin! What`s wrong

Thanks!!

Kindly Regards Albert





From http://www.developmentnow.com/g/61_0_0_0_0_0/inetserver-asp- db.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Re: Logon-problems with asp to SQL-Database

Albert wrote:
> Hi,
>
> i want to connect my asp-application to a database running on a
> ms-sql-2000-server. These application is running only in our
> intranet. I've selected on the SQL-Server and on the IIS the Windows-
> Authentification. If I connect MS-Access with the DSN to the
> database, it works without problems. The NTFS-Authentification to the
> application is also no problem. But I can't connect the
> ASP-Application to the SQL-Database, caused by insufficient rights.
>
> I got the following Error-Message:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei der
> Anmeldung für den Benutzer 'NT-AUTORITÄT\ANONYMOUS-ANMELDUNG'.
>

http://www.aspfaq.com/show.asp?id=2126

If that does not help, then
http://www.aspfaq.com/show.asp?id=2138

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.