When I try to connect to the SQL Server I get this error
message: "Unable to connect to Server [SRVNAME] Server:
Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server
Driver][DBNETLIB] SQL Server does not exist or access
denied"

My computer is outside the network. It actually works with
computers inside the network. I added the name and IP
Address to my HOSTS file but it still doesn't work.

Please let me know how to solve this problem.

Thanks;

Have someone go on the server and run Server Network Utility from the SQL
Program Group. On your computer, open Client Network Utility from the SQL
Program Utility.
Then check to make sure you are communicating with the same protocols.

On rare occasions, I've seen ODBC override connection values. To verify
this is not a problem, go to ODBC Data Sources in Control Panel. Add a SQL
Server data source, hit Finish, type in an arbitrary name (EG test), type in
the servername, hit next Next, type in your login credentials, hit client
configuration, set the proper connection parameters (vs Server Network
Utilty on the server), click OK, click next and finish leaving everythign
else alone.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]