topic Re: ArcSDE 9.1 and SQLServer 2008 in Data Management Questions https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616780#M34820 <HTML><HEAD></HEAD><BODY><SPAN>The configuration is unsupported (all configurations involving ArcSDE 9.1 are now unsupported, but no </SPAN><BR /><SPAN>testing has ever been done with 9.1 and SQL-Server 2008) -- Any number of problems may arise.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Fri, 23 Sep 2011 10:21:49 GMT VinceAngelo 2011-09-23T10:21:49Z ArcSDE 9.1 and SQLServer 2008 https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616775#M34815 <HTML><HEAD></HEAD><BODY><SPAN>Dear All,</SPAN><BR /><SPAN>We have SDE databse which in in SQL Server 2000 and we are using ArcSDE 9.1.</SPAN><BR /><SPAN>We want to move SDE databade to SQL Server 2008 and still we want to use ArcSDE 9.1.</SPAN><BR /><BR /><SPAN>We have moved it to SQLServer 2008 and it is working successfully if we install ArcSDE-SQLServer-91sp2 and set the database Compatibility level to SQL Server 2000(80). </SPAN><BR /><BR /><SPAN>Is the above is correct way to use SQL Server 2008 and ArcSDE 9.1? or any problems will araise?</SPAN><BR /><BR /><SPAN>Please help me.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Uday</SPAN></BODY></HTML> Thu, 22 Sep 2011 10:53:38 GMT https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616775#M34815 Udaya_BhaskerCheerala 2011-09-22T10:53:38Z Re: ArcSDE 9.1 and SQLServer 2008 https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616776#M34816 <HTML><HEAD></HEAD><BODY><SPAN>SQL-Server 2008 support was not introduced until ArcSDE 9.3.&nbsp; There is little chance that </SPAN><BR /><SPAN>this combination will work (see </SPAN><A href="http://forums.arcgis.com/threads/25647-Can-t-connect-to-Ora-10g-w-3-tier-conn-from-AGS-Svr-10-SP1?p=84926&amp;viewfull=1#post84926">Vince's First Law of Compatibility</A><SPAN>), and no chance at all for</SPAN><BR /><SPAN>spatial type support.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 22 Sep 2011 11:28:26 GMT https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616776#M34816 VinceAngelo 2011-09-22T11:28:26Z Re: ArcSDE 9.1 and SQLServer 2008 https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616777#M34817 <HTML><HEAD></HEAD><BODY><SPAN>Dear Vince,</SPAN><BR /><SPAN>Thank you very much for the quick reply. Eventhough SQL Server is 2008, the SDE database Compatibility level is SQL Server 2000(80).&nbsp; And Iam able to edit the feature classes and save to database.</SPAN><BR /><BR /><SPAN>Could you please let me know what spatial type support this combination does not support.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Uday</SPAN></BODY></HTML> Thu, 22 Sep 2011 16:05:55 GMT https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616777#M34817 Udaya_BhaskerCheerala 2011-09-22T16:05:55Z Re: ArcSDE 9.1 and SQLServer 2008 https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616778#M34818 <HTML><HEAD></HEAD><BODY><SPAN>I meant support for SQL-Server's spatial types -- GEOMETRY and GEOGRAPHY columns.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>The combination itself is completely unsupported by Esri (9.1 is in "retired" status).</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 22 Sep 2011 16:15:07 GMT https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616778#M34818 VinceAngelo 2011-09-22T16:15:07Z Re: ArcSDE 9.1 and SQLServer 2008 https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616779#M34819 <HTML><HEAD></HEAD><BODY><SPAN>Hello Vince,</SPAN><BR /><BR /><SPAN>Thank you very much for the response. If I do not use spatial types -- GEOMETRY and GEOGRAPHY in my database, is this combination is fine or any other problems may araise?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Uday</SPAN></BODY></HTML> Fri, 23 Sep 2011 02:51:55 GMT https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616779#M34819 Udaya_BhaskerCheerala 2011-09-23T02:51:55Z Re: ArcSDE 9.1 and SQLServer 2008 https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616780#M34820 <HTML><HEAD></HEAD><BODY><SPAN>The configuration is unsupported (all configurations involving ArcSDE 9.1 are now unsupported, but no </SPAN><BR /><SPAN>testing has ever been done with 9.1 and SQL-Server 2008) -- Any number of problems may arise.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Fri, 23 Sep 2011 10:21:49 GMT https://community.esri.com/t5/data-management-questions/arcsde-9-1-and-sqlserver-2008/m-p/616780#M34820 VinceAngelo 2011-09-23T10:21:49Z