enterprise manager / query analyzer tcp/ip

[liju]

How can I force Enterprise Manager and Query Analyzer to use TCP/IP?
While my applications connect instantly to the database
after I started using the NTL parameter in connect string, these 2
applications take forever and a number of retries to connect.

Can someone help?

Thanks
Liju

[Yariv]

Go to the StartMenu and click on Client Network Utility in Microsoft SQL Server 7.0 group. Change the default network library from Named Pipes to TCP/IP.

Yariv


------------
liju at 12/12/00 1:16:24 PM

How can I force Enterprise Manager and Query Analyzer to use TCP/IP?
While my applications connect instantly to the database
after I started using the NTL parameter in connect string, these 2
applications take forever and a number of retries to connect.

Can someone help?

Thanks
Liju

[liju]

thanks a ton yariv


------------
Yariv at 12/12/00 4:24:10 PM

Go to the StartMenu and click on Client Network Utility in Microsoft SQL Server 7.0 group. Change the default network library from Named Pipes to TCP/IP.

Yariv


------------
liju at 12/12/00 1:16:24 PM

How can I force Enterprise Manager and Query Analyzer to use TCP/IP?
While my applications connect instantly to the database
after I started using the NTL parameter in connect string, these 2
applications take forever and a number of retries to connect.

Can someone help?

Thanks
Liju