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. 

What systems will be refreshed and when?

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. 

Where will the systems be moved to?

The test systems IOWASQLTEST1, IOWASQLTEST2, and IOWASQLTEST3 will be migrated to IOWASQLTEST7. 

 

The production systems IOWASQLHOST1, IOWASQLHOST2, and IOWASQLHOST3 will be migrated to IOWASQLPROD7. 

Will I need to update my connection strings or SQL Server drivers?

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 addition of the flags "Encrypt=True" or "TrustServerCertificate=True"

How will network connectivity to my database change after the migration?

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. 

How do I request access network access to my database?

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

What do I do if my databases need to be accessed via campus wireless or VPN?

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.

 

  1. A dedicated SQL Server system
  2. 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

How can I test network connectivity to the new SQL Server instances?

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:

Picture1

 

 

A failed connection will return a response like this:

PowerShell failed TCP ping

 

 

Is my SQL Server 2014 database compatible with SQL Server 2019?

The SQL DBA team ran Microsoft’s Data Migration Assistant against all databases and no errors were reported by the tool. 

Can I move my SQL Server 2014 database to SQL Server 2019 systems prior to the scheduled migration date?

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

Last updated
Article number
7136