How do I connect to a remote database using SQL Server Management Studio?

STEP 1: Open the SQL Server Management Studio and login to your Database locally. STEP 2: Right-click on the server name in the left panel and select Properties. STEP 3: Select the Connections page on the left side and make sure that “Allow remote connections to this server” option is checked.Click to see full answer. Also question is, how do I connect to a SQL Server database? Step 3: Connect to your database using SSMS Launch Microsoft SQL Server Management Studio. The Server type should be Database Engine. Enter the server name (see above) Authentication is SQL Server Authentication. Enter your database username (see above) Enter your database password (see above) Click Connect. Subsequently, question is, how can I tell if SQL Server is configured to allow remote connections? Connect to SQL Server instance from remote server. Go to server properties. Now right click on the server and go to Properties. On the Connections page under Remote server connections, make sure that the Allow remote connections to this server is checked. Also to know, how do I configure remote access and connect to a remote SQL Server instance? To set up remote access to a SQL Server named instance go to Start->Programs->Microsoft SQL Server 2005/2008/2012 ->Configuration Tools and select the SQL Server Configuration Manager. In the TCP/IP Properties dialog select the IP Addresses tab and scroll down to IPAII.How do I access a SQL Server database from another computer using my IP address? Configure SQL Server to listen on a specific port In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click on the server instance you want to configure. In the right pane, double-click TCP/IP. In the TCP/IP Properties dialog box, click the IP Addresses tab.