Solved

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

Posted on 2013-12-27
8
11,448 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

831 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