| Appendix A
To check for TCP/IP support and SQL Server Port number
1. Open SQL Server Network utilities by going to to Start Menu/Programs/Microsoft SQL Server/Server Network Utility.
2. If TCP/IP is present in the list of Enabled protocols as shown in figure below, then TCP/IP support is present. If not, it can be selected from the list of Disabled protocols and then click on Enable.
 3. Click on TCP/IP and then click on Properties. The port number used by SQL Server will be displayed as shown in figure 2.
Resetting SA password
To reset sa password follow these steps:
1. Open SQL Server Enterprise Manager by clicking on Start/Programs/Microsoft SQL Server/Enterprise Manager.
2. As shown in figure 3, e xpand a server group, and then expand a server. Expand Security , right-click Logins , and then double click on the sa login name.
|
