I am just starting with MSDE switching from access2002.
The installation was done on a server pc with:
password="sa",
Authentication Mode = SQL, and
DisableNetworkProtocols=0

On the server, I can connect to it fine, both via my app and the configure wiz'd in the SYSTEM-DSNs list (off of control panel-Admin tools).

But from another PC on a two computer network, I cannot connect to it.
The configure wiz;d gives a double error:
SQLstate 1000 connaction failed ANd
SQLState 8001 error 17: serber does not exist or connection denied.

Do I need to specify anything other than server's name as the server's ID, e.g. the hard disk label or....?
Do I need to somehow tell the server to allow a conection from another PC???? If yes, I can't find where that might be done?

I'd really appreciate ANY help on this frustrating problem.
Thanks,
Tim


Tim

__________________
Tim

Please check the following articles, related to connectionstring.

1. Method 1 (using connectionstring property)
http://www.aspwebpro.com/tutorials/a...ectionopen.asp

2. using provider
http://www.w3schools.com/ado/ado_connect.asp

Other types:
http://www.tnsites.com/support/s_databaseconn.asp

Hope this helps...


Om Prakash

Thanks,
I will look up the links.

Meantime this is what I had to do to solve the problem.
Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.

Apparently, I kept openning the CLIENT manager instead of the server mgr. to be sure the protocols are there. This was partly because MSDE comes with NO UI, so one needs to know what each executable which comes with it does.

Also quite annoying that they do not tell you there will be NO communication protocols selected by default in the installation notes.


Tim