November 14, 2006 at 8:37 am
We have a server that had Enterprise Edition SQL Server 2000 installed as the default instance on D:\. Following that, there was a Citrix implementation that performed its own MSDE SQL Server 2000 installation on C: with a named instance. So now we have two installations, each with its own instance, running on one server. In attempt to run some of the tools from the Enterprise installation, we get a Windows error 'specified file not found'. So here's the question, is running MSDE and Enterprise Edition of SQL Server on the same machine a supported configuration? If so, how do we resolve the 'specified file not found' error? Are there any other implications of having these two editions running together?
November 15, 2006 at 7:51 am
November 15, 2006 at 7:58 am
SQL Query Analyzer and SQL Profiler in the EM. Query Analyzer on the client works.
November 15, 2006 at 8:17 am
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply