YTread Logo
YTread Logo

Connect SQL Server with Visual Studio 2019

Connect SQL Server with Visual Studio 2019
I guess in this video I'm going to discuss about how to

connect

to Microsoft ESCO

server

with

Visual

Studio

2019

so first I'm going to show you aren't you owe that to a school

server

I'm using Frank I am using SQL

Server

2014 so you can use any SQL

Server

so let's click there Microsoft SQL

Server

2014 so this is the Microsoft SQL

Server

2014 management is to do so Antje you kid dos several times per database in

server

that database engine

server

name this is the

server

name idea authentication so there are two based to be canned RTO or to the authentication first is windows authentication next is is go

server

authentication so they are two lists of authentication windows and SQL

Server

authentication so first I'm going to so you want the to

connect

to Microsoft SQL

Server

with

Visual

Studio

2019

with Windows authentication so let's click on

connect

for its loading all the component now here after click on data is so there are tool or user defined or and I we can say or use a kitten so first is Adam and list is maximum so this all for system defined database so inside - OH inside - next no they all do any tables so and you're going to us right - Adam didymus so just to right-click so that I'm going to kill tap on new table so going to click on new clearly and you're going to write the one suppressed you so our turnkey rental or going to learn to carry to gate once they impressed her day one so gay devil so there are no any EMP or table...
connect sql server with visual studio 2019
idea so going to give the devil an EMP now here or give low iodine so they should be interval time and next is name so names would be bad cat now here after close by Brad can't execute that so come on completed successfully so yeah after let's replace the item database and could you terror so there you can find - EMP table it circulated no he knocked a LED saw or go to the start now here going to open or

Visual

Studio

2019

failure so these it is to do even know here after let's go continue without code and here you get this console yeah so here up to oh let's go to or tools tab so inside to to stab you can find tag to database click on tag to rid of us so anti-vehicle different option or data source the Microsoft Access hereafter you can this is all description Microsoft or deceived all description resolver evolved description and here Microsoft is resolver database file and here Oracle you can

connect

Oracle with yeah and here this is about other so going to

connect

with the Microsoft SQL

Server

to

Visual

Studio

2019

so you have to select this option so if I place on continuous idea and getting some here masters some masters not error message so it so install missing packets through some packets it's missing so I'm going to install if you give to this kind of message do you need to install some packets at you let's click on ok so click on OK now here also continue so adhere the package is a start of a starting operation download finished off...
connect sql server with visual studio 2019
almost done now here octo again we solicited it's often no here after again let's go to tools tab and here click on

connect

to database and yeah microsoft SQL

server

click on continue so out here if you want then here you can if you want to go back here you can't click on change so you just go back yeah well let's click on ok so this is the result microsoft SQL

server

client and you have to let's so see the

server

name so click on the down arrow so it's so retraining of list of

server

so they are two

server

are tied to the tree so this is yeah so I don't if you need to check the correct

server

so let's go to our do is

connect

micro esker

server

so these things were good that I'm using so ms SQL

server

for now you can also copy that one and you can paste keratea by right-click directly or you can click on arrow so this is the

server

that I'm using Microsoft SQL

Server

one the inside you give to degenerative is so I created one same place to a table on a database circuit is there actually Adam no here after let's click on

connect

and you know this is the atom aren't you trying to use in the devil so here Windows authentication now click on advanced so this is the all advanced here so it will describe everything not click on ok taste

connect

ion

connect

ion and succeeded don't click on ok so CRT oh it's so or dead stop t3 my ms SQL

server

one it's come here with Adam database so it will create go there if you click there...
connect sql server with visual studio 2019
you get the table views stored procedure now all all there so this is all our tables inside Adam reader is so that means so although or Microsoft SQL tables views everything it's come here in

Visual

Studio

2019

that means so or Microsoft SQL

Server

with the

visual

studio

or

connect

ed successfully now you can use this all tables according to those that requirement so let us click on a empty who's the idea autoloading designed surfaces the design circuits is loading so this is the query that I didn't in Microsoft SQL

Server

no it's gone inside

Visual

Studio

so earlier this is the are created ID and name and a digital editor are given in design back so that means by using windows authentication what is go

server

successfully

connect

ed with

Visual

Studio

2019

now the author let's go back and oh here dis

connect

connect

so this term I I used at her windows now distant going to use echo

server

so I'd you're going to use the log in SA and let's keep the password so you can give login with any so here I just login with sa now this time going to use Mac's you know or database and going to create one new table so let's copy Darth wound and going to select maximum so going to get the table EMP inside maximum so come on computed successfully know they're after or let's will cancel that to not require tactics now again go to the tools tab they all

connect

to database aren't you going to search the

server

name so

server

name and this SQL...

Server

one you wanna check they just increase that case both Giardia or is the

server

name MSN split

server

for so it's a logging it sa user no hereafter or this is the user so this template to use Tesco

server

authentication give the username SA and the table password and your Center database so this time going to select back to monetarist now here are two right ones so you can see all the advanced right here so this is 30 nights when ASTM maxima user ID l swing so you see you can also see the password it's come clear five digit password now click on or can taste the

connect

ion exceeded click on ok now here alter will see idea or this term or idea miss SQL can't read with maximum three degrees so this is the next one it's a happier now hereafter so they are only one tables that I created just be empty so this 31 that I just created so you wanna check the read our table insert max no database so CRE only EMP did our table is there so here I am Petera now I will click on empty so this they give you that I created on maximum data rest so if though these things are out here they are terrible deals everything it's all or it's coming out here that means by using Oh s cuz our authentication word we

connect

ed microsoft SQL

server

toxicity with

Visual

Studio

2019

so this third tool means we can

connect

so I hope this route is helpful for you so now in this video it's over so thanks for watching steam expert thank you