client setup

Can anyone tell me how to setup a client connection to
SQL server 2000?
All you need is an ODBC driver or OLE DB Provider for SQL Server. Once one
of them is in place, you need a tool like Query Analyzer or Enterprise
Manager to connect to SQL Server. All of them (client tools) can be
installed using the SQL Server setup CD.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"brbaskets" <anonymous@.discussions.microsoft.com> wrote in message
news:944a01c4337c$8f2dc800$a501280a@.phx.gbl...
Can anyone tell me how to setup a client connection to
SQL server 2000?
|||Hi,
Install SQL Server client software coming along with SQL Server Installation CD. While installation select the "client only".
After the installation use any of the below tools to connect to SQL Server
1. Query Analyzer
2. Enterprise manager
3. OSQL / ISQL command line utilities
Note:
If you are not able to connect to servers or if the SQL server name is not automatically displayed in the server list then create a Alias name using "CLIENT NETWORK Utility" by providing the Protocol, IP ADDRESS and PORT number. Then using the Alias name
created you can connect to SQL Server.
Thanks
Hari
MCDBA
-- brbaskets wrote: --
Can anyone tell me how to setup a client connection to
SQL server 2000?
|||If you are asking about client connectivity via an application; you have
everything you need already installed. MDAC contains all necessary
components to connect to SQL Server, except the application to connect. You
can use Query Analyzer or Enterprise Manager or any other application that
connects to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||simply run the connectivity tools which is avalable in sql server cdrom.
"brbaskets" <anonymous@.discussions.microsoft.com> wrote in message
news:944a01c4337c$8f2dc800$a501280a@.phx.gbl...
> Can anyone tell me how to setup a client connection to
> SQL server 2000?