Re: Connecting to SQL through ASP
From: Tom Kaminski [MVP] ((A_at_T))
Date: 04/30/03
- Next message: Jeff Cochran: "Re: CODE RED II, help...."
- Previous message: Tom Kaminski [MVP]: "Re: IIS fails with error "The IIS Admin Service service terminated unexpectedly""
- In reply to: Ann: "Connecting to SQL through ASP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Apr 2003 10:11:14 -0400
"Ann" <williaj@rrb.gov> wrote in message
news:9bfb47c2.0304292015.343782b6@posting.google.com...
> Guys I need your help.
>
> I think i have followed the instructions for connecting to SQL Server
> when IIS and SQL are on different machines, but I still get error,
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. What am I
> missing?
>
> IIS 5.0 machine running on win2000 pro
> Anonymous account IUSR_MACHINENAME was given password
> Authentication Method for the web was set to:
> Anonymous is not checked
> Basic is checked
> Integrated is checked
>
> SQL 7.0 machine running on win2000 pro
> Created local account with same name (IUSR_MACHINENAME) as IIS
> anonymous account and same password
> Gave this account log on locally rights and Access this computer from
> the network rights
> Added new login IUSR_MACHINENAME in SQL Enterprise manager and mapped
> it to the local account I created above
> Added this login to the database I want to access
> My connection string is:
> "Provider=SQLOLEDB.1;Initial Catalog=XXXXXXX;Integrated
> Security=SSPI;Data Source=XXXXXXX"
>
> Can anyone help????
Here are some handy references ...
http://support.microsoft.com/?id=247931
http://support.microsoft.com/?id=176380
http://support.microsoft.com/?id=176377
-- Tom Kaminski IIS MVP http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS http://mvp.support.microsoft.com/ http://www.microsoft.com/windowsserver2003/community/centers/iis/
- Next message: Jeff Cochran: "Re: CODE RED II, help...."
- Previous message: Tom Kaminski [MVP]: "Re: IIS fails with error "The IIS Admin Service service terminated unexpectedly""
- In reply to: Ann: "Connecting to SQL through ASP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
