Create DB User

Telle Cestic 21 Reputation points
2021-07-12T14:31:00.137+00:00

Hi all,

I am a complete beginner when it comes to Databases.
I have created a Database, new Database Table and a new User.
Somehow, I cannot login with this new user using the "SQL Server Authentication" login method.

Right now I'm using the built in Windows account to connect to my SQL Server.
Does anyone know if I am forgetting something? The youtube tutorial shows it exactly like I did it, but I just cannot login.

Thank you,
Telle

I keep getting this error code in the attachment113955-errorcode.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,338 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,906 Reputation points
    2021-07-12T14:59:25.537+00:00

    Try enabling Mix authentication mode if it is disabled

    https://community.bmc.com/s/article/Enable-mixed-mode-authentication-for-SQL-Server


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Telle Cestic 21 Reputation points
    2021-07-12T15:13:40.62+00:00

    Thanks a lot. Been trying around for 1 hour just because of one checkbox.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.