How to add Connection Profile for SQL IN VS CODE?

Ansh Aggarwal 0
Viewed 36

I have installed all the extensions required for SQL to run in VS code, but I'm not able to add the connection profile for SQL.

Can somebody please help me in adding that connection profile?

sql visual-studio-code
1 Answers

Maybe this can help you, add this code to your appsettings.json

"ConnectionStrings": { "DefaultConnection": "Data Source=localhost;Initial Catalog=<your database name>;Connect Timeout=30;Integrated Security=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" }

If you don't use localhost

"ConnectionStrings": { "DefaultConnection": "Data Source=<your servername>;Initial Catalog=<your database name;User ID=<your auth username>;Password=<your auth password>;Connect Timeout=30;Integrated Security=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" }

hlyza180
Related