9212 32 1044, 9654 60 1044

triangle
About Us

Label

Steps to Access Sql Server from Remote site

2605.18hours, 45 minutes ago Visitor: 5823
These are basic 10 steps to setup your Sql Server to access remote system.

Step 1-  Open Sql Server Configuration Manager, for this you can search it by this way or u can go to sql server folder in programs and go to "Configuration Tools" and click on "Configuration Manager".

Step 2- In left side pane of window click on "Sql Server Network Configuration".

Step 3- Now select your sql server instance, in my case i have installed three sql server of             different version, i selected here "RANVIJAYR2".

Step 4- Right side go to TCP/IP and double click on this, and set enable to yes and then click on "Ip Address" tab.


Step 5- Set the TCP port to "1433" and select apply and ok.


Now you configure your sql server next steps tells you how to configure our firewall regarding to access sql server on port 1433 so we have to configure the inbound call on 1433 where remote user can access your sql server.

Step 6- Open control panel and then firewall go to advance setting on left side pane on                 window.

Step 7- Again on left side of pane select  inbound rule and click on New Rule on right side             of window.

Step 8- Now on Inbound rule wizard select Port and click next.

Step 9- Select specified local ports and enter 1433 which is your sql server port and                       incoming request communicate here to access sql server.   

Step 10- Give any name to this rule and click on finish.


Now you can access this sql server on any other system on same LAN network passing valid computer name followed by instance name of sql server, user id and password. 
for example :

Server name:  RANVIJAY\RANVIJAYR2  
Login: sa
Password: abcd
  • Filed Under:

Comments

Leave a Comment


55+ 0=