SQLink Connection issues

From High5Wiki
Jump to: navigation, 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