I'm trying to connect to my 2008R2 SQL server using the "Add Database Connection" wizard in Catalog, but I'm getting an error message "Unable to connect to database server to retrieve database list; please verify your server name, user name and password info and try again."
I opened up an ESRI support ticket but they just told me ArcMap 10.5 is not supported with SQL server 2008 and helped me create a read only connection to the DB and that's not helping me. I want to connect to the database so I can add a query layer and geocode addresses from my SQL DB. That's another story though, for now just trying to make the DB connection. Thanks.
Connection support for SQL Server 2008 stopped at the 10.4 release. Mainstream support for SQL Server 2008 R2 ended on July 8, 2014 (over 2 1/2 years ago) and only extended support is available, gives limited support on the platform.
Here is a Problem: Connections from ArcGIS 10.4.1 or ArcGIS Pro 1.3 to SQL Server 2008 or 2008 R2 fail technical article.
Extended SupportThe Extended Support phase follows Mainstream Support for business, developer, and desktop operating system products. At the supported service pack level, Extended Support includes:
- Paid support4
- Security update support at no additional cost
- Nonsecurity related updates requires Extended Hotfix Support to be purchased (per-fix fees also apply).5
Extended Hotfix Support is not available for desktop operating system consumer products. More details are available https://support.microsoft.com/kb/2702286here.NOTE:
- Microsoft will not accept requests for warranty support, design changes, or new features during the Extended Support phase
- Extended Support is not available for consumer, consumer hardware, or multimedia products
- Enrollment in a maintenance program may be required to receive these benefits for certain products4 Limited complimentary support may be available (varies by product).
5 Microsoft Lifecycle policy permits the creation and broad distribution of certain nonsecurity updates during the Extended Support phase. For example, it may be necessary to provide a nonsecurity update that enables continued connectivity and servicing through the Automatic Update or Windows Server Update service.
Also be sure your user connecting has privileges to access the SQL Server database. Also like others said install OBDC drivers and be sure the native SQL CLient is installed on the connecting machine