all groups > sql server msde > june 2004 >
You're in the

sql server msde

group:

newbie connection problem


newbie connection problem Ernesto
6/28/2004 11:48:55 AM
sql server msde:
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,


Re: newbie connection problem Ernesto
6/28/2004 5:28:54 PM
Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.

AddThis Social Bookmark Button