Sql Server
- Selected Provider - Choose the database provider from the dropdown menu. In this case, it's going to be SqlServer.
- Sql Server - Indicate the use of SQL Server as the selected provider with the connection to
(localdb)\MSSQLLocalDB
. - Database - Specify the name of the target database.
- Refresh Servers - Update the list of available servers.
- Enumerate Database(s) - This Fetch and displays a list of databases.
- Windows Authentication - This Authenticates using Windows credentials.
- Sql Server Authentication - Option for SQL Server credentials.
- User - Enter the username for SQL Server authentication.
- Password - Input the password associated with the SQL Server user.
- 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.
- Connection String - Provide the connection string to establish a link to the database.
- Test Connection/Connected - Verify or establish a connection by testing it.
- Tables - Explore the tables within the connected SQL Server database.