Home > database >  Connection of SQL Server from ArcGIS Fails
Connection of SQL Server from ArcGIS Fails

Time:10-22

I am trying to connect to sql server from arcgis desktop and and I do the connection as follows:

  1. I expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.

  2. I chose SQL Server from the Database Platform drop-down list.

  3. I typed the SQL Server instance name in the Instance text box as basset\spatial,61000 .

  4. I chose the type of authentication to use when connecting to the database: Operating system authentication.

But when I click on database, it will not show any thing,

mean my connection is not establishing with sql server.

Any help on this issue matters me a lot.

CodePudding user response:

Install the SQL Server Native client

You can obtain and install the SQL Server Native client from the Microsoft Download Center provided it is a version supported by ArcGIS.

Alternatively, you can download and install the SQL Server Native client from My Esri.

Install the client on all computers where ArcGIS for Desktop is installed.

If you are installing the client on a 64-bit operating system, run the 64-bit executable; it installs both 32- and 64-bit files. If you run the 32-bit SQL Server Native client on a 64-bit operating system, it will fail.

  • Related