Solved

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

Posted on 2013-12-27
8
10,844 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
 

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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now