MS SQL not seeing the databases after adding user/pass in backup plugin | BackupAddict

Knowledge Base



MS SQL not seeing the databases after adding user/pass in backup plugin

that is a protection issue inside of the SQL database itself. Can generally be fixed by giving administrator and system dbadmin privs in the database. i.e., connect using admin command box and do something like this: sqlcmd -S .\instancename
EXEC sp_addsrvrolemember 'NT Authority\SYSTEM', 'sysadmin';
GO
EXEC sp_addsrvrolemember 'computer\administrator', 'sysadmin';
GO

Please rate this article to help us improve our Knowledge Base.

2 0