In Spring 2024, the SQL Server 2014 shared hosting systems will be refreshed and migrated to SQL 2019 shared hosting systems. This page serves to answer frequently asked questions for these database system refreshes.
The test systems IOWASQLTEST1, IOWASQLTEST2, and IOWASQLTEST3 will be refreshed on Monday, April 29, 2024, at 5:30 pm - 7:30 pm Central Time.
The production systems IOWASQLHOST1, IOWASQLHOST2, and IOWASQLHOST3 will be refreshed on Sunday, May 19, 2024, at 10 am - noon Central Time.
The test systems IOWASQLTEST1, IOWASQLTEST2, and IOWASQLTEST3 will be migrated to IOWASQLTEST7.
The production systems IOWASQLHOST1, IOWASQLHOST2, and IOWASQLHOST3 will be migrated to IOWASQLPROD7.
Connection strings to the new systems may require the fully qualified domain name of the database server (e.g. IOWASQLHOST1.iowa.uiowa.edu). You will not immediately be required to update the connection string to use the alias IOWASQLPROD7 or IOWASQLTEST7.
Connection strings that use an IP address will need to be updated to reflect the IP address of the new systems.
Drivers must support encryption in transit. For some drivers, the connection string may require explicit inclusion of the flags "Encrypt=True" or "TrustServerCertificate=True"
The current SQL Server 2014 systems are open to UIOWA-NETS (all campus networks, including data centers, campus buildings, campus wireless, and VPN).
The new SQL Server 2019 systems will be open to ITS data centers and, on request, static IP addresses on wired campus building machines. They will NOT be open to campus wireless or VPN.
To request network access the new SQL Server 2019 systems on a wired computer or building subnet outside of the data centers, contact the SQL DBA team at ITS-SQL-Help@uiowa.edu
Databases that require connectivity to campus wireless or VPN cannot reside on the new SQL Server 2019 shared hosting systems. They will need to be migrated to one of the following options no later than Friday, May 10, 2024.
- A dedicated SQL Server system
- The SQL Server 2016 shared hosting environment (IOWASQLTEST5 & IOWASQLHOST5)
To determine which option is right for your database, contact the SQL DBA team at ITS-SQL-Help@uiowa.edu to set up a consultation
In PowerShell on the system that needs to connect to SQL Server, use the following command:
Test-NetConnection -ComputerName IOWASQLPROD7.iowa.uiowa.edu -Port 1433
A successful connection will return a response like this:
A failed connection will return a response like this:
The SQL DBA team ran Microsoft’s Data Migration Assistant against all databases and no errors were reported by the tool.
Yes. If you would like to move your database prior to the scheduled migration date, please contact the SQL Server DBA team at ITS-SQL-Help@uiowa.edu