SQL Server 2017 Developer edition user cannot conn

问题:

I have SQL Server 2017 Developer edition. I am creating user there with server authentication:

After adding, I can see user in logins for the server:

but when I am trying to connect with this user, I get an error:

stus and grants to connect are in place:

I restart server after adding user still not able to login. Is it some of the limitations for Developer edition?

回答1:

Right-click on your server properties, select security, and then set the authentication to mix mode. "SQL Server and Windows Authentication mode".

Hope this helps.