Problem in connecting after service pack 3a installed in MSDE 2000

Hi All,
I have installed MSDE 2000 server and i installed service pack
3a. The server machine has SQL Server 2000 client connectivity. When i
connect from client machine to Server machine it is showing error.
[Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
SQL Server does not exists or access denied.
I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
Any suggestion would be greatly appreciated.
Regards,
A.Chellam.How do you connect? Try specify the IP for the server/data source and see if
you
can connect.
-oj
http://www.rac4sql.net
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>|||Verify on the MSDE machine using Server Network Utility what netlibs it is
listening on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>