UGRC is in the process of migrating our MS SQL database environment from Microsoft SQL Server 2008 to Microsoft SQL Server 2014. This migration will only impact users who use the preferred ‘direct connect’ route to use SGID ArcSDE database over the State Network. Keep in mind that many counties and cities use the DTS operated State Network as their ISP, so the impact will extend beyond state government settings.
The primary purpose of the migration is to remain current with the underlying technology that we use, and to fend off technical support deprecation for our current environment.
In preparation, SGID ArcSDE users will need to ensure:
- their ArcGIS database connection uses the correct DNS name, and
- the appropriate MS SQL client is loaded on their machine.
All SGID ArcSDE direct connections from within the State Network, will need to use the new DNS name:
sgid.agrc.utah.gov. For users outside the state network, UGRC makes all of it’s SGID data available for download from our website. We also make much of the popular SGID data available in ArcGIS Online. Search tags for SGID and category type for ease of use.
Microsoft SQL Native Client 11 will be required for any desktop ArcSDE users within the state network. We are working with DTS to automatically push out the Microsoft SQL Native Client 11 to identified desktop SGID users within state government. We will identify users that need the client pushed to them by using the mailing list for the UGRC newsletter (@utah.gov emails), and by working with GIS managers within state government. You can also open a ticket with through the DTS help desk to ensure the correct client is installed.
The plan is to make the migration on January 21, 2016 (UPDATED), so for state network SGID ArcSDE users, please update your DNS name and SQL client at your earliest convenience.