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

Selected files will be attached to any email sent on saving ticket.

file selected files selected  () Delete Selected

  • Created:
  • by:

Select files to upload

Or drag and drop files here

Uploading …
Done!
Upload More?
There was an error.
Try again?

Save to upload the selected file(s)

Article Info
  • Last Updated: 9/14/2015
  • Article ID: KB170
  • Views: 1156