The test systems IOWASQLTEST1, IOWASQLTEST2, and IOWASQLTEST3 will be refreshed on Monday, April 29, 2024, at 5:30 pm Central Time. 

 

The production systems IOWASQLHOST1, IOWASQLHOST2, and IOWASQLHOST3 will be refreshed on Sunday, May 19, 2024, at 10 am 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. 

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 3, 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

In PowerShell, use the following command:

Test-NetConnection -ComputerName <SQL Server Instance Name>.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

Article number: 
129121
Last updated: 
February 26, 2024