You must Sign In to post a response.
  • Category: SQL Server

    How to Converting SQL Server named instance to default instance

    Hi

    How to Converting SQL Server named instance to default instance.

    I have install in Sql Server for this instance
    ADMIN-PC\SQLEXPRESS

    but now i need no instance name after instance how to convert SQL Server named instance to default instance.

    I need my sql instance this
    ADMIN-PC

    no need SQLEXPRESS in SQLSERVER connection

    I searched google but no luck.

    any one guide me.
  • #767790
    Could you please try on below step:
    1. Login to Sql Server with another instance (not default one)
    2. Try below query

    sp_dropserver ADMIN-PC\SQLEXPRESS ;
    GO
    sp_addserver ADMIN-PC, local;
    GO

    3. restart the SQL instance


Sign In to post your comments