Hello,
We have a few jobs that use a “.NET Framework Data Provider for SQL Server” for the datasource in the connection string. The SQL server we are connecting to had the SQL Client 2012 which is End of Life. So it was uninstalled. When we did this, the jobs failed on our BOTS so we changed to use the “.NET Framework Data Provider for OLE DB”. When we clicked on the datasource connection drop down, we could see the databases.
We had to reinstall the SQL Client 2012 on the SQL server and now when we use the prior “.NET Framework Data Provider for SQL Server” we are not able to see the databases in the connection string. How do I correct this? Is something corrupted?