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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
lruiz52Commented:
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.

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:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NP-TechAuthor Commented:
Uninstalling SharePoint was my solution. It's not going to work with anyone else who needs to have SharePoint installed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.