CONFIGURING MS SQL SERVER FOR REMOTE ACCESS Print

  • 0

1. run>type cliconfig(keep TCP/IP enabled)

2. Goto start > administrative tool >services (start the sql server (ms sql server))

3. run > cmd > type: netstat -an to check correct port (tcp port should open i.e 1433 )

4. if server is not listen sql correct port then

go to :
start > all program > microsoft sql server >configuration tool >sql server configuration manager

a.click on + sign next to SQL server network configuration
b. just rght click on TCP/IP and go to properties
c. select IP ADDress
d. all interface TCP ports should 1433. change it and put correct port and restart the sql service.

 

http://www.stradsolutions.com/windows-vps.php


Was this answer helpful?

« Back