connect to sql with ip address

Configuring MS SQL Server for Remote Access

Open cliconfg from a RUN prompt and make sure TCP/IP is an enabled protocol.For SQL 2005/2008/2008 R2: Check the Services tool, Start > Administrative Tools > Services, to see that the service named SQL Server (MSSQLSERVER) is started.For MS SQL 2012: Use the Windows key or hover over the left […]