How to Remote Access Database using static ip

• If we want to access the database remotely, then make sure you select the SQL Server Browser agent during installation.

Step 1

Open the SQL Server Management Studio and login to the database, using the SQL Server/Windows authentication.



Step 2

After login, go to the Object Explorer and right click on the root directory, in my case named HUMZA ( SQL Server ver-sa ) and click the Properties and this window will open.



Click the connections and make sure the following check box is Checked:



Step 3

Start->Run->SQLServerManager(version).msc like.

Start->Run->SQLServerManager10.msc.

For SQL 2005, you can use SQLServerManager.msc.

Just look under C:\Windows\System32\SQLserverConfigurationManager.

• Make sure all SQL server services are running.
  
  
• Click SQL Server network configuration, expand it and click “Protocols for MSSQLserver”.
  
  
• We see the three options on the right hand pane that are listed as “Shared Memory Which is Enabled by default,” named Pipes, which is Disabled by default, and the last one which is important is “TCP/IP, which is by default, and that is enabled in the latest SQL Server versions; and if it is not enabled, then right click Properties.
  
  
  
  
• Right click on TCP/IP and click enabled (in case it's disabled) again and right click properties and we see it just like this window:
  
  
  
  
• Go to IP addresses tab.
  
  
• Scroll down and make sure that the “All-IP” and port are set to 1433, which is the default port and we can choose all the other ports not reserved by the system also.
  
  
  
  
• Click OK, go back to SQL Server services and restart all the SQL Server services.

Step 4

• Go to Windows firewall as I have Windows 10 in my case.
  
  
• Control Panel\All Control Panel Items\Windows Firewall.
  
  
• Click “Advanced Setting”.
  
  
  
  
• Click InBounded Rules and click New Rule
  
  
  
  
• Select the port and click next.
  
  
  
  
• Select TCP radio and select the specified port and give the name of the port, which is “1433” in my case. You can set any port which is not reserved by the system.
  
  
  
  
• Click next action tab but don’t change anything. Use the default and click next in the profile. Make sure, we select all the check boxes and then click next. Give identity to it by naming it and click finish.
  
  
  
  
• Again, click on the new rule and select the “Port” radio click, next click the “UDP” radio, click the specified port and assign 1434 , which is the default port for UDP in SQL Server. Click next in Action pane but don’t change anything. Click next in profile tab and make sure all the check boxes are checked and click next to give it to the “SQL Server UDP port” and click finish.
  
  
  
  
• Again, click on the new rule at that time and select the program followed by clicking next.
  
  
  
  
• Give the complete program path, where we add the “SQLbrowser.exe”, which is located at that path in my case.
  
  
• C:\Program Files (x86)\Microsoft SQL Server\90\Shared
  
  
  
  
• Click next but don’t change anything. Click next to make sure all the check boxes are checked and then click next to assign the name “SQL server browser agent” and click finish.
  
  
  
  
• Again, click the new rule and select the program. This time, we add the SQLsrvr.exe, which is located at C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Bin
  
  
  
  
• Click next but don’t change anything, followed by clicking next to make sure you have checked all the check boxes on the Profile tab.
  
  
• Click next, name it “SQL server exe” and click finish.
  
  
• Make sure you have 4 new rules in the firewall.