Obtaining your SQL SA Password

ISSUE

I do not know my SA password to log into SQL Management Studio

 

TROUBLESHOOTING

1) If you installed SQL via the Kaseya installer, you can obtain your SA password by navigating to the following directory on your Kaseya Server:

C:\Users\Administrator\AppData\Roaming\KInstall\Installers\SqlConfig.in

2) If you installed SQL Express or Full Edition using a personal copy (and NOT via the Kaseya installer), Kaseya does not store this password in any way. You have two options:

a) Log into SQL Management Studio using Windows Authentication. The best account to try with is the local administrator account (or the domain administrator account). Once you log in, you can then expand the "Security" folder, right click on the account "sa" and choose "Properties". Under the "General" tab you will be able to reset the password.

screenshot.png

 

b) If you are unable to log into SQL Management Studio using Windows Authentication, you will need to contact Microsoft.

 

Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section