Is there a way to quickly TEST our QC/ALM SQL-Server (back-end) connectivity
Question ID: 107764
0
0

Our company is pretty much locked down – security-wise and I cannot get the DBA’s to give me any Database "client" tools to test our SQL-Server connectivity with.

Are there any tools built into Windows that I can use instead?

Marked as spam
Posted by (Questions: 193, Answers: 14)
Asked on July 25, 2017 4:10 pm
140 views
Answers (2)
0
Private answer

Yes, there is an easy way to quickly TEST your QC/ALM SQL-Server (back-end) connectivity.

First, open your Windows Control Panel and Go to the Administrator Tools page

1. Select the ''ODBC Data sources'' tool AND ''ADD'' a datasource.

2. Select SQL Server Driver

3. Fill in the name and description (optional).

4. *** BE CAREFUL HERE *** DO NOT use the pull-down for SERVER, it will take a long time to search for available SQL-Server servers on your network.

5. Just TYPE the server name in the box and then ''Next''.

6. If it gets to the next page, there IS an active SQL-Server on this indicated server. -- The most common way to communicate with QC is via ''SQL-Server-authentication''.

7. Indicate SQL-Server authentication and provide either the ''td'' user name and password, OR the DB Admin (QC-DB-admin) user and password and click ''next''.

8. If the next page appears, your userID and password have been validated.

9. This is an easy way to test your userID's and passwords to confirm they work with SQL-Server.

10. Now, if we check the box for ''change the default database to'' and examine the database list, we should see familiar project names and our Site Admin schema/database.

11. That's it!

We have tested the SQL-Server name, userID and password, AND can see a list of all of the QC-related databases there.

We can now cancel/exit, or save as a ''DSN'' so we can come back to the same ''link'' and test again later.

Marked as spam
Posted by (Questions: 4, Answers: 509)
Answered on July 25, 2017 9:14 pm
0
Thanks, we prefer the ODBC GUI, it is easy and leads us through
( at July 25, 2017 9:27 pm)
0
Private answer

Here's an option using [Powershell][1]

[1]: http://www.sqlserver-dba.com/2012/11/sql-server-database-connectivity-test-with-powershell.html

Marked as spam
Posted by (Questions: 1, Answers: 6)
Answered on July 25, 2017 7:00 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top