Wednesday, March 21, 2012

Problems connecting to MSDE from other PC

Hello,
We are a small software developement group. Recently we decided to try out
using MSDE, and one of our developers installed it on his PC. After some
struggling with logging on it was discovered that by default it uses Windows
authentication mode and reading KB articles we were able to change the auth
mode to mixed. Now he is able to connect to the local MSDE server using
login "sa" and the install-time defined password, using the freeware tool
"Toad for MSSQL server". It's interesting, that it connects successfully, if
in the "server" is given the computer name, but wouldn't connect if IP
address 127.0.0.1 or LAN address starting with 192.168.*.* is used.
However, there are problems in attempting to connect to this server from
other PCs on our LAN, that have SQL Enterprise managers installed. It just
reports that "Server does not exist or access denied". Does MSDE even
support remote connection with SQL EM? Or, should I somewhere enable it?
Perhaps I am missing something here. It would be great to be able to connect
to this MSDE from other PCs, using EM to compy data to and from databases.
Thanks,
PavilsI discovered, that is was related to the disabled network drivers.
Reinstalling with the network support solved the problem.
Pavils

No comments:

Post a Comment