Unable to view jobs in sql server 2000
My users were not able to see jobs all of a sudden, can u pls throw some light pls...we are using a sql server 2000 in this case.
Nothing has chnaged as of users view. from the last 2 days msgs were not available in Error log to know wat hapnd.
they were a part of serveradmin roles and shud be able to see them,
Nothing has chnaged as of users view. from the last 2 days msgs were not available in Error log to know wat hapnd.
they were a part of serveradmin roles and shud be able to see them,
ASKER
nopes ...they are still members of the server admin ....and they are able to login the server ...only prob is ...they are not able to see the jobs simple....:(
I guess removing the builtin\Admin group is not a possibility since they were able to login
I guess removing the builtin\Admin group is not a possibility since they were able to login
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Just restart the server.
Just restart the server.
ASKER
Thanks yaar, will chk with the suggested replies in another 1 hour.
ASKER
U know wat..i have got this info by googlin' but not as clear as urs. KEWL thanks buddy
ASKER
but i still have a prob...for one user A adding him to targetserverrole did work..but for the other B i have added his login to the security role and did the same under msdb but complain that he is not able to see the jobs...default db is master for the user B and since we have added him to msdb ..it also counts thats the info part...now i wanted to try is...delete user B from the security roles..taking him back to his previous state...can anybody suggest on this pls
Is there any chance the 'Builtin\Administrators' group was removed from the logins??