This problem may be occur due to :

The server name is incorrect or not reachable (DNS/firewall issue)

If this , try pinging or telnetting the server :

telnet your_server_name 1433

• Use the IP address of the server instead of hostname to eliminate DNS issues.