3

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?

Improve this question
7
  • 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
    Commented Nov 15, 2011 at 14:13
  • yes. sorry, i will improve that above
    – LMW-HH
    Commented Nov 15, 2011 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
    Commented Nov 15, 2011 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.
    – LMW-HH
    Commented Nov 15, 2011 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?
    – LMW-HH
    Commented Nov 15, 2011 at 15:48

1 Answer 1

Reset to default
3

Enable SessionStateService...

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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