Error connecting to MSDE on another PC
- Hi group,I'm getting a SQL Server connect error trying to connect to an MSDE database on another PC on the network. On the PC on which the DB is installed, connectivity works fine from the Delphi 7 app. but not from the work station. The app. uses ADO.The error is as follows (this is in the ODBC data sources applet in the control Panel):Connection failed:SQLState: '01000'SQL Server Error: 10060[Microsoft][ODBC SLQ Server Driver][TCP/IP Sockets]ConnectoinOpen (Connect()).Connection failed:SQLState: '08001'SQL Server Error: 17[Microsoft][ODBC SLQ Server Driver][TCP/IP Sockets] SQL Server does not exist or access is denied.When I try to build the connection string, the server is visible in the drop downbut I cannot connect either with Windows Authentication or with SQL Authentication. The MSDE installation is setup for mixed mode, so both should work. Its' MSDE 200A, the latest as far as I know.The PC is running Windows XP Pro, and of course will not allow me to install MDAC, as MDAC capability is built into XP Pro. Does anybody have any suggestions?Regards,Morpheus
"See how deep the rabbit hole goes..." -
If the server PC is running XP and has XP's built-in firewall turned on, this might be the problem. You need to open port... 1433 I think it is... on the server PC. Check this number in BOL
-
Damn!! I never thought of that. Thanks. I'll give it a try.
Regards,
Morpheus
"See how deep the rabbit hole goes..."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply