Knowledge Base Article

Home Page > Knowledge Base > KronoDesk

Home Page > Knowledge Base > Spira Platform

Home Page > Knowledge Base > Spira Platform > SpiraPlan

Home Page > Knowledge Base > Spira Platform > SpiraTeam

Home Page > Knowledge Base > Spira Platform > SpiraTest

Article Running Queries Using SQL Server Management Studio

by Adam S on Monday, September 14, 2015

During the course of investigating a technical support issue for SpiraTest, SpiraPlan, SpiraTeam or KronoDesk , the need may arise to run a query against your Microsoft SQL database. To do so, you will use Microsoft SQL Server Management Studio. If you did not install this when you installed SQL, you can install it from the original source.

Alternatively, you can download Management Studio Express, and use it to run the queries.

Before running any queries, make sure you have valid backups of your database and/or snapshots of the application server virtual machine.

Connecting to Your Database


Follow the procedure below to connect to your Spira or KronoDesk database.

  1. Login to a computer where SQL Server Management Studio is installed.
  2. Launch SQL Management Studio from the Start menu.
  3. Choose Database Engine as the Server type, choose the correct Server Name from the list or browse for the correct server.
    If your user account has rights to access the database, leave Authentication as Windows Authentication. Otherwise, switch it to SQL Server Authentication and enter the User name and Password for a SQL account with rights to access the database.Note: If you are not sure which account to use, you can confirm what’s being used by vCommander by opening the vCommander Control Panel.
  4. Click Connect.

 

Running a Query


 

  1. In the Object Explorer pane, expand the top-level Server node and then Databases:


  2. Right-click your Spira / KronoDesk database and choose New Query.

  3. Copy your query into the new query pane that opens:



  4. Click Execute.
Attachments
Article Info
Last Updated: 9/14/2015
Article ID: KB170
# Views: 800
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.