Difference between revisions of "Named Piped Provider: Could not open a connection to SQL Server"
Line 4: | Line 4: | ||
<br>[[File:ConnectingToDBNamedPipesProvider.png]] | <br>[[File:ConnectingToDBNamedPipesProvider.png]] | ||
− | <br>If you click ok SQL will continue to attempt to connect to the SQL instance running the High5 database. | + | <br>If you click '''ok''' SQL will continue to attempt to connect to the SQL instance running the High5 database. |
<br>Followed by: | <br>Followed by: | ||
<br>[[File:ErrorNumber2.png]] | <br>[[File:ErrorNumber2.png]] | ||
− | <br>- Clicking ok will bring up the SME 5 connection dialogue. Click | + | <br>- Clicking '''ok''' will bring up the SME 5 connection dialogue. Click '''Cancel''' as the issue is with the SQL Server Service and not SME. |
<br>[[File:ConnectionProperties.png]] | <br>[[File:ConnectionProperties.png]] | ||
Line 22: | Line 22: | ||
<br>[[File:SQLServerConfigurationManager.png]] | <br>[[File:SQLServerConfigurationManager.png]] | ||
− | <br>- If it is not pinned click All Programs and scroll down to the MS SQL 2008 R2> Configuration Tools | + | <br>- If it is not pinned click''' All Programs''' and scroll down to the '''MS SQL 2008 R2'''> '''Configuration Tools''' |
<br>[[File:AllPrograms_ConfigurationTools.png]] | <br>[[File:AllPrograms_ConfigurationTools.png]] | ||
− | <br>- Open it and click on the SQL Server Services in the left hand column | + | <br>- Open it and click on the '''SQL Server Services''' in the left hand column |
<br>[[File:SQLServerServices.png]] | <br>[[File:SQLServerServices.png]] |
Revision as of 22:15, 19 June 2014
You receive this message when attempting to start SME:
- Connecting Database Named Pipes Provider: Could not open a connection to SQL Server [2].
If you click ok SQL will continue to attempt to connect to the SQL instance running the High5 database.
Followed by:
- Clicking ok will bring up the SME 5 connection dialogue. Click Cancel as the issue is with the SQL Server Service and not SME.
- 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
- If it is not pinned click All Programs and scroll down to the MS SQL 2008 R2> Configuration Tools
- Open it and click on the SQL Server Services in the left hand column
- Right Click on the SMEServer service in the right hand column and start it