I need to create a SQL DB backup for VeeamBackup DB (VBR 10). I’m using MS SQL Server Management Studio with Windows Authentication however the DB is not accessible with this user, do I need to use SQL Server Authentication with th “sa” user? if yes, I don’t have the password, is there a default password? if no, can I try to reset this password without problems?
Thanks for your help,
Omar De Souza.
Best answer by MildurView original
You can use this guide from Microsoft to create a admin account for you to access the database. Or reset the sa password.
This query should help you with that in mssql single user mode:
CREATE LOGIN TempLogin WITH PASSWORD = '************';
ALTER SERVER ROLE sysadmin ADD MEMBER TempLogin;
Typically when you install Veeam the account you use for the Services is also created in SQL too with access to the DBs and Server Admin. If you cannot access the SQL with the account then you will need to find another way to log in with either SA or another account with rights.
You can use this guide from Microsoft to create a admin account for you too access the database. Or reset the sa password.
Yes this is a very good article too. Good mention
Thanks guys for your help!
in the page before the credentials you need to change the used credentials for Veeam with SQL from local account to specific account
that will help you to connect to SQL DB by Windows Authentication