Re: Connecting to SQL through ASP
From: Ken Schaefer (kenREMOVE_at_THISadOpenStatic.com)
Date: 04/30/03
- Next message: BigAl: "FTP Server on Win XP Pro"
- Previous message: Ann: "Connecting to SQL through ASP"
- In reply to: Ann: "Connecting to SQL through ASP"
- Next in thread: Tom Kaminski [MVP]: "Re: Connecting to SQL through ASP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Apr 2003 14:20:39 +1000
Because you have unchecked "allow anonymous access", all the stuff you have
done creating the IUSR accounts etc is not currently working. Renable
anonymous access and it should probably work.
At the moment, the webpages are using the user's NT credentials, however
unless you enable delegation, the webserver is unable to pass these
credentials to the machine running SQL Server.
Renable anonymous authentication if you want the IUSR_<machine> account to
be used to access the remote SQL Server.
Cheers
Ken
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "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???? : : Thanks : Ann
- Next message: BigAl: "FTP Server on Win XP Pro"
- Previous message: Ann: "Connecting to SQL through ASP"
- In reply to: Ann: "Connecting to SQL through ASP"
- Next in thread: Tom Kaminski [MVP]: "Re: Connecting to SQL through ASP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
