CODEWITHSUNDEEP
sqlsql-serversql-server-2012-express
user2502947
user2502947

Reputation: 69

How to change my SQL2012 server name to localhost?

After I installed SQL 2012 Express, I can't connect to localhost or (local) to local server.

I have to put my computername/instance name in order for me to connect to server.

Can anyone help me with this?

Upvotes: 0

Views: 6359

Answers (1)

Aaron Bertrand
Aaron Bertrand

Reputation: 280590

You can't change a named instance to a default instance without reinstalling SQL Server. You can perhaps fool it with client network aliases and/or port redirection, but wouldn't it be just as easy to specify one of the following when connecting?

YOUR_PC_NAME\SQLEXPRESS

localhost\SQLEXPRESS

(local)\SQLEXPRESS

.\SQLEXPRESS

Upvotes: 6

Related Questions