December 22, 2003 at 10:53 am
How to install MSDE on desktop while SQL 2000 Enterprise Edition already been installed?
We'd like to install MSDE and developing a VB6 code for our stores using. The same VB6 code already been developed with ADO in SQL 2000 Enterprise Edition in our headquarter data center. I have problem to install MSDE on my desktop due to a Full Version of SQL 2000 has been installed.
Q. 1, How to solve this issue for installation? Second instance? If second instance, will it effect my VB6 code developing?
Q. 2, How to transfer file back to Data center from stores? FTP? E-mail? Replication?
Thanks for your help!
Harrison Lee
Harrison Lee
212-729-5338
Harrison Lee
HCL618@yahoo.com
908-219-5435
December 22, 2003 at 1:45 pm
I have not tried this myself, but I suspect that you're having a problem, because SQL 2000 was installed as a default instance. I think MSDE has to be a default instance, so they can't live together like that.
If you had installed MSDE first and then installed SQL Server as a named instance, you would probably be OK.
December 22, 2003 at 2:05 pm
Sure you can install MSDE as named instance.
setup.exe /qn /i sqlrun01.msi INSTANCENAME="MYMSDE" /l*v c:\msde2000_setup.log
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply