If you’re using firewall you need to add an exception for the 1433 port to allow TCP/IP traffic on Port 1433Ĭonfigure a Windows Firewall for Database Engine Access In the left pane of SQL Server Configuration Manager click SQL Server Services, right-click SQL Server, and click Restart: When you click the OK button you will be prompted with a message to restart the service: Port 1433 is the default instance that SQL Server uses: If the TCP Dynamic Ports dialog box contains 0, which indicates that the Database Engine is listening on dynamic ports, delete the 0 and set the TCP Dynamic Ports to blank and TCP Port to 1433. In the TCP/IP Properties dialog select the IP Addresses tab and scroll down to IPAII. Make sure that TCP/IP protocol is enabled and right click on TCP/IP and select the Properties option. Under the SQL Server Network Configuration select Protocols for : Go to Start->Programs->Microsoft SQL Server 2005/2008/2012 ->Configuration Tools and select the SQL Server Configuration Manager: In the Server Properties dialog under the Connections tab check the Allow remote connections to this server option: To enable remote connection on SQL Server right – click on the server and select the Properties option. This article explains how to configure remote access on a SQL Server instance and connect to a remote SQL Server instance with ApexSQL toolsĬonfiguring remote access on a SQL Server instance
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |