|
-
Jan 25th, 2010, 01:56 PM
#1
Thread Starter
Junior Member
Login failed for IUSR after IIS reinstallation
I have Windows XP Pro SP3. I had to uninstall and reinstall IIS. The problem is that now I cannot connect to sql server 2000 from an asp page using the Internet Guest Account (IUSR) (although I changed nothing is the sql server settings, where the user ERIC\IUSR_ERIC is declared as a db_owner in my database). I am receiving this error:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'ERIC\IUSR_ERIC'.
But I AM able to connect to sql server using a username and a password.
In other words, this connection string works:
Provider=SQLOLEDB.1;Initial Catalog=MyDB;Data Source=.;User Id=MyUser;Password=MyPass;
and this does not work:
Provider=SQLOLEDB.1;;Initial Catalog=MyDB;Data Source=.Integrated Security=SSPI;Persist Security Info=False
What can I do to connect with the second connection string?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|