Now you should be able to connect to your SQL Server instance remotely using SQL Server Management Studio. Make sure TCP Dynamic Ports is blank and that TCP Port is set to 1433.Ĭlick OK to save your changes and restart your SQL Server instance.
In the TCP/IP Properties dialog, select the IP Addresses tab and scroll down to IPAII. Right-click on TCP/IP and select Properties. Make sure that TCP/IP protocol is enabled. Open the SQL Server Configuration Manager, expand the node SQL Server Network Configuration and select Protocols for MSSQLServer (or whatever the name of your SQL Server instance is). Once this is done, exit SQL Server Management Studio. Select the Connections page in the left pane and make sure that checkbox Allow remote connections to this server is selected. Right-click server name in the left pane and select Properties. Open the SQL Server Management Studio and log on to your DB locally. How to Enable Remote Connections in SQL Server 2014/2012/2008? This article explains how to configure remote connections for a default SQL Server 2014/2012/2008 instance that you want to connect to from a remote computer. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server)Īfter installing SQL Server, the remote connection feature is disabled by default, and you’re only allowed to connect to your database locally. When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. When you try to connect to a SQL Server instance from a remote computer, you might receive the following error message:Īn error has occurred while establishing a connection to the server.
0 kommentar(er)
