Difference Between Admin Login and User Login | MSSQL Training

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024
  • ** For Online Training Registration: goo.gl/r6kJbB ? Call: +91-8179191999
    💡 Visit Our Website for Classroom Training:
    nareshit.in/sq...
    💡 For Online Training:
    nareshit.com/c...
    #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
    📧 us.training@nareshit.com/ 📧 online@nareshit.com or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
    --------------------------
    💡 Check The Below Links
    ► For Course Reg: goo.gl/r6kJbB
    ► Subscribe to Our Channel: goo.gl/q9ozyG
    ► Circle us on G+: plus.google.co...
    ► Like us on Facebook: / nareshit
    ► Follow us on Twitter: / nareshitek
    ► Follow us on Linkedin: goo.gl/CRBZ5F
    ► Follow us on Instagram: goo.gl/3UXYK3

Комментарии • 48

  • @NareshIT
    @NareshIT  5 лет назад +2

    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
    @praveencoder3244 Год назад +2

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

  • @roopalityagi3958
    @roopalityagi3958 5 лет назад +2

    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

  • @RocketShip-sy3lm
    @RocketShip-sy3lm 2 месяца назад

    This guy is my hero

  • @Viveksharma-px4ku
    @Viveksharma-px4ku 4 года назад +4

    Thank you Sir!!
    You are awesome.

  • @chandrashekharsubbaraosumu
    @chandrashekharsubbaraosumu 18 часов назад

    Very good

  • @rockingrakesh8197
    @rockingrakesh8197 Год назад +1

    Ur a hero bro

  • @somensingh1817
    @somensingh1817 2 года назад +1

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

  • @dineshgopalsetty2047
    @dineshgopalsetty2047 3 года назад +2

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

  • @roshinihowdekar2669
    @roshinihowdekar2669 2 года назад

    Really great explanation sir, Thank you

  • @lakshminagesh2672
    @lakshminagesh2672 7 лет назад +1

    excellent teaching

  • @programmeseekho2795
    @programmeseekho2795 6 лет назад

    Thank You Sir
    Very helpful Video..Very Nice Sir

  • @user-fi9ht4wb2q
    @user-fi9ht4wb2q 7 месяцев назад

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

  • @zahooriqbalkarimi7972
    @zahooriqbalkarimi7972 2 года назад

    Amazing explanation sir!!

  • @premprakashnayak2636
    @premprakashnayak2636 3 года назад

    Great learning experience

  • @harshar505
    @harshar505 3 года назад +1

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

  • @technicalganga2404
    @technicalganga2404 4 года назад +1

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

  • @SachinGupta-dh1cf
    @SachinGupta-dh1cf 3 года назад +1

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

  • @commandcenter1449
    @commandcenter1449 2 года назад

    Thanks a lot teacher

  • @vikassomvanshi1848
    @vikassomvanshi1848 3 года назад

    nice teaching sir...

  • @ramyapuvvadi8879
    @ramyapuvvadi8879 3 года назад +1

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

  • @abhi-ly8cn
    @abhi-ly8cn 4 года назад

    👍💯 best explain

  • @zakaria1756
    @zakaria1756 4 года назад

    you are the best ,huts off

  • @sravankumar1767
    @sravankumar1767 4 года назад

    good explanation

  • @harishkmr6395
    @harishkmr6395 3 года назад

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

  • @shanusulabh1771
    @shanusulabh1771 7 лет назад +4

    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
      @sailajayrgudipati468 6 лет назад

      Hi, check this one out , if you are still looking for a issue fix-ruclips.net/video/h24S8xXC94A/видео.html

  • @reanwithkimleng
    @reanwithkimleng 27 дней назад

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

  • @AD-ng4mz
    @AD-ng4mz 6 лет назад

    Thank you Sir.

  • @jaggu6409
    @jaggu6409 3 года назад

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

  • @rajeshsarella862
    @rajeshsarella862 2 года назад

    Good

  • @internationelworld1510
    @internationelworld1510 2 года назад

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

  • @ksreenivasulureddy6666
    @ksreenivasulureddy6666 4 года назад +1

    How user get permission from admin?

  • @Priyanka-zb7le
    @Priyanka-zb7le 7 лет назад +1

    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
      @Imran_Imu 6 лет назад +3

      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
    @premprakashnayak2636 3 года назад

    More videos about sql DBA

  • @joyitasadhukhan1704
    @joyitasadhukhan1704 3 года назад

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

  • @Uzair_Anwar2299
    @Uzair_Anwar2299 4 года назад

    how a user can get access to the databases??

  • @bhukyapavan6652
    @bhukyapavan6652 5 лет назад

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

  • @pavansake1805
    @pavansake1805 Год назад

    sir please send the SQL server link sir

  • @Shahana_kt
    @Shahana_kt 4 года назад

    How to downld sql application
    Anyone one pls help me

  • @jitendrakesarwani8462
    @jitendrakesarwani8462 6 лет назад

    Which sql server is good for Windows 7 practice

  • @ravikiranreddysuravarapu2192
    @ravikiranreddysuravarapu2192 8 лет назад

    I want notification when the upcomming Sql Server videos are uploaded

  • @vijayanks1714
    @vijayanks1714 4 года назад

    🙋‍♂️

  • @jayanthbalina5078
    @jayanthbalina5078 3 года назад

    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
      @cococnk388 2 года назад

      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
      @cococnk388 2 года назад

      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.