In Control Panel, open Windows Firewall, choose Change settings, and then click the Exceptions tab.Ĭhoose Browse, and then browse to the location of the SQL Server executable file (sqlservr.exe). To allow SQL Server with Windows Firewall If Windows Firewall is running on the computer running SQL Server, then you must explicitly specify the SQL Server executable file as an allowed exception before you can connect to the Dynamics NAV database. If either protocol is not enabled, right-click the protocol, and then choose Enable.Īfter exiting SQL Server Configuration Manager, start the RoleTailored client again to see if the connection problem has been resolved.Īllowing SQL Server with Windows Firewall
Under Protocol Name in the right pane, verify that Named Pipes and TCP/IP have the status Enabled. To enable Named Pipes and TCP/IP in SQL ServerĮxpand the SQL Server Network Configuration node in the tree view, and then choose Protocols for MSSQLSERVER. For Dynamics NAV to work correctly, the Named Pipes and TCP/IP protocols must be enabled for SQL Server.įollow these steps to verify that these protocols are enabled or to enable them if they are currently disabled. You can use SQL Server Configuration Manager to enable and disable network protocols. SQL Server Configuration Manager is a tool for managing SQL Server services and network connectivity. Enable Protocols in SQL Server Configuration Manager This topic describes configuration changes that you can try to resolve SQL Server connection problems. The program could not create a connection to the server. In this case you see an error message like the following when you attempt to start the RoleTailored client. After installing and configuring Dynamics NAV software, you may not be able to connect the RoleTailored client to Microsoft Dynamics NAV Server.
0 kommentar(er)
