Difference Between Admin Login and User Login | MSSQL Training

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@praveencoder3244]

In all the youtube channel I went through no one explained in detail abt the basic concepts. you are just amazing.

[@vocabularymillionaire]

You made this as foolproof as possible. Super easy to comprehend 👌

[@roopalityagi3958]

You are providing best online video on sql server. Best part is you zoom in the screen everytime to explain better. Apart from screen you also explain on board by making diagrams . This makes your video far better then others

[@Viveksharma-px4ku]

Thank you Sir!! You are awesome.

[@rockingrakesh8197]

Ur a hero bro

[@RocketShip-sy3lm]

This guy is my hero

[@dineshgopalsetty2047]

Followed the same to create login but couldn't able to connect server with that login details

[@roshinihowdekar2669]

Really great explanation sir, Thank you

[@lakshminagesh2672]

excellent teaching

[@zahooriqbalkarimi7972]

Amazing explanation sir!!

[@harshar505]

teaching awesome hats off to you sir but how dataadmin will give permission to user???????

[@SachinGupta-dh1cf]

What a explanation...... Solid.. Sir...

[@programmeseekho2795]

Thank You Sir Very helpful Video..Very Nice Sir

[@premprakashnayak2636]

Great learning experience

[@omeswariEC-22]

Really gud explanation, but pls provide link for installing sql server software

[@abhi-ly8cn]

👍💯 best explain

[@zakaria1756]

you are the best ,huts off

[@reanwithkimleng]

Hello sir, when we use CUI , GUI to create user Login faster? Why password was created by GUI is expired?

[@vikassomvanshi1848]

nice teaching sir...

[@ramyapuvvadi8879]

Sql server authentiction mode lo by default login name ravdam ledu sir

[@commandcenter1449]

Thanks a lot teacher

[@technicalganga2404]

a network related or instance specific error occurred while establishing a connection to sql server

[@jaggu_007i]

sir which is good . sql express version or sql developer version may i know what are you using?

[@harishkmr6395]

Hello Team.. video explanation was good. How to creat new user account through query with windows authentication login?

[@joyitasadhukhan1704]

sir, is .net required for installation? in new version it is showing something about .net. can you please clear my doubt?

[@sravankumar1767]

good explanation

[@internationelworld1510]

but...which user name is best for work purpose. I mean with Query or without Query CREATING ..but. .why did given two options for user ID creating...

[@Uzair_Anwar2299]

how a user can get access to the databases??

[@somensingh1817]

Where u shown ...no video of install ation..etc? Useless video.. yelling incomplete information

[@pavansake1805]

sir please send the SQL server link sir

[@jitendrakesarwani8462]

Which sql server is good for Windows 7 practice

[@aviralyadav7373]

jitendra Kesarwani ms sql server

[@ksreenivasulureddy6666]

How user get permission from admin?

[@AD-ng4mz]

Thank you Sir.

[@bhukyapavan6652]

sir my sql server authentication is not connecting can you please help me out...

[@Priyanka-zb7le]

username is not coming automatically and when i wrote username & password to comes some error like a "login fail to user(microsoft sql server ,Error:18456)".please give me solution that what i should do

[@Imran_Imu]

You might have chosen default option for authorization at the time of installation, try below steps Within the Microsoft SQL Server Management Studio in the object explorer: 1. Right click on the server and click Properties 2. Go to the Security page 3. Under Server authentication choose the SQL Server and Windows Authentication mode radio button 4. Click OK 5. Restart SQL Services

[@premprakashnayak2636]

More videos about sql DBA

[@Shahana_kt]

How to downld sql application Anyone one pls help me

[@rajeshsarella862]

Good

[@shanusulabh1771]

When i am trying to open user window by proving username and password in sql authentication mode, i am getting an error of can't connect to server and also giving an additional information that a connection was successfully established with the server, but then an error occurred during the login process. What is this error i am not understanding, please help me sir or any one in resolving this problem ?

[@sailajayrgudipati468]

Hi, check this one out , if you are still looking for a issue fix-kzbin.info/www/bejne/nmOXhGuujahsaqM

[@ravikiranreddysuravarapu2192]

I want notification when the upcomming Sql Server videos are uploaded

[@vijayanks1714]

🙋‍♂️

[@jayanthbalina5078]

I created user login keeping server name as my machine name user name and password are Jayanth and 123 but getting error I used syntax like this create login Jayanth with password='123' @naresh i Technologies can u please explain

[@cococnk388]

Did you specify the database on which the user is going to connect? Connect first to the data base engine as an administrator, write the following query below in a query editor: Use master (or any database you've created) CREATE LOGIN Jayanth WITH PASSWORD = "123" CREATE USER Jayanth FROM LOGIN Jayanth Clic on Connexion (SSMS), the rectangular box will show up, choose SQL SERVER AUTHENTIFICATION enter Jayanth as USERNAME and 123 as password The new user will now have access to the database USER. Hope it helps.

[@cococnk388]

you can later give the user all or some privileges to the tables in the database... we do have the following commands: grant (to give), deny (to refuse ) and revoke ( to remove). Hope it helps.