Connecting to SQL Server using SSMS – Part 1
Video Title: Connecting to SQL Server using SSMS – Part 1
Hello welcome to presume technologies I am venket this is part 1 of sequel server in this session we’ll understand how to connect to sequel server using sequel server management studio what is sequence of a management studio and the different authentication methods that can be used to connect a sequel
Server now you need to have sequence of a management studio already installed on your machine if not there are several articles on the web which can help us how to do that so once you have sequel server management studio installed on your machine to open that go to the
Start menu select all programs and depending on the version of the sequel server that you have installed you should see a respect to your folder here for example if you have installed sequence over 2005 you should see a folder for that here Microsoft sequence over 2005 on my machine I have Microsoft
Signals over 2008 so I see a folder for that expand that and within that folder you should see sequel server management studio now select that once you select sequel Server management studio you should see a connect to server window coming up and this is the place where we
Specify the information that is required for sequel server management studio to connect to a sequel server database now sequel server management studio and the sequel server database are two different things ok so a database server typically contains all the tables and the data you know any sequence of management objects
That you create for example it could be trigger view tables data related to those tables etc all of that will be stored centrally on that database server and to connect to that database server the client tools that we generally use is sequel server management studio so keep in mind sequel server management
Studio is just a client tool to connect to the database server and it is not the server by itself so in a typical development environment the database server might be installed on one centralized machine and usually developers can connect to that using a sequel server management studio that’s
Installed on their respect to your machine in this example you can see that we have four developers and from each of the developer machine we can use the sequel server management’s to do specify the information about this database cell for example from them from this developer machine one know if I
Have to connect to the sequence of a database okay I need to tell okay this is the server name and user ID password and how do you want to connect from this machine to this what do you want to use Windows authentication or sequel server authentication okay the point to keep in
Mind secret server management studio is just a client tool and not the server by itself and now we will see how to configure sequel server management studio to connect to a database server so if we go back okay so this is the window that we typically see when we
Open up signal server management studio for the first time now the first choice that we have to make is to specify the server type usually it’s the database engine okay but if you are if you want to connect to analysis services or reporting services or integration services which are also respectively
Called as SS es s s RS and SS is SS is means signals of integration services SS Rs main sequence our reporting services and SS a s means analysis services we don’t want to connect to any of them we just want to connect to the database server so that’s why we use the
Database engine here okay in a later module when we talk about sequence of our integration services and reporting services we will see how to connect to those you know databases using the respective options here okay for now its database engine and you also need to specify the server name now if you have
A environment like this in a way you have a database server on a centralized machine then you need to specify the name or IP address of that server okay but here on my machine you know the database server and the sequence of a management studio both are installed on my machine the database
Server is also present on my local machine so if that’s the case then I can specify the IP address of my computer itself you know the local IP address which is one to seven dots 0.1 this is also called as loopback IP address here from a networking
Background so to refer to the local machine I can use the loopback IP address which is 127.0.0.1 or I can also just say dot so dot specifies that I want to connect to the local server or I can specify local keyword here so any of these will tell the sequel server
Management studio we want to find an installation of sequel server database on the local machine and not over the network so you can either use local dot or an IP address 127.0.0.1 so you can use any of these ok so once we have the server name specified then the important
Decision that we have to make is how do we want to connect to the database server do we want to use Windows authentication or sequel server authentication now the options available here for you to connect depends on how you have configured the sequel server during installation when we were
Installing when we were when when we are installing sequel server basically it provides us with two options for authenticating against that installation of sequel server you know those two options are makes the more authentication or sequel server authentication so if you choose mixed-mode authentication then it means
Both of these options will be available for you to connect to the sequel server if you have just chosen sequel server authentication then you cannot use windows authentication so the options available here for you to connect to the sequel server are basically dependent on how you have installed the sequel server
Okay for now let’s choose sequel server authentication okay if you choose windows authentication then you don’t have to provide any of the username or password ok that’s because I mean windows authentication basically uses the windows login that you have used to log into this computer so you have already authenticated yourself to log
Into this computer so basically that username and password the Bender’s username password will be used to validate you against this database on the other hand you can also use sequel server authentication so when you use sequel server authentication when you are installing sequel server again you would
Have specified what is the username and password that you want to use to connect to this installation of sequel server so you specify that username and password typically we specify that as s a system administrator and a password for that okay so we have to provide that username
And password so let’s provide that username and password and then I can click connect so now when I click connect it should connect to a a and installation of sequel server that’s locally installed on that machine and once that’s done look at this it’s it it has connected to the local sequel server
On this machine and then I can basically see all the databases ok and the security related stuff now this window on the left-hand side is called the object Explorer window ok where you can see the database objects you can explore through those database objects that’s why it’s basically called as object
Explorer now if I have to write a query then I need a space to do that and the first thing you have to do is click on this new query button at the top left-hand corner that should bring you up a new query editor window where basically we can
Type and execute queries ok but again to type and execute queries we need a database so what’s the database a database is a collection of tables and all your database objects ok we will see in the next session how to create a database and we will start writing
Queries ok now so this is your object Explorer this is your query editor window and if I just hover my mouse over there it shows me I am connected to the local machine and then there you see something called dot master that’s nothing but the database context that we
Are currently in so here you can switch the database you know against which you want to write a query now you might be wondering how did I get all these databases here for example system databases if I expand that I have master model M s DB tmdb
So what are these as the name suggests these are system databases and how did they get in here when I installed sequel server they automatically got installed and these are required for the functionality of the sequel server ok and we can also create user-defined databases you know by just right
Clicking on that and selecting new database which we’ll be doing in the next session ok basically this session is all about how to connect to sequel server and the point that we have to keep in mind is that sequel server management studio is not a server by
Itself as many people get confused by that it is just a client tool to connect to the sequel server on this slide you can find resources for asp.net and C shape interview questions that’s it for today thank you for listening have a great day
Video Keywords: *, SQL Server Management Studio,t-sql fundamentals,t sql basics,sql server from scratch,learn sql queries,learn sql step by step,learn sql programming,learn sql for beginners,learn sql at home,learn everything about sql,sql server free training,sql server crash course,sql training for beginners,sql training online,sql training for beginners youtube
-
Sale!
Wireless WIFI Repeater Extender Amplifier Booster 300Mbps
$29.99$14.99 Add to cartWireless WIFI Repeater Extender Amplifier Booster 300Mbps
Categories: Electronics, Wi-Fi Router, Wireless Wi-Fi Extender Tags: 300Mbps, 802.11N, Amplifier, Booster, Extender, mobile wi-fi booster, Remote, WIFI, Wireless, Wireless WIFI, Wireless WIFI Repeater, Wireless WIFI Repeater Extender, Wireless WIFI Repeater Extender Amplifier, Wireless WIFI Repeater Extender Amplifier Booster, Wireless WIFI Repeater Extender Amplifier Booster 300Mbps$29.99$14.99 -
Sale!
Full RGB Light Design Gaming Headset Headphones with Mic
$24.99$14.99 Add to cartFull RGB Light Design Gaming Headset Headphones with Mic
Categories: Electronics, Gaming, Gaming Headsets Tags: Design, Full, Full RGB Light Design Gaming Headset, Full RGB Light Design Gaming Headset Headphones, Full RGB Light Design Gaming Headset Headphones with Mic, Gamer, Gaming, Gaming Headset Headphones, gaming headset wireless, Headphone, Headphones, Headset, Light, Mic, Package, RGB$24.99$14.99 -
Sale!
Wireless BlueTooth Multi-Device Keyboard Mouse Combo
$39.99$19.99 Add to cartWireless BlueTooth Multi-Device Keyboard Mouse Combo
Categories: Electronics, Gaming, Gaming Keyboards, Keyboard Mouse Combos Tags: Combo, Keyboard, keyboard mouse combos, Mouse, MultiDevice, Set, WireKeyboard Mouse Combo, Wireless, Wireless BlueTooth Keyboard Mouse Combo, Wireless BlueTooth Keyboard Mouse Combos, Wireless BlueTooth Multi-Device Keyboard Mouse Combo, Wireless BlueTooth Multi-Device Keyboard Mouse Combos$39.99$19.99 -
Sale!
High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
$199.99$139.99 Add to cartHigh Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
Categories: Gaming, Gaming Chairs Tags: Adjustable, Chair, computer chairs, Desk, Executive, Gaming, Girl, Headrest, High, High Back Leather Executive Adjustable Swivel Gaming Chair, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar, High Back Leather Executive Adjustable Swivel Gaming Chairs, Leather, Lumbar, Office, Racing, Swivel$199.99$139.99 -
Sale!
Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
$29.99$19.99 Select optionsProfessional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
SKU: N/A Categories: Electronics, Gaming, Gaming Headsets Tags: Cancelling, Gaming, Gaming Headphones with Noise Cancelling Microphone, gaming headset, Headphones, Headset, LED, Light, Mic, Microphone, Noise, Professional, Professional LED Light Wired Gaming Headphones, Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone, Wired, Wired Gaming Headphones, Wired Gaming Headphones with Noise Cancelling Microphone$29.99$19.99 -
Sale!
Gaming Desk with LED Lights USB Power Outlets and Charging Ports
$349.99$249.99 Select optionsGaming Desk with LED Lights USB Power Outlets and Charging Ports
SKU: N/A Categories: Computer Desk, Gaming, Gaming Desk Tags: and Charging Ports, Charging, Desk, Desks, Gaming, gaming desk with led lights, Gaming Desks with LED Lights, Home, LED, Lights, Monitor, Office, Outlets, Port, Power, Room, Stand, USB, USB Power Outlets, White, Workstation$349.99$249.99 -
Sale!
Wired Mixed Backlit Anti-Ghosting Gaming Keyboard
$99.99$79.99 Add to cartWired Mixed Backlit Anti-Ghosting Gaming Keyboard
Categories: Electronics, Gaming, Gaming Keyboards Tags: Antighosting, Backlit, Blue, brown, Gaming, Gaming Keyboard, gaming keyboards, gaming keyboards and mouse, Keyboard, Laptop, Switch, Wired, Wired Mixed Backlit Anti-Ghosting Gaming Keyboard, Wired Mixed Backlit Anti-Ghosting Gaming Keyboards, Wired Mixed Backlit Gaming Keyboard$99.99$79.99 -
Sale!
Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
$119.99$59.99 Add to cartWireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
Categories: Electronics, Gaming, Gaming Headsets Tags: 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, ANC, Audio, Bluetooth, Cancellation, Ear, Earphone, gaming headset, Headphones, Headset, Hi-Res Over the Ear Headphones Headset, HiRes, Noise, Wireless, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Headphones, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headsets$119.99$59.99 -
Sale!
Wired Sports Gaming Headset Earbuds with Microphone
$19.99$9.99 Select optionsWired Sports Gaming Headset Earbuds with Microphone
SKU: N/A Categories: Gaming, Gaming Headsets Tags: Accessories, Earbud, Earphone, Earphones, Gaming, gaming headset with microphone, Headphones, Headset, IOS, Microphone, Sports, Wired, Wired Sports Gaming Headset Earbuds, Wired Sports Gaming Headset Earbuds with Microphone, Wired Sports Headset Earbuds$19.99$9.99 -
Sale!
150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
$49.99$29.99 Add to cart150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
Categories: Charging Stations, Electronics Tags: 150W, 150W Charging Station, 150W Universal Multi USB Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Stations, 150W Universal Multi USB MAX Charging Station, 16 Port MAX Charging Station, 3.5A, Charger, Charging, Fast, laptop charging stations, Max, Multi, Port, Stand, Station, Universal, USB$49.99$29.99
I really like the way you explain it makes everything looks easy 🙂 Many thanks for the excellent explanation!
I want this note book…. Where it is found?
This is masterpiece 🔥🔥🔥 why always one indian
IF YES PLEASE LE ME KNOW
HAVE MADE TUTORIALS FOR ORACLE
I got my first job after learning SQL concepts from here. Thanks a lot . You are a great teacher.
Thank you sir from India
Thanks so much
What has to be filled in login n password?
Sir you re Awesome you make all complex topics very easy by ur videos really thankful
Thank u so much. Good job. Keep it up and go ahead.
Hello, Can we do a partial stats update like 20% or 50% on a table, if yes then please help with command
Sir can u provide notes for sql pls
Hello sir, when i was installing a SSMS i selected authentication type is windows authentication and if i wanted to change to Sql server authentication, will this possible ? will i lose any data if change authentication type ? if i change to sql server authentication will get any additional features ? kindly let me know
Can u drop sql server 2008 installation file link in description of the video
Sir do you provide any certificate sir I helps ne to join In a company sir….
I installed SQL Server 19 while installing it didn't ask me any option to set the password for sa login. And after installation I see sa login is disabled. I change the Server Authentication to SQL Server and Windows Authentication Mode in Security page under properties. Also restarted the SQL Server from object Explorer and also from Services on my Laptop. But still sa login is seen as disabled. Please let me know how to fix this
@Csharp-video-tutorialsBlogspot do you have for power BI?
@kudvenkat do you have on PowerBI?
I saw this video last year I didn't take it seriously until sum1 recommended it to me again. and i figure out that the courses i took were using his video for teaching. now I will have to use this video to help my career too…
Looking forward to learn python from you.
Nice thanks sir …
You are done a wonderful job sir. Keep doing like this…sir
Hi sir , i have doubt how to convert SQL table into json table(if we insert any type of data through it wil convert into json and insert into SQL database table)
Thanku sir for this explanation
Hi sir I am Naveen. I just want to know one thing that I am an undergraduate, I discontinued btech because of some personal issues But I had completed Diploma after Schooling… Can I know that am I eligible for the any job in IT industry after learning SQL??? Please let me know sir… I frequently watch your vedios… Your explanation is really awesome and clearly understandable… Thankq
You are the best teacher in my life… I have seen this video back in 2011-12. I’m proud to say that I’m your ekalavya sishya who promoted your videos since then. Thank you SIR 😊
Hello sir,How to download this SQL server.
Hey I did not understand which login and password details to give as I didnot give any credentials while installing. Could you please help
how do we set a user name and password in case of SQL server authentication?