SQL connection Issues

0. make sure tcpip is enabled

1. Use 'ping server' to test the network.
2. Use 'telnet server 1433' to ensure that the SQL Server is listening
on the port.

3. Check the Net-Library protocol configured by using 'Client Network
Utility'
on the client. Are they supported by the SQL Server? If you use Named
Pipes,please try to change it to TCP/IP.

4. Add an entry in the hosts file on the
client machine.

you can try either of these solutions

1. Add an entry in the hosts file on the
client machine.
2. Check the Net-Library protocol configured by using 'Client Network
Utility'
on the client. Are they supported by the SQL Server? If you use Named
Pipes,please try to change it to TCP/IP.
3. Use 'ping server' to test the network.
4. Use 'telnet server 1433' to ensure that the SQL Server is listening
on the port.
5. Try again.

or

Change the dns server address form automatically to dedicated one(Network Connection>TCP/IP Protocol), then ping again

other one but dont  work everytime

1. run sqlserver as administrator

2. click on option button on the login screen  and change default to tcpip in the network protocol section drop down box

0. TCPIP and Named pipes are enabled
1. Can ping yes
2. Can not telnet to port 1433.

My SQL Server Agent is set to auto, but will not stay started.

Your port might be block or sql server might listening to other port.

Read this article, it explain in detail
http://support.microsoft.com/kb/823938

Let us know if your prob. still not resolved

Solved own problem