Difference between revisions of "Named Piped Provider: Could not open a connection to SQL Server"
(Created page with "Named Piped Provider: Could not open a connection to SQL Server <br>You receive this message when attempting to start SME: <br>- Connecting Database Named Pipes Provid...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
<br>You receive this message when attempting to start SME: | <br>You receive this message when attempting to start SME: | ||
| − | |||
<br>- Connecting Database Named Pipes Provider: Could not open a connection to SQL Server [2]. | <br>- Connecting Database Named Pipes Provider: Could not open a connection to SQL Server [2]. | ||
<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]] | + | <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 26: | 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]] | ||
| − | <br>- Right Click on the SMEServer service in the right hand column and start it | + | |
| + | <br>- Right Click on the '''SMEServer''' service in the right hand column and start it | ||
<br>[[File:RightClickSQLServerStart.png]] | <br>[[File:RightClickSQLServerStart.png]] | ||
Latest 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
