Showing posts with label networkthrough. Show all posts
Showing posts with label networkthrough. Show all posts

Friday, February 10, 2012

Connection problem with ODBC to MSDE

Dear Friends
I am facing problem to connect to the SQL server which is in the network
through ODBC. I can ping to the machine all shares are available but not abl
e
to get the ODBC connection with SQL. Please suggest what can be the reason
and how i can solve the same.
Best regards
ShaileshHi
You may have installed MSDE with DISABLENETWORKPROTOCOLS=1 which does not
enable the network protocols. In which case you should still be able to
connect to the server on the machine itself. You can enable them by running
the command utility svrnetcn.exe
John
"Sharad2005" wrote:

> Dear Friends
> I am facing problem to connect to the SQL server which is in the network
> through ODBC. I can ping to the machine all shares are available but not a
ble
> to get the ODBC connection with SQL. Please suggest what can be the reason
> and how i can solve the same.
> Best regards
> Shailesh