Update Azure SQL MI connection string and intent in VBA code

[edgytofu]

Task

Go through the provided VBA code for SQL queries and update the connection string to use the new Azure SQL Managed Instance details:

• Server: cdngb-admin-mc-rso-prod-cac-sqlmi.c5a0040ec5f1.database.windows.net
• User: instmcpssp1
• Password: (use provided password)
• ApplicationIntent: ReadOnly

Steps:

1. Find all instances of ADODB connection setup in the VBA code.
2. Replace the existing connection string with:

   Provider=sqloledb; Data Source=cdngb-admin-mc-rso-prod-cac-sqlmi.c5a0040ec5f1.database.windows.net;Initial Catalog=GB_MC_RSO_P1;User ID=instmcpssp1;Password=<password>;ApplicationIntent=ReadOnly
   

   • Remove any references to Integrated Security=SSPI.
   • Add ApplicationIntent=ReadOnly parameter.
   • Make sure password and user are correctly inserted.
3. Test the updated connection to ensure reports still generate successfully.
4. Update any related documentation to reflect the new connection settings.

---

Note: The password must be securely handled and not exposed in version control. Consider referencing environment variables or secure storage if possible.

Acceptance Criteria

• All connection strings updated in the code.
• ApplicationIntent=ReadOnly is present in every connection string.
• Old authentication method is removed.
• Documentation is updated as needed.
• Reports work with the new SQL MI server.