Sql Server

 

  1. Selected Provider - Choose the database provider from the dropdown menu. In this case, it's going to be SqlServer.
  2. Sql Server - Indicate the use of SQL Server as the selected provider with the connection to (localdb)\MSSQLLocalDB.
  3. Database - Specify the name of the target database.
  4. Refresh Servers - Update the list of available servers.
  5. Enumerate Database(s) - This Fetch and displays a list of databases.
  6. Windows Authentication - This Authenticates using Windows credentials.
  7. Sql Server Authentication - Option for SQL Server credentials.
  8. User - Enter the username for SQL Server authentication.
  9. Password - Input the password associated with the SQL Server user.
  10. Use Trusted Server Certificate - If your SQL Server uses SSL, ensure that it is correctly configured with a valid SSL certificate.  You may need to set this to true by checking the box.
  11. Connection String - Provide the connection string to establish a link to the database.
  12. Test Connection/Connected - Verify or establish a connection by testing it.
  13. Tables - Explore the tables within the connected SQL Server database.

 

 


Was this article helpful?