Link to home
Start Free TrialLog in
Avatar of a222493
a222493

asked on

Change/alias SQL Server Instance name

HI,
I have a default install of SQLEXPRESS installed on my worstation.  The instance of course is named localhost\SQLEXPRESS.  Is there a way to change the instance name to just "localhost"?

I have a lot of code that refernces "localhost"...
Avatar of sardiskan
sardiskan
Flag of United States of America image

SQLExpress means you are using SBS. This locahost is only there by default, you should change the name of your server from domain.local as well. You'll need to dump your data to a backup, drop the database name, then create a new database instance and import your data back in. But any applications that were referencing that database might run into issues if it was referencing the localhost/ part.
Avatar of a222493
a222493

ASKER

All I want to do is get rid of the "SQLEXPRESS" part of the instance name.  So that when I want to connect to my database I could simply use "SERVERNAME=localhost " instead of "SERVERNAME=localhost\SQLEXPRESS"

Can I do this?  How?
ASKER CERTIFIED SOLUTION
Avatar of a222493
a222493

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial