Condividi tramite

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

  • Articolo

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

Comments

  • Anonymous
    July 05, 2006
    Thank you!!

  • Anonymous
    October 30, 2006
    Thanks, you're a lifesaver...

  • Anonymous
    December 06, 2006
    Thanks Mark for your information, you solved my problem

  • Anonymous
    April 04, 2007
    Thanks, worked like a charm using your solution

  • Anonymous
    May 31, 2007
    Thank you! Mark. Saved me the hassle of troubleshooting.

  • Anonymous
    August 04, 2007
    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).

  • Anonymous
    August 14, 2007
    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?

  • Anonymous
    August 23, 2007
    The comment has been removed

  • Anonymous
    September 05, 2007
    Great..For me just installing SQL2000 SP4 worked.

  • Anonymous
    September 12, 2007
    You also saved me too ... thank you !!!

  • Anonymous
    September 21, 2007
    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!!!

  • Anonymous
    October 23, 2008
    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.