I have been using SSMS and logging in through server authentication for a week now and yesterday when I tried to login it suddenly told me "no process on the other end of the pipe".
I researched online and it said the problem is that the security property for the server is set to windows authentication and has to be changed to server authentication. So I log in to SSMS through windows authentication first to change it, however it said that I do not have permission to change the authentication mode, which is weird because I ran the SSMS as admin and it was on server authentication previously.
Now I can not access my database at all as when I created the database it was under the SA account and it will just tell me I do not have permission to open the database or do anything basically.
Also just for a side info the problem arised after I restarted my computer I believe, the server property is suddenly changed to windows authentication and I cannot log in through the SA account nor can I change it back to server authentication
Best Answer
The issue here is most likely that "Windows Authentication" was chosen (by yourself or someone else with access) but the service not restarted. Following your machine restart, SQL Server came up with only Windows Authentication enabled.
To regain access to your SQL instance, you need to restart the server in admin mode and re-enable access. This link from Microsoft describes the process, however, below is a high-level overview: