Enterprise Manager and Management Studio | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Enterprise Manager and Management Studio

I just installed SQL Server 2000 as the default instance on a machine which already has SQL Server 2005 named instance. For some reasons, SQL Server 2005 Management Studio cannot connect to the SQL Server 2000 instance. (Updates: Ignore this issue) I have no problem adding the SQL Server 2000 instance to Enterprise Manager. Cannot add SQL Server 2005 instance to Enterprise Manager. This is expected. When I start the SQL Agent Service in Enterprise Manager,I will get a message that another instance already started but it will continue to start the SQL Agent Service. Don’t understand why the message will be prompted since the SQL Agent services are for different instances of SQL Server (one for SQL Server 2000 and another one for SQL Server 2005).
Thanks for any help.
Can you check the name for those 2 instances of SQLagent that are generating this error? Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>