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
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
In all the youtube channel I went through no one explained in detail abt the basic concepts. you are just amazing.
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
This guy is my hero
Thank you Sir!!
You are awesome.
Very good
Ur a hero bro
Where u shown ...no video of install ation..etc?
Useless video.. yelling incomplete information
Followed the same to create login but couldn't able to connect server with that login details
Really great explanation sir, Thank you
excellent teaching
Thank You Sir
Very helpful Video..Very Nice Sir
Really gud explanation, but pls provide link for installing sql server software
Amazing explanation sir!!
Great learning experience
teaching awesome hats off to you sir but how dataadmin will give permission to user???????
a network related or instance specific error occurred while establishing a connection to sql server
What a explanation...... Solid.. Sir...
Thanks a lot teacher
nice teaching sir...
Sql server authentiction mode lo by default login name ravdam ledu sir
👍💯 best explain
you are the best ,huts off
good explanation
Hello Team..
video explanation was good.
How to creat new user account through query with windows authentication login?
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 ?
Hi, check this one out , if you are still looking for a issue fix-ruclips.net/video/h24S8xXC94A/видео.html
Hello sir, when we use CUI , GUI to create user Login faster? Why password was created by GUI is expired?
Thank you Sir.
sir which is good . sql express version or sql developer version may i know what are you using?
Good
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...
How user get permission from admin?
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
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
More videos about sql DBA
sir, is .net required for installation? in new version it is showing something about .net. can you please clear my doubt?
how a user can get access to the databases??
sir my sql server authentication is not connecting can you please help me out...
sir please send the SQL server link sir
How to downld sql application
Anyone one pls help me
Which sql server is good for Windows 7 practice
jitendra Kesarwani ms sql server
I want notification when the upcomming Sql Server videos are uploaded
🙋♂️
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
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.
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.