ODBC Access to SQL 2000

N

NC Beach Bum

I need to setup an ODBC connection from a PC in our LAN to a SQL 2000 Server
in our DMZ. I am using MS Access 2003 and trying to setup the ODBC
connection. When I telnet on Port 1433 I can hit the SQL Server Ok. But
when I am using the "Create New Data Source to SQL Server" wizard on the drop
down "Which SQL Server do you want to connect to?" it shows our LAN SQL
Server but not the DMZ SQL Server. When I put in the the IP
"\\192.168.0.2" and click "NEXT" and on the next screen I select "With SQL
Server authentication..." and in the Client Configuration I put in "TCPIP"
with "Port 1433" and in the Logon ID I put in "\\192.168.0.2\Administrator"
and in the Password I put in the password for the server. What it returns is

Connection Failed:
SQL State: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open
(ParseConnectParams())
Connection Failed: '08001'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Invalid connection


Please help! I have been working on this for three days and it's driving
me crazy.

Thanks!

NC Beach Bum
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top