How to access MS SQL server 2008 default instance or named instance from SQL query analyser.

Step -1:
1. Go to MS SQL Server 2008 Configuration Manager.
2. Extends SQL server network configuration.
3. Select protocol for named instance.
4. Enable TCP/IP protocol
5. Double click on TCP/IP protocol or right click to open property window.
6. In property windows, go to “IP Addresses” tab page
7. Go to node – IP ALL
8. Note down TCP Dynamic Ports number.

Step -2:
1. Open MS SQL query analyser.
2. Enter SQL server details. For login to default instance, just type IP address of the server where MS SQL 2008 is installed. You can also specify default port number associated with default MS SQL instance like . The default port number 1433. For named instance, specify the named instance dynamic port number with SQL server IP address.
E.g. <137.40.68,56989>.
3. Enter user name and password to access the server.