March 16, 2011 at 2:37 pm
I can get list of all databases when i run "select name from master.sys.databases " using my own id having sysadmin previlages but when i run it from the job i get only system databases, that job uses service account which also has sysadmin previlage, any reason?
March 16, 2011 at 2:41 pm
Have you tried a proxy account?
Have you tested the query with your service account from SSMS?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 16, 2011 at 2:43 pm
yes i tried from ssms using the service account, it gives me only master and temp db.
March 16, 2011 at 2:46 pm
Then it sounds like your service account is not a member of sysadmins or has been put only into the public role.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 16, 2011 at 3:04 pm
both are done.
March 16, 2011 at 3:06 pm
Did somebody by chance try hardening the security on the server by renaming one of those groups or altering the permissions on one of those groups. Compare exact group memberships between your account and the service account.
Also, try using another account besides the two already mentioned and set it up just like your account and see if that can see more than just the public type of data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 16, 2011 at 3:11 pm
how can i comapre group memeberships, is there any script?
March 16, 2011 at 3:25 pm
If you use Execute As and the service account for SQL Agent, what comes back?
March 16, 2011 at 3:50 pm
Steve Jones - SSC Editor (3/16/2011)
If you use Execute As and the service account for SQL Agent, what comes back?
Logging in from the account and executing the query direct in ssms, Tara has the same issue.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply