Database Connections

Help Orchestrator
,
1

We have an active database connection that has stopped working due to a new SSL certificate - it’s stating it is not trusted. I cannot appear to be able to locate the connection to check it however? Any help would be appreciated!

2

you need to locate the database connection configuration and update it to accept the new SSL certificate. Here’s what you can do try to follow this Steps:-

  1. Identify the Application or Service: Determine which application or service is connecting to the database.

  2. Review Configuration Files: Look for configuration files related to the application or service. This might include files with extension .config, .xml, or others depending on the technology stack.

  3. Search for Connection Strings: Search for connection strings within the configuration files. These strings typically contain information about the database connection, including the server address, credentials, and SSL settings.

  4. Update SSL Settings: Once you find the connection string, locate the SSL-related settings. You may need to update these settings to trust the new SSL certificate. This could involve specifying the path to the certificate file or setting a flag to ignore certificate validation (not recommended for production environments).

  5. Restart the Application or Service: After updating the configuration, restart the application or service to apply the changes.

  6. Test the Connection: Verify that the database connection is now working properly. You can do this by attempting to connect to the database from the application or by checking for any error messages related to the connection.

Check whether the issue get resolve or not or else we will find some another solution

3

Hi thank you for the information - are you able to tell me where I can find the existing database connection? I have searched high and low and can’t find where it would be.

4

@tom.davies

database connections are typically established using activities from the UiPath.Database.Activities package or similar database-related activities. Here’s how you can find existing database connections:

  1. Activities Panel: Open UiPath Studio and navigate to the Activities panel on the left-hand side of the screen. Look for activities related to database operations, such as “Connect”, “Execute Query”, or “Disconnect”. These activities are typically used to establish and manage database connections.

  2. Search for Database Activities: If you have a specific activity or activity package in mind that you use for database connections (e.g., UiPath.Database.Activities), you can directly search for it in the Activities panel. Use the search bar at the top of the panel and enter keywords like “database” or “connect” to filter the activities related to database operations.

  3. Inspect Workflow Files: If the database connection is not directly visible in the Activities panel, it might be defined within the workflow files (.xaml). You can inspect the workflow files by opening them in UiPath Studio and searching for keywords related to database connection settings. Look for variables, arguments, or activities that initialize or use database connections.

  4. Project Dependencies: Check the project dependencies to see if any external libraries or packages are used for database connections. If there are custom activities or libraries used for database operations, they might contain the configurations for database connections.

6

@tom.davies,

You should be updating connection string of your Connect To Database activity.
Sample Connection String: Data Source=YourSQLServer;Initial Catalog=DatabaseName;Integrated Security=True;Encrypt=True

Whatever would be your connection string make sure you use Encrypt=True

Thanks,
Ashok :slight_smile: