Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Login failed for IUSR after IIS reinstallation

4 views
Skip to first unread message

Hra_Ioannoy

unread,
Jan 25, 2010, 12:14:57 PM1/25/10
to
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?

Geoff Schaller

unread,
Jan 25, 2010, 7:25:16 PM1/25/10
to
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.

"Hra_Ioannoy" <verb...@gmail.com> wrote in message
news:e8c7b3a2-0943-4270...@c34g2000yqn.googlegroups.com:

Hra_Ioannoy

unread,
Jan 25, 2010, 9:42:05 PM1/25/10
to
It worked.
Thanks a lot.


On 26 Ιαν, 02:25, "Geoff Schaller" <geo...@softxwareobjectives.com.au>
wrote:


> 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.
>

> "Hra_Ioannoy" <verb1...@gmail.com> wrote in message


>
> news:e8c7b3a2-0943-4270...@c34g2000yqn.googlegroups.com:
>
>
>
> > 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?- Απόκρυψη κειμένου σε παράθεση -
>
> - Εμφάνιση κειμένου σε παράθεση -

0 new messages