Connecting to SQL Server across network

[agillbb]

Hi,

I'm having troule connecting to SQL Server 7 Desktop Edition on a Win98 box (using ODBC) across the network.

I am connecting from an NT Workstation box and Cold Fusion.

I set up the ODBC DSN on the Win98 box, and this tested fine...I also have CF running on the 98 box, so I verified this in the CF administrator.

When I tried to set up the ODBC DSN on the NT box, I put in the required in (DS Name, Server Name, username, pwd, etc) but it could not connect. I am sure the info was entered correctly because it is the identical information I entered when connecting locally on the SQL box from CF.

I'm hoping that the Desktop Edition even allows me to connect from remote machines????

Help??? Thanks in advance.
Andy.

 

[petermeachem]

Well, I found this:-

Can you use Desktop Edition running on a Win9x system as a server solution for small workgroups? In theory, the answer is yes.

on this url

http://www.winntmag.com/Articles/Index.cfm?ArticleID=4979

Doesn't tell you what to do though Peter Meachem
peter@accuflight.com

 

[tlbroadbent]

Which net library are you using on the NT Workstation? The Desktop version of SQL Server cannot accept connections using named pipes. Nor can you connect using NT authentication. Clients cannot connect to the desktop edition on Win 95/98 using encryption. Terry

http://members.home.net/tlbroadbent/index.htm