How Can I Change the Project DB Authentication used in ALM?
Question ID: 105980
0
0

Hello,
How can I change the project DB authentication within the DB for ALM? We have restored a project from another DB and the other DB was using Windows Authentication and the new server is using SQL authentication for the projects and DB. We cannot restore the project to ALM as it is currently as it fails authentication.

Thanks,
HomerJ

Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on March 26, 2015 4:40 pm
22 views
Answers (1)
1
Private answer

Hi,
In order to change the authentication from one type to the other you can run the following SQL queries against the project_DB tabkles:

SELECT 'exec sp_changeobjectowner ' + TABLE_NAME + ', td'
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbo'

The output of this query is then a series of queries to be run to change all the table ownership to the td schema. They are copied from the results table and pasted into a new query and then run against the project DB tables to change them all.

If you need to change from td to dbo, then you would reverse where the td and dbo are in the above query (placing the dbo in place of the td at the end of the first line and the td in place of the dbo in the second line.

After the queries are run then refresh the project db and check that all the tables were changed from dbo. to td. or vice versa.

Hope this helps,
Dan

Marked as spam
Posted by (Questions: 0, Answers: 770)
Answered on March 26, 2015 4:46 pm
0
That worked perfectly and we were then able to restore the project. Thanks for the assistance.
( at March 26, 2015 4:47 pm)
EyeOnTesting

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

X
Scroll to Top