Tuesday, 29 May 2012

Access SQL Server using ip address (remote)

  • Make sure the SQL Browser service is nunning...
  • the make sure the IP Address and Instance name (255.255.255.255\SQLSERVER)
  • Turn off your firewall or add exception the mssqlserver
  •  Go to sql server properties -->connections-->make check mark in "Allow remote connections to this server"
  • Go to sql server configuration manager and select sql server network configuration-->Enable the TCP/IP

It will work fine with best of my knowledge....


No comments:

Post a Comment