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
Configuration Manager
”.

SQL-Server-Configuration-Manager

SQL-Server-Configuration-Manager

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.

SQL-Express

SQL-Express

Step 4:  Now check for “SQL Server
(MSSQLSERVER)
”, it should be in green color means running fine.

SQL-Server-MSSQLServer

SQL-Server-MSSQLServer

Step 5: Now check for “SQL Server
Browser
” running or not, you have to make sure is green marked.

SQL-Browser-Running

SQL-Browser-Running

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.

Aliases

Aliases

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
Settings
”.

Firewall-Advanced-Settings

Firewall-Advanced-Settings

 

Step 8: Click on “Inbound Rules” in left pane and click on
right pane “New Rule”.

Inbound-New-Rule

Inbound-New-Rule

Step 9: Then Click on “Protocol
and Ports
” and click on “Specific local ports” and write SQL default
Port No “1433”.

SQL-Protocol-Ports

SQL-Protocol-Ports

Step 10: Now write name on SQL Port
Name and click on “Finish” button.

SQL-Port-Name

SQL-Port-Name

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
populated.

sql-Port-1433

sql-Port-1433

Step 12: Now Open “SQL Server
Management Studio
” and right click, now property window open and click on
“Property”.

SQL-Server-Management-Studio

SQL-Server-Management-Studio

Step 13: Now click on “Connections”
option and Check option “Allow remote connections to this server” and
click now on “OK”.

Allow-SQL-Remote-Connections

Allow-SQL-Remote-Connections

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.