I am running sql standard 2008 r2 on my box. and its been working great. I just installed sql server 2014 on my machine as a second instance.
The service is running fine, but when I try to log into it with my sa password, I get an error about the login failing.
Assuming I maybe messed up the password on install, I uninstalled and reinstalled. Same issue.
The weird thing is that when I try log in with windows authentication, it also fails
yet I can log into my 2008 R2 instance with windows authentication, no problem
Something is bugging me that its not necessarily the log in, but maybe how the service is logging in, but it is logged in exactly the same way as the 2008r2 service.
Full error message is here
Server Name: CRAIG-PC\MSSQLSERVER2014 Error Number: 18456 Severity: 14 State: 1 Line Number: 65536
Thanks in advance
Full screen grab of services
browser is running from this path "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe"