CODEWITHSUNDEEP
sqlsql-serverssms-2012
mounika
mounika

Reputation: 63

Not able to connect to SQL Server 2012 Mangement Studio

My instance name is MSSQLSERVER and while I connect to Management Studio, I use .\MSSQLSERVER to login. I have gone through all the threads here but everyone is suggesting to enable tcp, pipes, shared memory which I have done and restarted the server too. Also I am using .\instance name as suggested. But still can't connect, and I get the following error

TITLE: Connect to Server

Cannot connect to .\MSSQLSERVER.

ADDITIONAL INFORMATION:

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 instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)

It would be great if someone could help me with this

Upvotes: 1

Views: 53

Answers (1)

marc_s
marc_s

Reputation: 755451

MSSQLSERVER is the SQL Server service name for the default instance which is the instance without any instance name - so to connect to this (unnamed) default instance, just use 

.
(local)
localhost
your-machine-name

without any "instance" name (since there is NO instance name)

Upvotes: 2

Related Questions