MS SQL Server 2019 | How to create Database, SQL Login and User

Step by Step Tutorial Series of MS SQL Server 2019 Development for Absolute Beginners.

Please comment if you have any questions related to this session.
& Like, Share and Subscribe to my channel for continuous learning about whole Microsoft Database and BI Technology Concepts.

Thanks for your time on my videos. Happy Learning!!

[sakhaaskari]

Thank a lot for helping me with my homework ! you are my hero✨✨

[Development-fzvq]

Thank you for the Tutorial. I needed to change the Properties of the SQL Server Instance to Security -> SQL Server and Windows Authentication Mode in order to be able to connect with a new Login.

[milembepeter]

This is nice tutorial indeed, I understood it on the spot nd its very detailed for absolute beginners.

[hilariousguys]

vey nice information. thanks :) keep it up sir...:)

[vaishnavisubramaniyan]

Thank you for the video. It helped me to understand

[akura]

greate video. very usefull, simple, no bullshit, perfect! thank you very much

[abieswar]

very clear explanation good understanding very nice. hatsoff work.

[reylova]

Greetings from Puerto Rico Island of USA. Excellent video. Thanks

[ylanedoukhan]

HI i do all the same thing but when i enter a password for my login and go to connect.... error message appears 18456 and i go check my password and i see that sql express change my password

[mohammedhumayun]

Bro i have a serious problm on that... Can you reply me

[rathodkirthi]

what is server name. what should i write under server name

[icecp]

Where is Object Explorer? All I have is Administration and Schemas.

[gangar]

Hi, I have created new Login as showed here and the new one is listed under Logins. But when I try to connect to the DB using SQL authentication, that login is not listing. I can see only the default sa account. why this is happening?

[hakami]

I created the login and tried logging in using sql authentication but it gave me an error. error code : MSSQLSERVER_18456, which usually means my credentials was incorrect but it wasn't

[Joeron]

Nice. But how to change dbo on Schema. When get current_user. I couldn't get current_user on schema created. How?

[pkpkpk]

Dont forget to set on server "SQL Server and Windows Authentication mode"

[prabhatdass]

how much time it takes to learn complete MSBI

[BackBackForwardLightning]

14:35 I can create user from GUI without issue, but I cannot create login from CMD, get message: Msg 15247, Level 16, State 1, Line 4
User does not have permission to perform this action.

I right-click, Properties on my current user I'm logged in as, and gave server role sysadmin and user mapping selected Master database. Still cannot work. What is wrong?

[pvksmaheeth]

at 0:39 while connecting to server it is showing error

[kein_bock]

my god what a bloated trash software, and errors everywhere.
mysql is 2^64 times better.