Target Installation Checklist - MSSQL on Windows (goes without saying)

• Install Strawberry Perl
• Install CopSSH
• Create SSH password-less connectivity
• Give MSSQL Access

1. Download CopSSH and Strawberry Perl Software to DBAmon MASTER -

   You will need Strawberry Perl and CopSSH software for the TARGET installation. I would suggest that you download each of these packages once and save them on your DBAmon MASTER server. You can then download these 2 files to each of your TARGETs. The best way to find the software would be to google:

   • CopSSH 3.1.4
   • Strawberry Perl 32-bit (any current version - I am using 5.12)
   • Strawberry Perl 32-bit (any current version - I am using 5.12)

2. TARGET Server Account -

   I would suggest that you pick a single AD DOMAIN account which will be used for all DBAmon TARGET installs. After you have created this, add this DOMAIN account to the LOCAL ADMINISTRATORS group on the TARGET server. For the purpose of this document, we will call this userid dbamonaccount. You can call it anything you want. Login to the TARGET server as this account. This account will be used to perform the DBAmon TARGET installation.

3. Copy Install Files to TARGET Server -

   Copy the 2 files that you downloaded above to the TARGET server (Strawberry Perl and COPSSH).

4. Install Strawberry Perl Software -

   First install Strawberry Perl. If the TARGET server is running Windows 64-bit, then make sure that you install Strawberry Perl 64-bit. This is very easy - take all defaults. It should take about 2 or 3 minutes.

5. Install CopSSH Software -

   Begin the CopSSH install. Take all defaults including the account that the service will execute under.

   After the software has been installed, you will see a message: ICW OpenSSH is installed - ... - Use 'Activate a user' from the start menu for user activation. We need to do that. Click OK for the above message, and you will see a message the the OpenSSH installer is complete (hopefully with NO ERRORS). Click CLOSE to end that dialogue. Now go to START -- ALL PROGRAMS -- COPSSH - 1. ACTIVATE A USER. User SELECT USER NAME type the user name that you are using (how you are logged in now). Note that you do have enter the domain name here (i.e. (Domain\dbamonaccount). On the right of the screen as-is (/bin/bash for the shell) and UNCHECK all 3 boxes. Click NEXT.

   You should see a message the the userid that you specified is activated successfully. OpenSSH and Strawberry Perl are now installed on the TARGET server.

   On the TARGET server, ensure that the newly created Openssh SSHD service is running (the CopSSH installation created this service). If it is not, figure out why not!

6. Verify Installation of CopSSH and Strawberry Perl Software -

   From the MASTER server, open a CYGWIN window.

   You will be doing the initial SSH connect from the MASTER to the TARGET. Run:

   ssh hostname_of_target_server 

   You should see a message about RSA Keys... Are you sure you want to continue connecting. Reply yes. You will now be prompted for the password. You won't see the DOMAIN name for the userid that you see here, but this is the password for the DOMAIN userid that you activated above. Enter the password now. It should allow you to login to the bash shell on the TARGET server.

   To verify that Perl was successfully installed, run now (still in the BASH shell on the TARGET server):

   cmd /c '\perl\bin\perl -v' 

   You should see amessage which states which version of Perl is installed. If not, figure out the problem and fix it! :o)

7. Push the SSH Public Key To The TARGET Server -

   When you installed DBAmon on the MASTER server, you created a PUBLIC SSH KEY. You will now push that key out to the TARGET server. This will allow you to connect password-less to the target as this USERID on the MASTER server. Run on the MASTER in a CYGWIN shell window (this program live in /opt/dbamon/bin so it should be in your PATH):

    ssh_install  

   Follow the prompts. After supplying the TARGET hostname and userid, you will have to enter the password for that user on the TARGET server 4 of 5 times.

8. Change the Openssh Service Credentials on the TARGET Server -

   Now that we have the keys set, stop the Openssh service on the TARGET server. Change the service credentials from whatever it put during the install, to your dbamonadmin domain account. Since this account has ADMINISTRATOR GROUP access on the TARGET server, it will solve that problem.

   To verify that this worked, run (on the MASTER - CYGWIN shell window):

    ssh dbamonadmin@the_target_hostname 

   You should not be in a BASH shell window on the TARGET server and it should NOT have prompted for a password. Enter hostname to verify where you are.

   Note that if you run ssh the_target_hostname you will see a nasty error message (something about 'could not load u'). We have to change the userid which runs the Openssh service next on the TARGET server.

9. MSSQL Access for TARGET Probe -

   The probe will connect to MSSQL now as the owner of the service -- so add a SQL LOGIN for your DBAmon userid (dbamonadmin) and grant access. It will work if you give this user the MSSQL SYSADMIN role.

10. 'dbamon test' To Verify The Installation -

    After you create the DBAMON TEST MODE DBC file, you should be able to run dbamon test on this new TARGET server. Congratulations!

DBAmon.com
This Document: http://dbamon.com/config/target_config_mssql.shtml