I have a login issue here. I created a new user login in SQL Server 2014. I tried to connect to my database using this new login and the below error pops up
Error: 18456, Severity: 14, State: 58.
I searched for the error and found out that I have to be in mixed authentication mode. I went to properties of the server and changed it to mixed mode from security tab, restarted SQL Server and still the same issue. I tried to investigate more and when I tried the below query
SELECT CASE SERVERPROPERTY('IsIntegratedSecurityOnly')
WHEN 1 THEN 'Windows Authentication'
WHEN 0 THEN 'Windows and SQL Server Authentication'
END as [Authentication Mode]
It shows that I'm still in Windows Authentication mode, although the fact is that I changed it to mixed mode.
I am still stuck with this issue and am not able to identify the problem. Can anyone help me out?
I am connecting from SSMS, not code.
Right clicking the server and going to
properties -> security, shows SQL Server and Windows.