May 10, 2011 at 12:48 pm
I would like to explain the problem in another way..
Lets say the account(windows) i am using which is in problem is "OBBEAVER\SQLBAY2" and sql agent service run with this account.
1. No matter if the job owner is same as service account or some other account that has sysadmin, the job backs up only master database not other database in the server.
when tried this in a qry window..
execute as user='OBBEAVER\SQLBAY2t'
select name from master.sys.databases
the result i get is only master database.
May 11, 2011 at 9:36 pm
Tara-1044200 (5/10/2011)
I would like to explain the problem in another way..Lets say the account(windows) i am using which is in problem is "OBBEAVER\SQLBAY2" and sql agent service run with this account.
1. No matter if the job owner is same as service account or some other account that has sysadmin, the job backs up only master database not other database in the server.
when tried this in a qry window..
execute as user='OBBEAVER\SQLBAY2t'
select name from master.sys.databases
the result i get is only master database.
Check the logins in SQL Server that you have for that instance. Is the service account defined as a separate login? If not, do you have any of the local server groups defined as logins?
What logins do you have defined in that instance for the server? For example, do you have a login defined as ...\SQLSERVERAGENT?
And finally, if you do have the service account defined as a distinct login - what server roles have been granted to that login?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply