Timeline for Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 4, 2013 at 9:04 | comment | added | Ibrahim Mezouar | I tried this but it didn't work. but if the problem really lies within the hosts file, how come SSMS 2008 can connect to both instances? (2008 and 2012) I reiterate, I'm having this issue only with SSMS 2012. | |
| Jun 3, 2013 at 21:55 | comment | added | Aaron Bertrand | I am not sure I buy Pinal Dave's explanation. If he was trying to access the IP address 127.0.0.1, adding that entry to the hosts file does nothing - the hosts file is used to resolve names to IP addresses, not the other way around. | |
| Jun 3, 2013 at 21:52 | comment | added | Aaron Bertrand |
Also this will only help if you are accessing the instance using the explicit name LOCALHOST\instance name.
|
|
| Jun 3, 2013 at 21:48 | history | answered | TomGough | CC BY-SA 3.0 |