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
NP-TechAsked:
Who is Participating?
 
NP-TechConnect With a Mentor Author Commented:
We don't use SharePoint. I uninstalled it. The above error is gone but I've got another hairball. I will post another question to deal with that.
0
 
lruiz52Commented:
Did you also Grant the farm database access account “VIEW SERVER STATE”
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
0
 
NP-TechAuthor Commented:
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.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
lruiz52Commented:
0
 
NP-TechAuthor Commented:
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.
0
 
lruiz52Commented:
0
 
NP-TechAuthor Commented:
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
0
 
NP-TechAuthor Commented:
Uninstalling SharePoint was my solution. It's not going to work with anyone else who needs to have SharePoint installed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.