Installing SQL Query Analyzer

You install SQL Query Analyzer as part of the SQL Server 2000 installation process. The Typical and Minimum setups both install SQL Query Analyzer by default, but the Custom setup gives you the option of installing this tool, as you can see in Figure B.1.

Figure B.1. Using the Custom setup, you can select which SQL Server components to install.


It is possible to install SQL Query Analyzer on a client computer even if the server components are not installed on the same computer. This allows for remote access to SQL Server.

A special case is the remote access to a computer through the Internet. In this case, the simplest way is to create a server alias using the Client Network utility, specifying the IP address as server name and a server alias name to be used when connecting by SQL Query Analyzer and other client tools. Figure B.2 shows a typical example of this alias creation form.

Figure B.2. Using the Client Network utility to define a server alias simplifies the access to remote servers.


..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.17.187.119