2005년 7월 8일 금요일 오후 1:01Install two instance of SQL Server 2005 on the same box. I can see both instances from management studio, but could not connect to the second instance from SQL configuration Manager.
1) I install the second instance by accident and want to uninstall the second install, how do I do it?
2) In the mean time how can I shut down any service related to that instance so it does not take of extra resources?
Look forward to hearing from you.
2005년 7월 10일 일요일 오전 4:38
Hi Kuang -
Assuming you are using the June CTP release of SQL Server 2005, you can unistall any instances of SQL Server from "Add or Remove Programs" in Control Panel. To answer your second question, you can use SQL Configuration Manager or "Surface Area Configuration" tool to stop the services or set the service Startup Type to manual or disbaled. In "Surface Area Configuration", services are nicely grouped by instances.
2005년 7월 20일 수요일 오후 5:39
This would be great but I when I try to uninstall using add or remove programs it removed the primary instance and the secondary instance. I only want to remove one instance.