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
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