I needed to come up to speed on SQL Server very quickly and found your tutorial extremely helpful. Thanks for sharing and it was the perfect set of beginning information.
Very well articulated. Thank you for keeping your listeners' comprehension in mind. I was able to follow everything you did. Thank you very much. I'm looking forward to my database management class this next semester!
@fdzjuba can you or someone help me please? once i change the path to c:\sqldata and the other to c:\sqllog @15:53 and hit I okay, i get the error message - Created failed for Database 'newdatabase'. An exception occured while executing a Transact-SQL statement or batch Directroy lookup for the file "c:\sqldatabase ewdatabase.mdf" failed with the operating system error 2(the systek cannot find the file specified.). CREATE DATABASEE failed. Some file names listed could not be created. Check related errorrs. (Microsoft SQL Server, Error:5133) Please help! I couldnt find any solutions online!!
If You are having a hard time with the low volume, I suggest you download a Volume Booster extension for Chrome or any other browser you are using . It will help with any video you are having trouble with. Below are a few options to check out from the Chrome store. chrome.google.com/webstore/detail/volume-master/jghecgabfgfdldnmbfkhmffcabddioke chrome.google.com/webstore/search/volume%20booster?_category=extensions Hope this helps.
Hi, I am using sqlserver 2014 managmnt studio.I am unable to create a database and edit the path.It doesn't allow me to change the path column while creating.unable to find file error pops up.any reason
nice video.. i just hoping everytime you write the code.. or do something with it, please zoom it.. i cant see the code you're typing or the one you're right/left clicking.. sorry for my bad grammar btw, still its a nice tutorial video.
you illustration is beyond excellent. But I do have a question though. During the login creation of superadmin, it gets created successful, but when i open a new SSMS, it refuses to connect. In the additional information, it says the login was successful, but there was no pipe. I couldnt understand the message. Same issue came up when I created the user_changeman. Same message was displayed. please give me advise, how can i fix this issue? Best regards and your illustration is exceptionally amazing. Thanks a lot.
Hi, very helpful tutorial.But I have a problem - "Cannot connect to .\SQLEXPRESS.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233". This happens when I start the program and try to log in with superadmin or user_changeman. I did the same thing as You and I downloaded and installed Sql server and MSQLMS as I watched the video so I dont know what is the problem.Any help?
Hi, Your presentation is very good..clear and understandable. I downloaded SQL Server Express 2014. Connected as Windows Authentication. Then Setup the superadmin login etc . per your instruction. Then when I ran another instance of the Manament Studio and tried to connect to it using the Sql Server Authentication and the superadmin login I created, it is giving me this error - "A connection was successfully established with the server, but then an error occurred during the login process(provider:shared Memory provider, error 0 - No process is on the other end of the pipe.) (Microsoft SQL Server Error: 233). No process is the other end of the pipe" Please help..!
I fixed this by going into SQL Server Configuration Manager and enabling the Named Pipes and TCP/IP protocols. Then I restarted the SQL Server service, reopened SQL Server Management studio, refreshed the server (right click the server in the left-hand menu and click "refresh"), and I was able to login. Also, go to the Server properties and select "SQL Server and Windows Authentication mode" under Security (this alone usually fixes the problem, but if not follow the steps above). I hope that helps anyone having the same problem.
Hello, videos are very helpful thanks. I have a question regarding access, I attempted to create a database and I received an error - states " denies permission to create database error code 262.
Good content and very helpful; however, the sound quality (aside from the cougher) was marginal at best. I had a hard time following the conversation b/c every time you turned your head the volume and clarity of your voice diminished. I had to rewind and re-watch several segments multiple times. Suggest using a dedicated microphone for better sound quality which would also minimize the interruptions from audience noise.
When I try to connect using the superadmin account, it tells me this: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)" Any ideas on what I may be doing wrong?
What nonsense is this??? Cursing another innocent human for a cough he cannot help and wishing he will "die" already??? People please be careful, don't just think you say can say anything on the internet against people...it might just return back upon you, if the person you're cursing is innocent :(
Thanks for sharing, I had issues with creating a superuser with failed to logon but I had to restart the sql server(mssqlserver service) which fixed the login problem
If only he would quit hitting the table.... Can't even make it to the dude coughing because the banging is driving me nutso. Oh well. I bet it was a good lesson.
İsa Mesih Yolunda's point is that it is very distracting when trying to learn. We miss things due to the coughing. I repeated it 3 times and still couldn't infer what was said.
You want someone to "kick that coughing guy" And you have a picture of Jesus as your avatar??? Please remove it, you're not worth having the picture, you're wicked with no compassion, a fake Christian, repent.
I needed to come up to speed on SQL Server very quickly and found your tutorial extremely helpful. Thanks for sharing and it was the perfect set of beginning information.
Thanks for this,the first subject in my network security course will be SQL,it will be nice to know this stuff before I even get to school.
Very well articulated. Thank you for keeping your listeners' comprehension in mind. I was able to follow everything you did. Thank you very much. I'm looking forward to my database management class this next semester!
i guess I'm kinda randomly asking but does anybody know of a good website to watch new movies online?
this video is great besides the sound quality
Very helpful and clear explanations
Very very good, thank you. Keep up the good work.
Thanks sir for your great help.
it was a nice video
Nice tutorial
that's very wonderful
Good presentation dude...
Nice Tutorial!
@fdzjuba can you or someone help me please? once i change the path to c:\sqldata and the other to c:\sqllog @15:53 and hit I okay, i get the error message -
Created failed for Database 'newdatabase'.
An exception occured while executing a Transact-SQL statement or batch
Directroy lookup for the file "c:\sqldatabase
ewdatabase.mdf" failed with the operating system error 2(the systek cannot find the file specified.).
CREATE DATABASEE failed. Some file names listed could not be created. Check related errorrs. (Microsoft SQL Server, Error:5133)
Please help! I couldnt find any solutions online!!
Closed captions would be VERY helpful!
How is the coughing guy closer to the microphone than the speaker?
If You are having a hard time with the low volume, I suggest you download a Volume Booster extension for Chrome or any other browser you are using .
It will help with any video you are having trouble with.
Below are a few options to check out from the Chrome store.
chrome.google.com/webstore/detail/volume-master/jghecgabfgfdldnmbfkhmffcabddioke
chrome.google.com/webstore/search/volume%20booster?_category=extensions
Hope this helps.
thanks it helped.
Are you going to post on indexing or any other SQL tutorial?
when you click download on the windows page, which file should you download to install? theres like 20 in the list
I just installed the Server Management Studio my question is how to create a server to play around on. Thanks in advanced.
Hi,
I am using sqlserver 2014 managmnt studio.I am unable to create a database and edit the path.It doesn't allow me to change the path column while creating.unable to find file error pops up.any reason
nice video.. i just hoping everytime you write the code.. or do something with it, please zoom it.. i cant see the code you're typing or the one you're right/left clicking.. sorry for my bad grammar btw, still its a nice tutorial video.
you illustration is beyond excellent. But I do have a question though. During the login creation of superadmin, it gets created successful, but when i open a new SSMS, it refuses to connect. In the additional information, it says the login was successful, but there was no pipe. I couldnt understand the message. Same issue came up when I created the user_changeman. Same message was displayed.
please give me advise, how can i fix this issue?
Best regards and your illustration is exceptionally amazing.
Thanks a lot.
Hi, very helpful tutorial.But I have a problem -
"Cannot connect to .\SQLEXPRESS.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233".
This happens when I start the program and try to log in with superadmin or user_changeman. I did the same thing as You and I downloaded and installed Sql server and MSQLMS as I watched the video so I dont know what is the problem.Any help?
отличные видео! спасибо. случайно нет этих лекций по sql или что то подобного в тексте?
Hi,
Your presentation is very good..clear and understandable.
I downloaded SQL Server Express 2014. Connected as Windows Authentication. Then Setup the superadmin login etc . per your instruction. Then when I ran another instance of the Manament Studio and tried to connect to it using the Sql Server Authentication and the superadmin login I created, it is giving me this error -
"A connection was successfully established with the server, but then an error occurred during the login process(provider:shared Memory provider, error 0 - No process is on the other end of the pipe.) (Microsoft SQL Server Error: 233).
No process is the other end of the pipe"
Please help..!
Try to set Server authentication to "SQL Server and Windows Authentication Mode" , this setting can be found under Server properties->Security
I fixed this by going into SQL Server Configuration Manager and enabling the Named Pipes and TCP/IP protocols. Then I restarted the SQL Server service, reopened SQL Server Management studio, refreshed the server (right click the server in the left-hand menu and click "refresh"), and I was able to login.
Also, go to the Server properties and select "SQL Server and Windows Authentication mode" under Security (this alone usually fixes the problem, but if not follow the steps above). I hope that helps anyone having the same problem.
Hello, videos are very helpful thanks. I have a question regarding access, I attempted to create a database and I received an error - states " denies permission to create database error code 262.
Good content and very helpful; however, the sound quality (aside from the cougher) was marginal at best. I had a hard time following the conversation b/c every time you turned your head the volume and clarity of your voice diminished. I had to rewind and re-watch several segments multiple times. Suggest using a dedicated microphone for better sound quality which would also minimize the interruptions from audience noise.
When I try to connect using the superadmin account, it tells me this: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)"
Any ideas on what I may be doing wrong?
Nevermind, I was using the wrong server. The SQLExpress one needs to be the one you use.
Sql server hardware is this the same as your video.
29:52
These are super helpful! Thanks for posting. But curse that student with the cough sitting next the microphone. He keeps hurting my ears.
yeah agreed. coughing guy needs to move away from the microphone or attend remotely.
Haha, yeah. Wait, no. That seems a bit much....
What nonsense is this??? Cursing another innocent human for a cough he cannot help and wishing he will "die" already??? People please be careful, don't just think you say can say anything on the internet against people...it might just return back upon you, if the person you're cursing is innocent :(
He doesn't even cough so frequently. Poor guy is most likely trying to hold it in.
Great job but for the sound ish. I tried to be attentive as possible but it didn't come close.
Thanks for sharing, I had issues with creating a superuser with failed to logon but I had to restart the sql server(mssqlserver service) which fixed the login problem
when i want to connect to server it has error 161
What is the name of this guy who is in the video?
pls include a cc
If only he would quit hitting the table.... Can't even make it to the dude coughing because the banging is driving me nutso. Oh well. I bet it was a good lesson.
Who is the author? Is he russian?
can you just kick that coughing guy?
not cool jesus :|
why? maybe boy is ill...like you never had a cough..
İsa Mesih Yolunda's point is that it is very distracting when trying to learn. We miss things due to the coughing. I repeated it 3 times and still couldn't infer what was said.
booo!!!
You want someone to "kick that coughing guy" And you have a picture of Jesus as your avatar??? Please remove it, you're not worth having the picture, you're wicked with no compassion, a fake Christian, repent.
Hi can't anyboady help me on Skype with this please.
coughing men ... thats annoying
???
Video is great; sound quality worse, Tutor is worst