I was looking around since too long, without finding anything, so badly I decided to ask here my problem, all by myself :-P
So here it is.
I work with a certain software, which use a MSSQL DB.
I'm at a point where I'd like to scheduled a task to backup certains files AND a precise DB on the MSSQL server.
first problem is that the user logged in, don't have any access granted on the DB to backup it. Each time a get the message
Msg 916, Level 14, State 1, Server XXXXX\XXXXX, Line 1 The server principal "domain\username" is not able to access the database "XXXX" under the current security context. Msg 3013, Level 16, State 1, Server XXXXX\XXXXX, Line 1 BACKUP DATABASE is terminating abnormally.
- from the commandline
C:\sqlcmd -E -S XXXXX\XXXXX-Q "BACKUP DATABASE XXXX TO DISK='C:\TEMP\toto.bak'"
second problem is that I even don't have any access to the DB... so I cannot GRANT acess at all, to anybody...
somebody knows a workaround I could use to achieve what I'm trying to do ?