Microsoft SharePoint Server State Service encountered an error executing a stored procedure for database key cd8f485620694a949d702a26d446eb8b_d5072e39b94045cfa2d1e0c9ad2e5e92. Details: Cannot open database "StateService_380322ea4fef4dc0892ab0b70c2bd813" requested by the login. The login failed. Login failed for user 'DomainName\UserName'.
Create a state service application using the following powershell commands
1. $serviceApp = New-SPStateServiceApplication -Name “State Service Application”
2. New-SPStateServiceDatabase -Name “SharePoint_Service_State” -ServiceApplication $serviceApp
3. New-SPStateServiceApplicationProxy -Name “State Service Application Proxy” -ServiceApplication $serviceApp -DefaultProxyGroup
once its done,go to centraladmin and configure this service to your webapplications andset it as default under Service Connections of your Web application. Before you set,make sure the newly created State Service Application is Activated.
1. $serviceApp = New-SPStateServiceApplication -Name “State Service Application”
2. New-SPStateServiceDatabase -Name “SharePoint_Service_State” -ServiceApplication $serviceApp
3. New-SPStateServiceApplicationProxy -Name “State Service Application Proxy” -ServiceApplication $serviceApp -DefaultProxyGroup
once its done,go to centraladmin and configure this service to your webapplications andset it as default under Service Connections of your Web application. Before you set,make sure the newly created State Service Application is Activated.
No comments:
Post a Comment