The SQL Server Administrator's Console

infomation & knowledge sharing for building, monitoring and maintaining excellent data solutions
Console     SQLClue     DBA Scripts     Feedback      
Configuration Compare     SQL Configuration Archive     Data Center Runbook     Report Library     License     Download     FAQ      
Download SQLClue

SQLClue_1_4_1_4.zip

To upgrade an existing SQLClue installations please review the update steps listed below the new installation instructions. Note that the upgrade steps may change for each release.

Install SQLClue Workstation (base SQLClue install - required for Workstation and all Server SQLClue Editions):
  1. Verify that all SQLClue prerequisites are installed on the local system:
  2. Download the .zip file using the link above and extract the installation executable (.msi) file.
  3. Run the installer while logged on as a local administrator.
  4. Start SQLClue using the "Run as Administrator" option.   

Verify the Workstation installation by completing a compare. See the "Comparing SQL Server Configurations" tutorial under the help menu option to get started.

 

On Windows Vista, Windows 7 and Windows Server 2008 it is necessary to run the SQLClue application the first time it is started using the "Run As Administrator" option. This is necessary to create the Source types in the local system that identify messages posted by SQLClue in the Windows Application Event Log as from "SQLClue". Once the Event Log Source labels are created the SQLClue Workstation does not need to run as administrator.

Install SQLClue Server (Initialize the SQL Configuration Archive database components):
  1. Complete the base SQLClue Workstation installation. 
  2. Verify that SQL Server 2008 SP1* with Full-Text Search enabled is installed on the local system.
    • (freely available SQL Express will work, but get the one that includes Full Text Search)
  3. Start SQLClue
  4. From the Tools menu, select "SQL Configuration Archive" and then select "Install".
  5. In the connection dialog that opens select or enter the local SQL Server instance that will be used to host SQLClue
  6. Accept the provided database name, enter the name of any existing user database, or enter a name for a new database. 
      
  7. Set any available connection options that SQLClue should use when connecting to the SQL Configuration Archive database and select 'OK'

Verify the Server installation by planning and executing a SQL Configuration Archive. See the "Archiving SQL Configuration" tutorial under the help menu option to get started.

 

For temporary installations - including trail and evaluation - time limited access begins when the SQL Configuration Archive is installed.

Install the Data Center Runbook (Initialize the Data Center Runbook database):
  1. Complete the base/SQL Configuration Archive SQLClue Server install
  2. Start SQLClue
  3.  
    From the Tools menu, select "Data Center Runbook" and then select "Install".
  4. Accept the provided database name, enter the name of any existing user database, or enter a name for a new database. 
  5. Set any available connection options that SQLClue should use when connecting to the Data Center Runbook database and select 'OK'

Verify the Data Center Runbook installation by adding a document to the Runbook Library. See the "Contributing to the Runbook" tutorial under the help menu option to get started.

Install the Automation Controller Service (Enables task scheduling using the SQLClue Administrator's Console):
  1. Complete the SQLClue Server install
  2. Obtain a Windows user name and password for use as the Automation Conrtroller service start-up account. This account must be added to the sysadmin Fixed Server role of all SQL Servers that will be targeted by the SQL Configuration Archive. It may also require read access to network file system locations where documents included in the Data Center Runbook are stored on an as needed basis.   
  3. Set the SQLClue Administrator's Console to always run as administrator. Consult your Windows Administrator if unsure how to set the application to always run as administrator.
  4. Start SQLClue
  5. From the Tools menu select "Automation Controller" and then select "Install".
  6. A Windows installer will open to install the service. Step through the installer dialog. Enter the service account user name and password when prompted.

Verify the Automation Controller by Opening the "Tools"|"Automation Controller" menu item. When the service is running the options to "Pause" and "Stop" the service will be enabled and the options to "Start" or "Continue" the service will be disabled. Alternately the Automation Controller can be verified by opening the SQLClue Dashboard report ("Reports"|"Dashboard" menu option) and selecting the expander control of the the "Automation Controller" box in the upper right area of the report. The status of the should be "Running" and the text color will be green.   

 

The SQLClue Administrator's Console provides full administrative control of the Automation Controller service. The Console communicates all automation settings changes made by the administrator to the service.

Provision SQLClue Server Security Access:

Reviewing SQLClue's role based security model in the help documentation, then add the local domain users you have selected to the appropriate SQLClue database roles.

 

Update SQLClue Workstation:
  1. Uninstall the existing SQLClue Workstation using Windows Control Panel.
  2. Complete the base SQLClue Workstation installation. 

 

Update SQLClue Server:

  1. Backup the SQL Configuration Archive database and the Data Center Runbook database.
  2. Using the SQLClue Console or the Windows Service Manager stop the SQLClue Automation Controller service if running.
  3. Using the SQLClue Console or Windows Control Panel, uninstall the the SQLClue Automation Controller Service if installed.
  4. Uninstall the existing SQLClue Administrator's Console using Windows Control Panel
  5. If you are not already using the Visual Studio 2008 SP1 build of the ReportViewer component this is a good time to update it.
    • Uninstall the current ReportViewer using Control Panel, then
    • download and install the latest build from the Microsoft download site or here.
  6. Follow the "Base SQLClue Install" installations above, reinstalling all components that have been in use.  
  7. Select or enter the existing database name during the install to attach to your existing database. The application will automatically update the database components with no loss of data. 

 

Releases prior to v1.3.5.8 are not reusable. Install the current release into a new database. The old database can be saved as static archive that can be queried from SSMS.

 

If you run into any unexpected issues with the install or with the software please let me know straight away. I'll help you work through them in every way I possibly can. I can only help you preserve your data if you contact me before any data is lost.

 

*SQL Server Express Edition with Advanced Services, SQL Server 2008 Workstation Edition, SQL Server Standard Edition, SQL Server Enterprise Edition. For evaluation purposed, SQL Server 2008 Developer Edition can also be used.

 

This page was last modified on Sunday, February 06, 2011 04:06:33 PM