none
How to remove/change instance name in SQL Server 2005?

    Question

  • hi,

    May i know how to change/remove the instance name from SQL server 2005?

    like Server001\SqlServer2005 to Server001\Sql2005?

    I try

    sp_dropserver 'Server001\SqlServer2005'
    GO
    sp_addserver 'Server001\Sql2005', local
    GO

    but it can't work.

    any idea?

    thanks a lot.

    Sunday, March 8, 2009 1:03 AM

All replies

  • There is not a supported way to rename an instance. You need to uninstall and then reinstall.

    Thanks
    Sreekar
    Sunday, March 8, 2009 3:02 PM