Welcome to MSDN Blogs Sign in | Join | Help

Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

I ran across a challenge running SQL 2000 side-by-side with SQL 2005. 

Scenario

  • Need to run SQL 2005 Management Studio (with ability to migrate DTS packages into 2005)
  • Need to run SQL 2000 Enterprise Manager (need to manage SQL 2000 installs including diagrams)

Symptoms

With SQL 2005 Mgmt Studio installed with SQL 2000 client tools you may receive an error when running SQL 2000 EM like...

Entry Point Not Found
---------------------------
The procedure entry point ?ProcessExecute@@YAXPAUHWND__@@PBG1@Z could not be located in the dynamic link library SEMSFC.dll.

SQL Server Enterprise Manager
---------------------------
Connection to application object failed. Ensure that no program modules have been deleted.

Resolution

 

Published Saturday, March 18, 2006 9:22 AM by mab
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Thank you!!
Wednesday, July 05, 2006 5:07 PM by Chris

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Thanks, you're a lifesaver...

Monday, October 30, 2006 3:13 PM by Jim

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Thanks Mark for your information, you solved my problem

Wednesday, December 06, 2006 10:32 AM by Dominic

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Thanks, worked like a charm using your solution

Wednesday, April 04, 2007 12:06 PM by Bill

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Thank you! Mark. Saved me the hassle of troubleshooting.

Thursday, May 31, 2007 1:21 PM by Clement

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

If you get connection problems after installing all that, make sure the MSSQLSERVER Protocols (in SQL Server Configuration Manager, under Network Configuration) have "Named Pipes" and "TCP/IP" enabled.

Repeat for the SQL Native Client Configuration section too.

Re-start SQL services (or reboot).

Saturday, August 04, 2007 12:53 PM by Clicali

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Is a reboot required once the Management Studio is installed and before installing SQL Server Service Pack 4?

Also, which download(s) on this page should be installed: http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en#filelist?

Tuesday, August 14, 2007 4:27 PM by Chris

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Another person saved - I already had SQL 2000 Tools w/- SP4 working beautifully alongside SQL 2005 Management Studio when installing DTS Designer Components caused the Enterprise Manager MMC issue.

Luckily SQL 2000 SP4 let me do a reinstall which saved the day!  Thanks Mark!

Thursday, August 23, 2007 11:29 PM by Simon M.

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

Great..For me just installing SQL2000 SP4 worked.

Wednesday, September 05, 2007 9:16 AM by Anand

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

You also saved me too ... thank you !!!

Wednesday, September 12, 2007 8:40 AM by Luiz

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

SWEET! Works like magic. You dont have to reinstall anything like some blogs suggested.

Since I have done everything else on Marks list. All I did was install the SQL Server 2000 SP4 and pronto, I am ready to go.

Thanks a million Mark!!!

Friday, September 21, 2007 11:43 AM by Mike

# re: Running SQL Server 2000 Enterprise Manager and SQL Server 2005 Management Studio Side by Side

I ran in to this issue immediately after installing the SQL2K DTS tools as part of featurepak.

Reinstall of sp4 and subsequent security patches seemed to have solved teh issue.

Thanks for posting it on the web.

Thursday, October 23, 2008 12:00 PM by DVPRAO

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker