You work for a gaming company and are tasked with upgrading the code of the back end server application. The back end is originally designed for SQL 2008, but it is being upgraded to work with SQL 2012 for improved spatial data performance. During testing, you discover that the upgraded back end can connect, but it is unable to access some of the SQL 2012 enhanced features.
The SqlConnection.ConnectionString used by the back end to connect is:
Server=gameserver; Database=locationdb; Integrated Security=false; User ID=gameadmin; Password=12345; Type System Version=Latest; Application Name=Fightergame;
Based on the scenario above, why is the upgraded back end application unable to access some of the SQL 2012 enhanced features? 2
No Use Enhanced keyword is present in the connection string.
The Type System Version value must be set to SQL Server 2012.
The Password value length does not meet SQL 2012 requirements.
A Data Source keyword is missing from the connection string.
The User ID value must be sa for all SQL 2012 connections.