SQL Server: Login failed for SQL user

SQL Server: Login failed for SQL user

I had the free SQL Server 2019 Developer installed recently and tried to create SQL login and user. However, the new login couldn't be able to connect the server with the error: Login failed for user 'sennchiee'. (.Net SqlClient Data Provider).

To resolve this issue, connect SQL Server with Windows authentication and change the server authentication setting.

In the Object Explorer (usually on the left panel), right click on the server name and select properties. Select the security page and change the server authentication option to SQL Server and Windows Authentication mode.

No alt text provided for this image

Now restart the server for the change to be effective.

No alt text provided for this image

Once the server restarted, connect the server again with SQL login.

No alt text provided for this image
No alt text provided for this image

The SQL user connected successful now. =)

To view or add a comment, sign in

Explore content categories