May 21, 2007 at 11:08 am
I'm connecting to a SQL 2000 instance from a SQL 2005 Management Studio. Everything seems to work fine, except I can't view properties for SQL Server Agent jobs on the 2000 instance. I can see the jobs, but when I view the properties there are no steps, no schedules, nothing. Everything is blank. I can script it out and the properties are in the script, but I can't do anything via the interface. Is this normal? Thanks for any info!
May 21, 2007 at 11:41 am
Is it a permissions problem? Are you in the sysadmin group on that server? Are you connecting using a domain account or a SQL Server account?
May 21, 2007 at 11:52 am
Yes, I'm connecting as a sysadmin, and using a SQL Server account. The thing is, if I use SQL Server 2000 Enterprise Manager, it works fine (connecting as the same user). It seems to just be when I use Management Studio? Are you supposed to be able to use Management studio to edit 2000 jobs? I don't think it's a permission issue, I thought it might be a bug. But if it does indeed work, I'll keep looking and see if there's some other permissions thing going on or something. Usually if I don't have permission, I don't even get to see the job objects. They're there, I just don't see any of the properties in them...
May 21, 2007 at 12:44 pm
I had the same problem in 2005 for 1 day. I could not see steps of the job I created. The next day it was fine. I can not reproduce the problem now.
Regards,Yelena Varsha
May 22, 2007 at 7:22 am
I saw that problem when I had moved the SQL 2000 jobs to a different server and had NOT opened them in enterprise manager and saved them on that server. Once I had opened and saved them on that server, I could then use the bolt on to open them in SQL 2005.
Hope this works for you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply