Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to make an instance default instance on server

Author  Topic 

reddymade
Posting Yak Master

165 Posts

Posted - 2006-11-29 : 12:52:00
I have MSSQLSERVER as one instance which is default instance, had problems with that instance i had to install sql server one more time and now it created a new instance MSSQLSERVER1, is it possible to make the new MSSQLSERVER1 as a default instance.

"pacohost01\MSSQLSERVER1"

Thank you very much for the information

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-11-29 : 13:03:40
No, you can't switch a named instance to the default instance. You'll have to uninstall the default instance and reinstall SQL Server as the default instance.
Go to Top of Page
   

- Advertisement -