Named Piped Provider: Could not open a connection to SQL Server

From High5Wiki
Jump to navigation Jump to search


You receive this message when attempting to start SME:
- Connecting Database Named Pipes Provider: Could not open a connection to SQL Server [2].


ConnectingToDBNamedPipesProvider.png


If you click ok SQL will continue to attempt to connect to the SQL instance running the High5 database.
Followed by:


ErrorNumber2.png


- Clicking ok will bring up the SME 5 connection dialogue. Click Cancel as the issue is with the SQL Server Service and not SME.


ConnectionProperties.png


- Use these steps to restart the service:


- Log on to the server or computer hosting the database:


- Go to Windows Start
- The SQL Config Manager should be pinned to your start menu


SQLServerConfigurationManager.png


- If it is not pinned click All Programs and scroll down to the MS SQL 2008 R2> Configuration Tools


AllPrograms ConfigurationTools.png


- Open it and click on the SQL Server Services in the left hand column


SQLServerServices.png


- Right Click on the SMEServer service in the right hand column and start it


RightClickSQLServerStart.png

Retrieved from "https://www.high5software.com//mediawiki/index.php?title=Named_Piped_Provider:_Could_not_open_a_connection_to_SQL_Server&oldid=5261"