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

From High5Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


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