Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a local sharepoint server 2010. I'm able to browse through the pages, go to the backend etc. But when it comes to the point that something needs to be written into the SQL-DB (e.g. upload a document and save it to a list) i get the following error:

[SqlException]: Login failed for user 'DNLG\AWA01$'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection  owniConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection  outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at  System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo  sqlPartitionInfo)
[HttpException]: Failed to login to session state SQL server for user    'NT-AUTORITÄT\NETZWERKDIENST'.
[HttpException]: Unable to connect to SQL Server session database.
at  System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection  conn, Exception e)
at  System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo  sqlPartitionInfo)
at System.Web.SessionState.SqlSessionStateStore.GetConnection(String id, Boolean& usePooling)
at System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

How can I change the user DNLG\AWA01$? I dont know how sharepoint is thinking that it has to use this one, because i never heard of him. Or isn't that the problem here?

Best Regards,

LMW

Edit: I can "solve" the problem when I restart my computer. Then the site is accessible until I do something which need access to the database.

Edit2: I can access the backend using http://localhost/_layouts/viewlsts.aspx. The problem only occurs when I try to reach the front end sites

Edit3: okay it seems that i have not access to the user DNLG\AWA01$ (the admin is not available)... does that mean that i have to re-install my sharepoint server? or can i enable anonymous access or something like that to get a workaround?

share|improve this question
    
What do you mean by "something needs to be written into the SQL-DB" - do you mean that you want to save something in SharePoint?? –  Shaneo Nov 15 '11 at 14:13
    
yes. sorry, i will improve that above –  CodingSheep Nov 15 '11 at 14:27
    
DNLG\AWA01$ must have been the system/service account that your administration have used while configuring your sharepoint environment... looks like it is a domain account, check with your administrator to make sure the password for this account is not expired or changed... –  xgencoder Nov 15 '11 at 14:48
    
i have installed the sharepoint environment on my own, using DNLG\lmw. AWA01$ is the name of my computer, i will change the name and look if it affects the behaviour. –  CodingSheep Nov 15 '11 at 14:55
    
okay it seems that i have not access to the user DNLG\AWA01$ (the admin is not available)... does that mean that i have to re-install my sharepoint server? or can i enable anonymous access or something like that to get a workaround? –  CodingSheep Nov 15 '11 at 15:48
show 2 more comments

migrated from stackoverflow.com Nov 20 '11 at 16:14

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 3 down vote accepted

Enable SessionStateService...

http://technet.microsoft.com/en-us/library/ff607989.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.