Post reply

Rename an instance ( SQL Server 2005)

  • December 16, 2008 at 6:16 am

    #216594

    Hello,

    I know it´s not easy, but I need to try it.

    My problem is:

    I have a sql server 2005 (sp 2) in production and the instance name on

    sp_helpserver is DB03 and I need to rename it to DB01

    How I do that whitout having problems?

    any ideas?

    thanks

  • December 16, 2008 at 10:23 am

    #913305

    Check-->

    http://msdn.microsoft.com/en-us/library/ms143799.aspx

    MJ

  • December 17, 2008 at 6:52 am

    #913790

    you can only rename the machine name part of a named instance. ie. machine\instancename. (or if it's a default instance, you can rename that). You cannot rename the instance part. You must uninstall and reinstall.

    Tim White

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply