Contents
How to connect to SQL Server from ArcGIS for desktop?
To use the data stored in SQL Server in services published to ArcGIS Server, you must also register the database with ArcGIS Server. To connect to a database or geodatabase in SQL Server from ArcGIS for Desktop, install the SQL Server native client on the ArcGIS for Desktop computer and create a connection file in the Catalog tree.
How to connect to a database in SQL Server?
You can connect to a database or geodatabase in SQL Server by adding a database connection under the Database Connections node in the Catalog tree in ArcMap or ArcCatalog or by using the Create Database Connection tool. Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.
How can I connect to another SQL Server instance?
In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click on the server instance you want to configure. In the right pane, double-click TCP/IP. In the TCP/IP Properties dialog box, click the IP Addresses tab. In the TCP Port box of the IPAll section, type an available port number.
Can a SQL Server be accessed from another computer?
To enhance security, the Database Engine of SQL Server Developer, Express, and Evaluation editions cannot be accessed from another computer when initially installed. This lesson shows you how to enable the protocols, configure the ports, and configure the Windows Firewall for connecting from other computers.
Is the SQL Server Driver supported in ArcGIS 10.2.1?
Microsoft SQL Server 2014 is supported at ArcGIS 10.2.1 and 10.2.2. The Microsoft ODBC Driver 11 for SQL Server is not supported by ArcGIS 10.2.1 or 10.2.2 clients.
What are the operating system requirements for ArcGIS?
If your database management system is installed on a server where ArcGIS products are installed, the server operating system must meet the ArcGIS product system requirements as well as the operating system requirements for your SQL Server version.
Can you install SQL Server Native Client on ArcGIS?
If ArcGIS for Server and SQL Server are installed on different computers, you must install the 64-bit SQL Server Native client on the ArcGIS for Server computer. You can obtain and install the SQL Server Native client from the Microsoft Download Center provided it is a version supported by ArcGIS.
Do You need A geodatabase to use ArcSDE?
An enterprise geodatabase must exist before you can start an ArcSDE service. If you have not already created a geodatabase, do so now. Also be sure the computer where you install the ArcSDE features meets the minimum system requirements. These can be found on the ArcGIS Resource Center. What is installed?
Which is SQL Server version does ArcGIS support?
For information on support with newer versions of ArcGIS, see the ArcGIS Enterprise system requirements. The following Microsoft SQL Server releases are the minimum certified versions supported with ArcGIS. SQL Server service packs and cumulative updates on these versions are supported but not certified.
How do I create a geodatabase in SQL Server?
Type the name of the SQL Server instance to which you will connect in the Instance text box. In the Database text box, type the name of the database where you want to store your geodatabase. If a database with that name does not already exist in the SQL Server instance, it will be created.