 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008Changing Named Instance to Default
It would really be helpful if I could change a named SQL Server instance to a default instance; can I do this? how? TIA > It would really be helpful if I could change a named SQL Server instance > to a default instance; can I do this? how? > > TIA sorry .. forgot to say this is a SQL 2005 server ... The supported way is to simply remove the named instance and install a default instance. Make sure you have your database backups and your hotfixes and service packs in-sync so you can restore them on the default instance >> It would really be helpful if I could change a named SQL Server instance >> to a default instance; can I do this? how? >> >> TIA > > sorry .. forgot to say this is a SQL 2005 server ... > The supported way is to simply remove the named instance and install a > default instance. Make sure you have your database backups and your > hotfixes and service packs in-sync so you can restore them on the default > instance thanks ... that's what I did a few hours after posting the question since I couldn't put it off; was hoping there was a quicker way but I guess there isn't L Liz Be aware that SQL Server Express Edition is installed as named instance > It would really be helpful if I could change a named SQL Server instance > to a default instance; can I do this? how? > > TIA > Liz > Be aware that SQL Server Express Edition is installed as named instance I'm not using Express but thanks for responding, Uri ... L |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.