topic arcgis pro 1.1 connect to SQL Server no go? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57214#M2416 <HTML><HEAD></HEAD><BODY><P>Hey, pro 1.1 is extremely promising, lots of good stuff.</P><P>We use "Query Layers" (map layers resulting from a SQL Query which returns a shape column).</P><P>My database connection works fine in 10.2, but it will not connect in Pro with the same parameters:</P><P><IMG alt="connect_error.png" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/118324_connect_error.png" style="width: 620px; height: 469px;" /></P></BODY></HTML> Tue, 21 Jul 2015 18:17:23 GMT GaryMullaney 2015-07-21T18:17:23Z arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57214#M2416 <HTML><HEAD></HEAD><BODY><P>Hey, pro 1.1 is extremely promising, lots of good stuff.</P><P>We use "Query Layers" (map layers resulting from a SQL Query which returns a shape column).</P><P>My database connection works fine in 10.2, but it will not connect in Pro with the same parameters:</P><P><IMG alt="connect_error.png" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/118324_connect_error.png" style="width: 620px; height: 469px;" /></P></BODY></HTML> Tue, 21 Jul 2015 18:17:23 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57214#M2416 GaryMullaney 2015-07-21T18:17:23Z Re: arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57215#M2417 <HTML><HEAD></HEAD><BODY><P>Just&nbsp; upgraded to 1.1 and I'm getting the same error message, can't figure it out.</P><P>Any help is appreciated.</P></BODY></HTML> Fri, 24 Jul 2015 15:47:27 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57215#M2417 SSMIC3038 2015-07-24T15:47:27Z Re: arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57216#M2418 <HTML><HEAD></HEAD><BODY><P>Which version of SQL Server are you using?&nbsp; At ArcGIS Pro 1.1 the minimum supported version is SQL Server 2012 SP1.&nbsp; What version of the native client do you have installed?</P><P></P><P><A href="http://pro.arcgis.com/en/pro-app/help/data/management/database-requirements-sqlserver.htm" title="http://pro.arcgis.com/en/pro-app/help/data/management/database-requirements-sqlserver.htm">Microsoft SQL Server database requirements for ArcGIS Pro 1.1—ArcGIS Pro | ArcGIS for Desktop</A> </P></BODY></HTML> Fri, 24 Jul 2015 16:08:56 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57216#M2418 QuinnFrancis 2015-07-24T16:08:56Z Re: arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57217#M2419 <HTML><HEAD></HEAD><BODY><P>Try installing the SQL Server 2012 Native client from MyEsri or from the Microsoft website and test your connection again.</P><P></P><P><A href="https://www.microsoft.com/en-us/download/details.aspx?id=29065" title="https://www.microsoft.com/en-us/download/details.aspx?id=29065">Download Microsoft® SQL Server® 2012 Feature Pack from Official Microsoft Download Center</A> </P></BODY></HTML> Fri, 24 Jul 2015 16:20:43 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57217#M2419 QuinnFrancis 2015-07-24T16:20:43Z Re: arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57218#M2420 <HTML><HEAD></HEAD><BODY><P>That's likely the problem, were on 2008, upgrade to 2012 is in process.</P><P>Thanks.</P></BODY></HTML> Fri, 24 Jul 2015 17:14:30 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57218#M2420 SSMIC3038 2015-07-24T17:14:30Z Re: arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57219#M2421 <HTML><HEAD></HEAD><BODY><P>Once I upgraded to SQL Server 2012 SP1 I had no problems with connecting. If you haven't already, I would try that. </P></BODY></HTML> Tue, 28 Jul 2015 16:37:25 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57219#M2421 HeatherScroggins 2015-07-28T16:37:25Z Re: arcgis pro 1.1 connect to SQL Server no go? https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57220#M2422 <HTML><HEAD></HEAD><BODY><P>I am able to create a query layer from our 2005 SQL server and link shape files to it with an identity field without any error in ArcGIS Pro 1.1.&nbsp; However, if I modify the definition query in ArcGIS or modify the view on the server side the data in my query layer does not refresh.&nbsp; It returns the number of records I'm expecting but the values in all the fields for all the records are blank. </P><P>I have to delete and recreate the query layer and then recreate the joins to the shape and layer files.</P><P></P><P>Should I not be bothering to do this on a 2005 SQL server or am I missing something?</P></BODY></HTML> Fri, 18 Mar 2016 21:15:42 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-1-1-connect-to-sql-server-no-go/m-p/57220#M2422 SeanO_Halloran 2016-03-18T21:15:42Z