Guide for How to make your Admin Tool to connect with the Database.
SQL Server 2005 and SQL Server 2008
Method 1: Use SQL Configuration Manager to specify the TCP port that is used to connect to SQL Server 2005 or SQL Server 2008
1. Specify the port that you want to use. To do this, follow these steps:
a. Click Start, point to All Programs, click Microsoft SQL Server 2005 or Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
b. Expand SQL Native Client Configuration, click Client Protocols, and then double-click TCP/IP.
c. Specify the port number that you want in the Default port box, and then click OK.
*IN YOUR CASE YOU NEED 9979 NOT 1433 OR 1434*
d. Restart SQL Server (MSSQLSERVER). To do this, click Start, type services.msc, find SQL Server (MSSQLSERVER) in the Open box, and then right click on it and then restart and OK.
Method 2: Use SQL Configuration Manager to add an alias and to specify the TCP port that is used to connect to SQL Server 2005 or SQL Server 2008
1. Specify the port that you want to use. To do this, follow these steps:
a. Click Start, point to All Programs, click Microsoft SQL Server 2005 or Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
b. Expand SQL Native Client Configuration, Client Protocols, and then click TCP/IP after change only Default Port in to 9979.
*Must be Enabled*
c. d. Restart SQL Server (MSSQLSERVER). To do this, click Start, type services.msc, find SQL Server (MSSQLSERVER) in the Open box, and then right click on it and then restart and OK.
*Remember that in all Client Protocols Dial Box, VIA must be Disabled
*So in your case as it was in mine that i couldnt connect the tools to the database, the port 1433 must be changed in to 9979*
Here are some pictures so you can understand better.
Trust me...If you make correct as i wrote up, your SCAdminTool+SCMonitor+SCDBTool will work properly.
Of corse if you made correct the XoRs...
WARonline
Ragezone