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"...
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"...
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.
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\SQLE XPRESS"
Can I do this? How?
Can I do this? How?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.