topic Create Direct Database Connection: SQL Server 2008 in Data Management Questions https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332116#M18916 <HTML><HEAD></HEAD><BODY><SPAN>I've never had to connect to an enterprise database (SQL Server 2008) before and please note the database that I'm trying to connect to is not a spatial database. I want to connect to the following database to retrieve records that I can generate spatial data from. The records are of Police incidents that contain coordinates of the location of each incident and the particulars of the incident. I want to use the following information to start analyzing&nbsp; crime. </SPAN><BR /><BR /><SPAN>I've been provided with the </SPAN><STRONG>IP Address</STRONG><SPAN> of the SQL Server (2008)&nbsp; as well as a </SPAN><STRONG>User Name</STRONG><SPAN> and </SPAN><STRONG>Password </STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>When I try to create a database connection from within ArcCatalog I receive the following error message:</SPAN><BR /><BR /><SPAN>I've attached a print screen of the database connection parameters that I'm entering as well as the error message. </SPAN><BR /><BR /><SPAN>I have asked the Database Administrator to change the compatibility of the particular database that I'm trying to connect to (IMSWarehouse) to level 90 (SQL Server 2005), but I still receive the same error.</SPAN><BR /><BR /><SPAN>Any advice in how I can create a direct connection to the following database will be appreciated.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>NB: I'm currently running ArcGIS 10.1 with SP1</SPAN></BODY></HTML> Thu, 16 May 2013 10:58:03 GMT PeterWilson 2013-05-16T10:58:03Z Create Direct Database Connection: SQL Server 2008 https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332116#M18916 <HTML><HEAD></HEAD><BODY><SPAN>I've never had to connect to an enterprise database (SQL Server 2008) before and please note the database that I'm trying to connect to is not a spatial database. I want to connect to the following database to retrieve records that I can generate spatial data from. The records are of Police incidents that contain coordinates of the location of each incident and the particulars of the incident. I want to use the following information to start analyzing&nbsp; crime. </SPAN><BR /><BR /><SPAN>I've been provided with the </SPAN><STRONG>IP Address</STRONG><SPAN> of the SQL Server (2008)&nbsp; as well as a </SPAN><STRONG>User Name</STRONG><SPAN> and </SPAN><STRONG>Password </STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>When I try to create a database connection from within ArcCatalog I receive the following error message:</SPAN><BR /><BR /><SPAN>I've attached a print screen of the database connection parameters that I'm entering as well as the error message. </SPAN><BR /><BR /><SPAN>I have asked the Database Administrator to change the compatibility of the particular database that I'm trying to connect to (IMSWarehouse) to level 90 (SQL Server 2005), but I still receive the same error.</SPAN><BR /><BR /><SPAN>Any advice in how I can create a direct connection to the following database will be appreciated.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>NB: I'm currently running ArcGIS 10.1 with SP1</SPAN></BODY></HTML> Thu, 16 May 2013 10:58:03 GMT https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332116#M18916 PeterWilson 2013-05-16T10:58:03Z Re: Create Direct Database Connection: SQL Server 2008 https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332117#M18917 <HTML><HEAD></HEAD><BODY><SPAN>You're probably looking for an ODBC or other pure database connection.&nbsp; Direct Connect</SPAN><BR /><SPAN>will only work against databases with an ArcSDE geodatabase install.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 16 May 2013 11:17:35 GMT https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332117#M18917 VinceAngelo 2013-05-16T11:17:35Z Re: Create Direct Database Connection: SQL Server 2008 https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332118#M18918 <HTML><HEAD></HEAD><BODY><SPAN>Original User: asrujit</SPAN><BR /><BR /><SPAN>Peter,</SPAN><BR /><BR /><SPAN>Please download and install a current SQL Server Native Client and then the connection should work fine.</SPAN><BR /><BR /><SPAN>Microsoft® SQL Server® 2008 R2 Feature Pack</SPAN><BR /><A href="http://www.microsoft.com/en-in/download/details.aspx?id=16978">http://www.microsoft.com/en-in/download/details.aspx?id=16978</A><BR /><BR /><SPAN>Look for "</SPAN><STRONG>Microsoft® SQL Server® 2008 R2 Native Client</STRONG><SPAN>" under </SPAN><STRONG>Install Instructions</STRONG><SPAN>. Download and install that.</SPAN><BR /><BR /><SPAN>Hope this helps!</SPAN><BR /><BR /><SPAN>Regards,</SPAN></BODY></HTML> Thu, 16 May 2013 12:13:29 GMT https://community.esri.com/t5/data-management-questions/create-direct-database-connection-sql-server-2008/m-p/332118#M18918 Anonymous User 2013-05-16T12:13:29Z