Search code examples
authenticationsql-server-2017

SQL Server 2017 Developer edition user cannot connect

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

enter image description here

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

enter image description here

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

enter image description here

stus and grants to connect are in place:

enter image description here

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

Solution

  • 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.