I just installed the CSK and chose the option to use Windows authentication. However, now I am getting this error when trying to access the site:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Stack Trace:


[SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunitiesFromDB() +93
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunities() +58
ASPNET.StarterKit.Communities.CommunityUtility.GetCommunityInfo() +326
ASPNET.StarterKit.Communities.CommunitiesModule.Application_BeginRequest(Object source, EventArgs e) +221
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

try putting this inside your web.config file inside the <system.web> tag...

<system.web>

<identity impersonate="true" userName="xxxxx" password="xxxxx" />

<.system.web>

I added this using a local account and it worked beautifully. Thanks for your help.

Thank you so much - I had the same problem and your solution worked perfectly - thanks!

Just an addendum. If you exclude the usernName="" and password="", it uses the authenticated user's permissions. That way you can customize permissions based on the Windows users or groups and you're not stuck with only one account.

 Thanks so much for your post, it helped solve a very nagging problem.

Hi,  One doubt with this!  If the configuration is hardcoded with username and password of one user, how will other users be able to authenticate through those credentials?? 

Thanks,

hi all,

when i run my application on local pc or local host it runs fine but when i put it on server and try running from IP of server "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'" error come,

i made changes as suggested above in <System.web> now the error changes to "Login failed for user 'SERVERNAME\IUSR_WEB-SERVER'".

can any one help....i have been using same web.config with same code in other project too...but without error.

please tell me the possible source of error.

thanks

Hi

I have the same issue. I tried using the above code in web.config. Nothing happens. Any help please......?

 

Regards

Shaukat

Hi Shaukat,

Hope u hv checked ur IIS setting and is fine.

Next see the database u r using has 'sa' dbo Login Name which is created at the time of database creation.

This will be under databasename>users.

 Regards.