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.
Showing posts with label access2002. Show all posts
Showing posts with label access2002. Show all posts
Friday, March 9, 2012
newbie connection problem
Labels:
access2002,
authentication,
connection,
database,
installation,
microsoft,
mode,
msde,
mysql,
newbie,
oracle,
server,
sql,
switching,
withpassword
Subscribe to:
Posts (Atom)