System.Data.SqlClient.SqlException: Login failed for user NT AUTHORITYIUSR

svibuk
 
on Jun 21, 2012 02:22 AM
7407 Views

after publishing the web application , created a virtual directory and configured in IIS

when accessing the web application usingg IIS i get sql connectiing string error

i think it not able to read the connection string

<appSettings>
     <add key="ConnString" value="Initial Catalog=DB1;Data Source=1SERVER;User ID=sa;Password=ss;Connect Timeout=9000;Pooling=false;Enlist=false;Integrated Security=SSPI;" />
so i get error
System.Data.SqlClient.SqlException:
Login failed for user 'NT AUTHORITY\IUSR'. at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser

 

but directly using VS its able to reead the connection

Download FREE API for Word, Excel and PDF in ASP.Net: Download
svibuk
 
on Jun 21, 2012 11:20 AM
on Jun 21, 2012 11:23 AM

error resolved by removing integrated security