sql 2000 jobs

Question

Post reply

sql 2000 jobs

premkuttan

SSCommitted

Points: 1934
More actions
June 14, 2013 at 8:00 am

#275048

i have given access for a login to view sql jobs in sql 2000 server and the user is able to see the same whereas when he tries to connect from sql 2005 client(ssms). He is getting error like failed to retrieve data for this request.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

It's not quite clear what you mean, or what you did for access.

What did you do to grant access.

When you say he gets an error, do you mean he connects to a SQL 2000 instance from SQL 2005's SSMS client?

premkuttan SSCommitted Points: 1934 More actions · Answer 2

I had given db owner , targetserverrole access to MSDB database so he is able to view the jobs when he tries to connect from enterprise manager(sql 2000 instance) but when the user tries to connect the same sql 2000 instance from sql 2005 client machine he gets an error.... Hope i explained

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

It still isn't quite clear. The exact error and exact steps are needed, but you can debug this yourself as well.

run a trace on the 2000 server and watch what is called when the user connects with Management Studio. It's possible there is still a permissions issues since SSMS might make a different call.

I haven't heard of this particular issue with SSMS connecting to 2000, but not many people try to give access to jobs.

The other option is to grant access to sysjobs and sysjobschedules and let the users access information through scripts.

happycat59 One Orange Chip Points: 29389 More actions · Answer 4

premkuttan (6/14/2013)
I had given db owner , targetserverrole access to MSDB database so he is able to view the jobs when he tries to connect from enterprise manager(sql 2000 instance) but when the user tries to connect the same sql 2000 instance from sql 2005 client machine he gets an error.... Hope i explained

It's been a while since I used SQL 2000 but I think that the error when connecting to the SQL 2000 instance using SQL 2005 tools is because of changes that were introduced with SQL 2005. In particular, the object model used by Enterprise Manager is not supported when using Management Studio.