NP-Tech
asked on
How do I fix Event 5586 (SharePoint Foundation) error?
In the event viewer I see "Event 5586 (SharePoint Foundation) of severity 'Error' occurred xx more time(s) and was suppressed in the event log" many times in a day. It shows an event id 2159 and a task category 59.
I've tried the following with no success:
Open the SQL Server Configuration Manager
Browse down to SQL Server Network Configuration – Protocols for <namedserverinstance>
Right-click “Named Pipes” in the right pane and choose Enable
Rebooted the server.
Any more suggestions?
Thanks
I've tried the following with no success:
Open the SQL Server Configuration Manager
Browse down to SQL Server Network Configuration – Protocols for <namedserverinstance>
Right-click “Named Pipes” in the right pane and choose Enable
Rebooted the server.
Any more suggestions?
Thanks
ASKER
Thanks lruiz52. Recycling the application pools didn't do anything. I assume the pools I needed to recycle were the SharePoint pools.
We aren't even using SharePoint. The application pools were started, though.
I don't know where to grant the farm database access account "view server state." I didn't see that anywhere in the SQL Server Configuration Manger.
We aren't even using SharePoint. The application pools were started, though.
I don't know where to grant the farm database access account "view server state." I didn't see that anywhere in the SQL Server Configuration Manger.
Check the link below.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163892
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163892
ASKER
Thanks again lruiz52.
The link leads to this advice:
1. Right click on server name.
2. Select properties.
3. Select Permissions
4. Select user/group to whom you want to give permission.
5. In permission tab select view server state.
The link says what to do but not where. I don't see a place in the SQL Server Configuration Manager to take that action.
Thank you.
The link leads to this advice:
1. Right click on server name.
2. Select properties.
3. Select Permissions
4. Select user/group to whom you want to give permission.
5. In permission tab select view server state.
The link says what to do but not where. I don't see a place in the SQL Server Configuration Manager to take that action.
Thank you.
Try setting it with a query, check the link below
http://saurav-nav.blogspot.com/2012/05/view-server-state-permission-on-sql.html?m=1
http://saurav-nav.blogspot.com/2012/05/view-server-state-permission-on-sql.html?m=1
ASKER
Unfortunately, I don't have SQL Server Managment Studio. I will ask one of the Dev team if they have SQL tools that will be able to run that query.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Uninstalling SharePoint was my solution. It's not going to work with anyone else who needs to have SharePoint installed.
under the SQL Server properties?
You should also try recycling your application pool
http://technet.microsoft.com/en-us/library/cc770764(v=ws.10).aspx