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 ERICIUSR_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 'ERICIUSR_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?

Comments

  • I solved it using this:
    You will need to remove and the re-insert the IUSR account back to SQL Server because after IIS was reinstalled, the new IUSR accounts will have a new SID.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion