0

I have SQL server 2008 and 2005 installed on one machine. I came to know that the SQL 2005 version is running as default. My question is how can i change the SQL to run 2008 version?

your help will be appreciated greatly

Thanks

Anish
  • 872
  • 5
  • 21
  • 42
  • Is your question about migrating the sql 2005 to sql 2008 or to set the sql 2008 instance as the default instance ? – tschmit007 Apr 02 '13 at 08:40

3 Answers3

2

It is not possible to change the named instance to default .... You have to reinstall...

I found one site which showed a combination of: sp_dropserver nameofinstance sp_addserver machinename,'local'

and some registry hacks.

Resource Link.

Vikramsinh Shinde
  • 2,742
  • 2
  • 23
  • 29
1

It's actually possible.

  1. drop current instname (sp_dropserver)
  2. add new instance name (sp_addserver 'new name','local')
  3. stop sqlserver
  4. modify hklm\software\microsoft\microsoft sql server\
  5. modify hklm\system\mssql$
  6. use "sc create" to add new mssql$
  7. start up with new inst_name
Luigi Saggese
  • 5,299
  • 3
  • 43
  • 94
0

I think it is not possible to make a named instance the defautl instance. Reasons are given here.

But if you need to have a sql 2008 as default instance a method is suggested here. You have to installe a new instance and set it as the default one.

Community
  • 1
  • 1
tschmit007
  • 7,559
  • 2
  • 35
  • 43