Editing 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 Provider: Could not open a connection to SQL Server [2].

<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>Followed by:

<br>[[File:ErrorNumber2]]

<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>-          Use these steps to restart the service:

<br>-          Log on to the server or computer hosting the database:

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

<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>[[File:AllPrograms_ConfigurationTools.png]]

<br>-          Open it and click on the '''SQL Server Services''' in the left hand column

<br>[[File:SQLServerServices.png]]

<br>-          Right Click on the '''SMEServer''' service in the right hand column and start it

<br>[[File:RightClickSQLServerStart.png]]