Search code examples
sql-serversql-server-2005named-instance

SQL Server, convert a named instance to default instance?


I need to convert a named instance of SQL server 2005, to a default instance.

Is there a way to do this without a reinstall?


The problem is, 2 out of 6 of the developers, installed with a named instance. So its becoming a pain changing connection strings for the other 4 of us. I am looking for the path of least resistance to getting these 2 back on to our teams standard setup.

Each has expressed that this is going to be, too much trouble and that it will take away from their development time. I assumed that it would take some time to resolve, in the best interest of all involved, I tried combing through configuration apps installed and didn't see anything, so I figured someone with more knowledge of the inner workings would be here.


Solution

  • As far as I know, no. One reason is the folder structure on the hard drive; they will have a name like MSSQL10.[instancename]