Renaming default instance

  • I just installed SQL Server Express 2014 and changed default instance name to MSSQLSERVER. Is this OK ?

  • Do you mean you created a named instance? That's fine.

  • Yes it is fine.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • No,I actually renamed the default instance.... It was SQLExpress or something like that and I changed the name to MSSQLSERVER..

  • Senchi (6/18/2014)


    No,I actually renamed the default instance.... It was SQLExpress or something like that and I changed the name to MSSQLSERVER..

    SQL Express defaults to installing as a named instance, and if you changed that to MSSQLSERVER, then it's installed itself as a named instance with that name. If you wanted to install it as a default instance (e.g. not requiring the instance name to be specified when connecting to it) then you should have changed that option in the installer.

Viewing 5 posts - 1 through 4 (of 4 total)

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