Hey Bob,
Make sure that the production web server uses TCP/IP as it's default network
library and not named pipes. Named pipes will fail as you described below.
You can check this by going to start--programs--MS SQL--Client Network
Utility. Check to see what the default network library is, if it's Named
Pipes, change it to TCP/IP.
Couple other tests:
a) can you ping the SQL server from the production web server?
b) can you telnet from the production web server to port 1433 on the SQL
Server?
AJ
-----Original Message-----
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 11:00 AM
To: CF-Talk
Subject: Problems setting up a remote DSN to SQL Server
Hi everyone,
I'm trying to setup a datasource to point to a SQL Server database on
another physical server, but the verification always fails. I have been
able to get it to work between my workstation (running W2K Server/CF 4.5.1)
and the remote server (running NT4/SQL Server 7). I can setup both an ODBC
and an OLE DB connection between my workstation and the remote server.
The problem comes when I try to set the datasource up on the Production web
server (running W2K Server/ CF 4.5.0). Both with ODBC and OLE DB it always
fails. I noticed that if I increase the Login Timeout, it takes longer
before it fails, so it sounds like it may be timing out.
Both my workstation and the Web server are accessing the SQL Server database
via TCP/IP over the internet. Both my workstation and the Web server are in
the same city, while the SQL Server machine is in another city.
Has anyone encountered anything like this? Any suggestions would be greatly
appreciated.
Thanks,
Bob
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
