July 2, 2012 at 8:49 am
I have Enterprise Manager installed on SQL Server 2000 (standard edition). I have SSMS 2008 R2 installed on my workstation. Via SSMS I can access the instance - see databases, jobs, maintenance plans etc. When I remote to the server and use the SQL Enterprise Manager - when I open the SQL Server Group - I get "no items".
The backup jobs are still working (confirmed via workstation SSMS and backup files on the server). Can anyone tell me what the issue is here? Permissions? Is there a service I need to restart?
Any comments / URLs would be appreciated - thank you.
July 2, 2012 at 8:51 am
Yu will need to register the SQL server under the SQL Server Group. Its local profile based so if you have never used Enterprise Manager on the server before you will need to configure it.
http://msdn.microsoft.com/en-us/library/aa198220%28v=sql.80%29.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply