Some connectivity issues between Dynamics SL and SQL Server can be resolved by setting the connection protocols on the SL clients. The recommended setting is Named Pipes first followed by TCP/IP.
To set the protocols follow these steps:
1. Make sure that the SQL server is configured to listen for Named Pipes connections. To do this:
a. Open the SQL Server Configuration Manager on the SQL Server
b. Expand SQL Server Network Configuration
c. Click Protocols for MSSQLSERVER
d. In the right pane, right-click and enable Named Pipes
Note: You will have to restart the SQL server service after making this change.
2. Enable Named Pipes on the SL client. To do this, follow these steps:
a. Browse to C:\Windows\SysWow64
b. Locate and open the cliconfg.exe
c. Enable Named Pipes first followed by TCP\IP
d. Click Apply and then click OK.