The QDB Server has been upgraded from SQL Server 2008 to SQL Server 2014.
The QDB Server has been upgraded from SQL Server 2008 to SQL Server 2014. With this upgrade comes the requirement that you must use TLS version 1.2 as lower versions have been disabled.
As a result, if you're connecting to QDB via an ODBC connection (e.g. using Microsoft Excel or Access), you may need to install some updates on your computer or have your IT team do so for you.
You can refer to the following article for information regarding TLS and SQL Server:
Here are steps you can follow if you are having trouble connecting
- Make sure you are using TLS 1.2 by following the steps in this article
- Make sure you are using ODBC SQL Driver 11 or higher which you can check in your ODBC Data Source Administrator from the Drivers tab:
- To connect to the FPM Ad-Hoc Reporting Tool
- Download the latest version (2/10/2020) of QDBGPFPM.zip from their website: https://medschool.ucla.edu/financial-affairs/deans-office-excel-qdb-applications.
- Install this driver: https://www.microsoft.com/en-us/download/details.aspx?id=50402.
- If you need help with these installations, please contact the DGIT - Enterprise Data & Analytics team at DGIT-EDA@mednet.ucla.edu.
- If you still can't connect, try flushing your DNS. To do this, open a Command Prompt (which you can find using Windows search). Then type the following in the resulting window and hit Enter:
If you have any further questions or issues, please contact us at support@qdb.ucla.edu.
