SQL Server 2005 and 200 in same PC
-
Can we install both SQL serevr 2005 and 2000 in same PC
I installed it.but then sql server 2000 gave me huge problems and I had to reinstall the sql 2000
My Blog:
http://dineshasanka.spaces.live.com/ -
Yes, but I installed both versions in different Drives.
-
Good news. so you didn;t have any problems and I also can follow the same path
My Blog:
http://dineshasanka.spaces.live.com/ -
On my dev box I had sql7 as the default instance , and SQl 2000 and SQL 2005 as named instances;
from the SQL standpoint I had no problem, and all were on the same drive; however many of my existing .NET applications started behaving strangely, becase SQl 2005 also requires the .NET 2.0 framework and the latest version of Visual Studio.
After The new Studio was installed, when running the code in the IDE of some existing applications i had no longer responded to mouse click events...a tab event on the WinForm would work, but the mouseclick of the buttons were always ignored; However, If I compiled the winforms into an executable, the behaved normally.
This made it difficult to debug the progrma for new enhancements and whatnot; eventually I had to uninstall 2005 and then the .NET 2.0 framework, then reapply Service pack 3a on my SQL2000 instance.
Finally, after all that, Query Analyzer lost it's syntax highlighting, and I found I had to regsvr32 an existing dll to get it to come back again.
HTH!
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Strange but I have had no problems having both the editions on the same drive ... I've recently installed the Feb CTP and it works for me like a gem.
Vinod Kumar
-
Vinod,
i tried do install the 2k5 on the server which as the Sql 2k server. the moment 2k5 was installed, the 2k MMC was not in my control, and then all the DBs of 2k are displayed in 2k5, and when i tried to activate the Bi or use the IW database, i failed to do so.
how did u manage to have both side by side, what need to be tuned to have both, can u pls advise.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply