sql server 2005 - How can I setup MSSQL2005 to respond to "localhost" and another name at the same time? -

I am working on a code base that has several connection strings that access the database server with a specified name.

  & lt; Add name = "myconnection" connectionString = "data source = devserver; initial catalog = 'devData'; constant security information = true; user id = devUser; password = devPass;" Provider Name = "System.Data.SqlClient" />  

I am at the place where the designated "DevServer" does not have access to the data source.
I have a version of the locally hosted database in "localhost".
What I would like to do "" My "localhost" database can be used through a data source called "DevServer"

I do not want to lose the ability to access the server via "localhost" I have other projects that use it as a data source. I can make changes to config files, but then I have to make sure I do not check them because this will break the configuration for others. I still want to receive an update in the config files So, there is no alternative to having a local written version.

I have tried to use the SQL Server Configuration Manager to create aliases, but I think I did something wrong because I'm still unable to use "DevServer".

What am I trying to do with SQL Server Configuration Manager? Can anybody recommend that I get it?

I think my question is same but there is no accepted answer and this is for SQL Express. SQL Server Configuration Manager allows you to put the nickname under the original client configuration.

I think this is easy for me, but the host file solution should also work properly.

If you use SSCM, make sure that you do not have the main network (or while editing it), you will not be able to hit the correct server.