Static IP SQL Server
SQL Server Remote Connection (Static IP)
Step 1: First Step check your SQL
services are running fine.
Step 2: Click on “Start Window”
and expand “Microsoft SQL Server 2008 R2” and click on “SQL Server
Step 3: Now click on left pane “SQL
Server Services” and check for “SQL Server (SQLEXPRESS)” running or not, if it
is in green color then it’s working fine.
Step 4: Now check for “SQL Server
(MSSQLSERVER)”, it should be in green color means running fine.
Step 5: Now check for “SQL Server
Browser” running or not, you have to make sure is green marked.
Step 6: Now click on “Aliases“ left
pane, make assure on right pane that there should be empty aliases, if requires
then should recreate from fresh.
Step 7: Now check for SQL Server
Default Portal 1433, if you have not already added then follow to open “Ctrl
+ R”, type “Firewall.cpl” then Firewall will open and Click on “Advanced
Step 8: Click on “Inbound Rules” in left pane and click on
right pane “New Rule”.
Step 9: Then Click on “Protocol
and Ports” and click on “Specific local ports” and write SQL default
Port No “1433”.
Step 10: Now write name on SQL Port
Name and click on “Finish” button.
Step 11: Now click on “Client
Protocols” in left pane, next click on right pane “TCP/IP” and click
on “Property” then you check that your default Port “1433” has been
Step 12: Now Open “SQL Server
Management Studio” and right click, now property window open and click on
Step 13: Now click on “Connections”
option and Check option “Allow remote connections to this server” and
click now on “OK”.
Step 14: You have to Ping for
your IP Host Address on your command prompt “cmd” console.
Instance : ping 127.152.254.215(your ip)
Step 15: Check for Firewall blocking
SQL Server Port 1433
Hope above steps will eradicate your problem permanently Could not open a
connection to SQL Server and work as per your expectations seamlessly.