Coexistence of SQL Server MSDE and Enterprise Edition 2000

  • What tools are you speaking of, EM, Query Analyzer etc?

    check and make sure your shortcuts are pointing to the correct locations.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • SQL Query Analyzer and SQL Profiler in the EM.  Query Analyzer on the client works.

  • Most likely what is happening is that you installed your program files, not just your databases to d:\.  When the citrix install came through it installed many of the same Parts of the SQL programs files directories to c:.  Because of this there somethings are looking to c:\program files\Microsoft SQL Server\80\bin while other parts are registered to d:\program files\Microsoft SQL Server\80\bin. 

    I've had MSDE, Standard Ed, and developer edition all on the same machine, with the database files in varying locations, but the program files were all located on the same drive. 

    Reinstalling the enterprise edition so that the program files are located in the same place as citrix wants the MSDE files would most likely fix your issues.  You could try reinstalling the MSDE portion of the citrix solution to d:\ but that may break thier application or at the least put it into an unsupported environment.  You'd perhaps be best server by contacting Citrix support.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply