Cari Blog Ini

20 Maret 2012

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied

Applies To :
Microsoft SQL Server 2000, Microsoft SQL Server 2005




Error Messages :

Unable to connect to server xxx.xxx.x.xx : 

Server: Msg 17, Level 16, State 1 

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] 

SQL Server does not exist or access denied.











Condition When Error:



Solution:

*** Update the "Alias Name" from "xxx.xxx.x.45" to "testing1"
Then connection succeed.