Need help finding SQL Server DB Username and Password

  • Questions
  • Need help finding SQL Server DB Username and Password
Question ID: 108452
0
0

I am trying to connect to the ALM DB and I am not finding the username and password to be working! I also found that when I try to ping the database from Site Admin, it fails as well. How can I get that info or change that info?

Marked as spam
Posted by (Questions: 219, Answers: 23)
Asked on June 19, 2018 8:55 pm
3 views
Answers (1)
0
Private answer

Hello. I would like to start off by stating that this will only work if your SQL Server Database was installed using Mixed Mode, enabling you to use both SQL Authentication and Windows Authentication to login. First, I would like for you to access Site Admin, click the 'DB Servers' tab, and record the value displayed in the 'Database Administrator User Name' field. Next, I would like for you to exit ALM, and open SQL Server. On the login window that displays, click the drop down in the 'Authentication' field, select the value 'Windows Authentication' from the list that displays, and click the 'Connect' button. Once you are logged into SQL Server, expand the 'Security' and 'Logins' folders. In the 'Logins' folder, locate and select the username that you recorded from the 'Database Administrator User Name' in the 'DB Servers' tab within Site Admin. In the 'Login Properties' window, you will enter the new password and click the 'OK' button. Exit out of SQL Server, then reopen SQL Server, change the authentication back to 'SQL Server Authentication', and test the new password that you just created. You should be able to successfully login to the database. Back in the 'DB Servers' tab in Site Admin, try pinging the DB Server again using the same credentials. The ping should be successful this time.

Marked as spam
Posted by (Questions: 2, Answers: 280)
Answered on June 19, 2018 9:02 pm
Thank you! Your suggestion helped me resolve the issue.
( at June 19, 2018 9:05 pm)