SQL Server 2012: Login to PC-NAME\SQLEXPRESS works, but not to local/(local)

sql-server database-connection connection-string sql-server-2012 sql-server-2012-express
mosquito87 picture mosquito87 · Feb 22, 2013 · Viewed 9.6k times · Source

I'd like to login to my SQL Server 2012 Express with servername local or (local) but it doesn't work.

The only servername which works is PC-Name\SQLEXPRESS.

local/(local) has to work somehow because I have to use the following connection string:

Data Source=localhost;Initial Catalog=...

Answer

mosquito87 picture mosquito87 · Feb 23, 2013

I've reinstalled it and ensures to select "default instance" instead of "named instance" during the installation. Now everything is fine again.

Related questions

A network-related or instance-specific error occurred while establishing a connection to SQL Server

I deployed my asp.net web application on somee.com, whenever I login into this site (ipc.somee.com) it gives me a network related error like: A network-related or instance-specific error occurred while establishing a connection to SQL Server. …

Read More
What is the point of "Initial Catalog" in a SQL Server connection string?

Every SQL Server connection string I ever see looks something like this: Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database; Integrated Security=SSPI; Do I need the Initial Catalog setting? (Apparently not, since the app I'm working on appears to …

Read More
Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More