I am trying to connect to my SQL Server 2012. I am able to connect using :
- 127.0.0.1
- localhost
- computer name
But why am I not able to connect using the SQL Server name (the default one : MSSQLServer) ?
Asked
Active
Viewed 43 times
0
marc_s
- 732,580
- 175
- 1,330
- 1,459
user1594047
- 181
- 1
- 1
- 12
-
Just use your PCNAME. – BizApps May 17 '13 at 01:46
-
yep but I should be able to connect using the sql server name. – user1594047 May 17 '13 at 01:50
-
4**No**, you are **NOT** able to connect using `MSSQLSERVER` because by definition, the **default instance** has no instance name. Only if you install a non-default instance, **then** you **must** use the instance name to connect to it. – marc_s May 17 '13 at 04:52