Difference Between Admin Login and User Login | MSSQL Training

** For Online Training Registration: goo.gl/r6kJbB ? Call: [phone]
💡 Visit Our Website for Classroom Training:
nareshit.in/sql-server-training/
💡 For Online Training:
nareshit.com/course/sql-serve...
#sqlserver #server #programming #course #Tutorials #Training #Videos
--------------------------
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [e-mail]/ 📧 [e-mail] or Call us at the USA: ☎[phone] or India: ☎ [phone]
--------------------------
💡 Check The Below Links
► For Course Reg: goo.gl/r6kJbB
► Subscribe to Our Channel: goo.gl/q9ozyG
► Circle us on G+: plus.google.com/+NareshIT
► Like us on Facebook: / nareshit
► Follow us on Twitter: / nareshitek
► Follow us on Linkedin: goo.gl/CRBZ5F
► Follow us on Instagram: goo.gl/3UXYK3

[@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.

[@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.

[@programmeseekho2795]

Thank You Sir Very helpful Video..Very Nice Sir

[@joyitasadhukhan1704]

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

[@roshinihowdekar2669]

Really great explanation sir, Thank you

[@jaggu6409]

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

[@lakshminagesh2672]

excellent teaching

[@dineshgopalsetty2047]

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

[@zahooriqbalkarimi7972]

Amazing explanation sir!!

[@RocketShip-sy3lm]

This guy is my hero

[@premprakashnayak2636]

Great learning experience

[@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...

[@technicalganga2404]

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

[@AD-ng4mz]

Thank you Sir.

[@bhukyapavan6652]

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

[@somensingh1817]

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

[@zakaria1756]

you are the best ,huts off

[@abhi-ly8cn]

👍💯 best explain

[@ramyapuvvadi8879]

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

[@vikassomvanshi1848]

nice teaching sir...

[@Uzair_Anwar2299]

how a user can get access to the databases??

[@commandcenter1449]

Thanks a lot teacher

[@rockingrakesh8197]

Ur a hero bro

[@harishkmr6395]

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

[@harshar505]

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

[@Shahana_kt]

How to downld sql application Anyone one pls help me

[@sravankumar1767]

good explanation

[@user-fi9ht4wb2q]

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

[@SachinGupta-dh1cf]

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

[@ksreenivasulureddy6666]

How user get permission from admin?

[@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

[@pavansake1805]

sir please send the SQL server link sir

[@rajeshsarella862]

Good

[@jitendrakesarwani8462]

Which sql server is good for Windows 7 practice

[@aviralyadav7373]

jitendra Kesarwani ms sql server

[@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.