sql 2000 jobs

  • 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.

  • 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?

  • 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 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.

  • 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.

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

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