1.Open the SQL Server Configuration Manager (assuming you are using SQL 2008 or higher)
2.Browse down to SQL Server Network Configuration – Protocols for <namedserverinstance>
3.Right-click “Named Pipes” in the right pane and choose Enable
4.You may need to restart the server for changes to take effect
Granting the farm database access account “VIEW SERVER STATE” under the SQL Server properties will also resolve this issue.
use [master]
GO
GRANT VIEW SERVER STATE TO [domain\timer_service_user]
GO
2.Browse down to SQL Server Network Configuration – Protocols for <namedserverinstance>
3.Right-click “Named Pipes” in the right pane and choose Enable
4.You may need to restart the server for changes to take effect
Granting the farm database access account “VIEW SERVER STATE” under the SQL Server properties will also resolve this issue.
use [master]
GO
GRANT VIEW SERVER STATE TO [domain\timer_service_user]
GO
