Hi Joan & Noel,

I have verified the cliconfg utility settings and I have it pointing to 68.251.xxx.xx

I have added the sql server to the web server's host file.

After doing this...

Hi Phil,

Any ideas as to why I am able to ping the server using the ip address of the server and why I can't ping the server using the server...

Hi Phil,

Thanks for the reply.

No, I have not been able to make a ODBC connection

using the ip address of the server. I have used both

the ip that is being forwarded...

Could someone take another look at my setup

and see if they can figure out what I have

done wrong. Still trying to get my 2 server to

allow me to make a...

Phil,

I'm trying to create a system ODBC DSN connection from the web server to the SBS 2003 server with SQL.

My network setup look like the following

                                                                  ----- Web Edition Server 2003

                                                                /

Internet...

I have check the server using the Server Network Utility

and only TCP/IP is enabled. Also hide server is unchecked.

I can ping the server infotrails.org

and the ping comes back OK.

I have...

Error reads:

Connection Failed:

SQLState: '01000'

SQL Server Error: 11004

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect(().

Connection failed:

SQLState: '08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

The above error is the text...