Hello Programmers, here is the article to connect SQL server with visual studio. Microsoft visual studio has nice facility where you can easily connect any database with visual studio. this article i am using SQL Server 2019 and Visual Studio 2019.
Let’s see the all important steps to connect VS with ssms.
1.Click “Tools” Tab and next Click “Connect to Database”.See below image.
2.Choose “Microsoft SQL Server” from Data source and click “Continue” button. see below image.
3.Give Microsoft SQL Server name,you can select Windows Authentication or you can give SQL Server Authentication.Enter User name and Password. Select or enter a database name from drop down box. Click “Test Connection” button. if connection succeeded then click OK. Follow below image.
4.After Clicking OK button,you can see SQL Server successfully connected with Visual Studio.you can see in below image. now you can use the connection in Any Code.
Happy Connection… Thanks.