Friday, March 9, 2012

newbie connection problem

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 in advance,
Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.
|||Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.

No comments:

Post a Comment