Question about MSDE
-
Is it possible to run an instance of MSDE,SQL server 2000,and SQL server 2005 all on the same machine?
I already have SQL server 2000 and SQL server 2005(Developer Edition) on a development machine I'd like to add MSDE along with them in order to run a test upgrade for an application we're using.
-
i think you are confusing the versions a little bit.
if you have a non server operating system, your SQL 2000 instance IS a MSDE instance...if you had either the SQL2000 Enterprise or SQL2000 standard edition CD, when you installed it on a non-server operating system, it automatically dummied itself down to the desktop version...MSDE is exactly that except it does not install teh tools you use every day, like enterprise Mananger and Query analyzer...those are licensed to the Standard/enterprise disks...
if you installed the redistributable MSDE on a "clean" machine, you'd have everything you have now, just without the client tools.
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! -
Theoretically you can. Practically (???) it depends. I had a case just yesterday when I was called after someone who had MSDE working and installed SQL Server 2000 client tools had MSDE problems. I did it myself sevreral times (MSDE +Client tools), but sometimes things don't work as expected. Have everything well backed up before you start.
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply