Just follow the below steps. This will surely help you if you have installed SQL Server correctly:
1) First Step check your SQL services are running fine.
2) Click on "Start Window" and expand "Microsoft SQL Server 2008 R2" and click on "SQL Server Configuration Manager".
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.
4) Now check for "SQL Server (MSSQLSERVER)", it should be in green color means running fine.
5) Now check for "SQL Server Browser" running or not, you have to make sure is green marked.
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.
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".
8) Click on "Inbound Rules" in left pane and click on right pane "New Rule".
9) Then Click on "Protocol and Ports" and click on "Specific local ports" and write SQL default Port No "1433".
10) Now write name on SQL Port Name and click on "Finish" button.
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.
12) Now Open "SQL Server Management Studio" and right click, now property window open and click on "Property".
13) Now click on "Connections" option and Check option "Allow remote connections to this server" and click now on "OK".
14) You have to Ping for your IP Host Address on your command prompt "cmd" console.
15) Check for Firewall blocking SQL Server Port 1433
16) If you have already access to development machine, production server then it will be helpful greatly. Press (Windows + R) to open Run window to launch program quickly. Now type "EVENTVWR" and a new window will open, now expand left pane, you can check here "Windows Log" to look into issue very closely and specifically.
17) We can use also Netstat Command to display how communicating with other computers or networks.
Command: netstat [-a] [-b] [-e] [-f] [-n] [-o] [-p protocol] [-r] [-s] [-t] [-x] [-y] [time_interval] [/?]
Mark the answer if it helps you.
DNS Gold Member
"If you can dream it, you can do it."