In this article, we will learn about how to get the Connection String from SQL Server using Visual Studio.
Firstly open your project with Visual Studio in which you want to use your Connection String.
Now, Click on View menu -> Server Explorer to access a database server either use Ctrl+Alt+S.
Now, right-click on Data Connections -> Add Connection.
Now simply choose (or enter) the server name, enter server authentication details (if required), choose the database name, and click Test Connection then click OK.
The connection will be entered into the Server Explorer window. Now, choose and right-click on Connection -> Properties (F4 or Alt+Enter) then copy connection string from Properties window -> Connection -> Connection String.
Now, open Web.config file from Solution Explorer window and then paste connection string as shown below.
<connectionStrings> <add name="myConnectionString" connectionString="Data Source=DESKTOP-78L7I55;Initial Catalog=Student;User ID=sa;Password=***********" /> </connectionStrings>
Here, we must have to change the password attribute (‘***********’) with our server password.
Also, check How To Create User In SQL