Cannot Connect to MSDE Remotely from W2K machine

[dpatrickcollins]

I have a sql server database successfully installed (using msde) on a server running windows xp professional. I can connect to the database locally as well as remotely from any windows xp machine. However, when I attempt to connect on any machine running window 2000, I receieve an error stating the server cannot be found.

Please Note: the sql server is in "sql server authentication mode" the user is "sa" and the password is NOT BLANK. I am attempting the connection using OSQL (which I installed manually on the remote machine) as well as an ODBC datasource. Either tool in my opinion should rule out a problem with the "tool" if you know what I mean.

Last point: I have found that installing MSDE on the remote machine fixes the problem, even after uninstalling it. But this is QUITE a workaround.

Any thoughts as to why this is (i.e. what is the w2k machine missing) would be helpful.

 

[gmmastros]

windows XP has MDAC 2.8 already installed. Installing this on other operating systems should allow them to connect to a SQL Server.

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&displaylang=en

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[NoCoolHandle]

Has nothing to do with MDAC...

The problem is that by default, when you install the MSDE, it installs NETWORK DISABLED!

Cool eh..

I had a few hours of frustration (well minutes anyway) on this one. If you are installing MSDE, you realllly need to read the help files. There are alot of options you will want to include (unless you love the defaults - some just don't make sense.)

I don't have a copy of MSDE around, but you should find an htm or html file in the root install directroy.

Search for switches. (or Install - I think it might even be in the upgrade section... something like networkdisabled=false )

Rob

Rob