?
Solved

How do I fix Event 5586 (SharePoint Foundation) error?

Posted on 2013-12-27
8
Medium Priority
?
13,885 Views
Last Modified: 2014-01-21
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
0
Comment
Question by:NP-Tech
  • 5
  • 3
8 Comments
 
LVL 17

Expert Comment

by:lruiz52
ID: 39743151
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
 

Author Comment

by:NP-Tech
ID: 39743172
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
 
LVL 17

Expert Comment

by:lruiz52
ID: 39743174
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:NP-Tech
ID: 39743623
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
 
LVL 17

Expert Comment

by:lruiz52
ID: 39744007
0
 

Author Comment

by:NP-Tech
ID: 39744010
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
 

Accepted Solution

by:
NP-Tech earned 0 total points
ID: 39750111
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
 

Author Closing Comment

by:NP-Tech
ID: 39796454
Uninstalling SharePoint was my solution. It's not going to work with anyone else who needs to have SharePoint installed.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question