![]() ![]() Configure the instance to allow connections First, though, be sure your SQL Server instance is configured to accept remote connections. If SQL Server and ArcGIS Server are running on separate machines, install the Microsoft ODBC driver for SQL Server on all machines in the ArcGIS Server site. See Make your data accessible to ArcGIS Server for more information about sharing a connection file. If you use the data from this connection as the source for a service, such as a geoprocessing or geocoding service, you may need to place the connection file in a shared location on your network. You can move the connection to another location just be sure users and applications that need to make a connection have read access to the directory where you place the connection file. In the following example, a connection is made to the database, spatialdata, on the SQL Server instance server1\ss08r2 using database authentication.Ī file is created in \\\Users\\AppData\Roaming\ESRI\Desktop\ArcCatalog. However, if you do this, you will be prompted to provide a user name and password every time you connect from a desktop client. Uncheck Save user name and password if you prefer to not save your login information as part of the connection doing this can help maintain the security of the database. If you choose Database authentication, you must provide a valid database user name and password in the User name and Password text boxes, respectively. If the login used for the operating system is not a valid database login, the connection fails. ![]() If you choose Operating system authentication, you do not need to type a user name and password-the connection is made using the login name and password used to log in to the operating system. ![]() Choose the type of authentication to use when connecting to the database: Database authentication or Operating system authentication.Note:Īdditional information is needed in the Instance text box to connect to a highly available SQL Server database. If you are using a SQL Server instance named terra\gis, type terra\gis in the Instance text box. If your Azure SQL Database instance name is, type in the Instance text box. For example, if the SQL Server instance is basset\spatial and is listening on port 61000, type basset\spatial,61000 in the Instance text box. If your database is listening on a port other than the default (1433), include the port number in the instance. For example, if the IPV6 address of the server is 2000:ab1:0:2:f333:c432:55f6:d7ee, type in the Instance text box. If specifying an IPV6 address, enclose the address in brackets. Type the SQL Server instance name in the Instance text box.įor example, if you are using a default SQL Server instance, you can specify the instance name or the IP address of the server in the Instance text box.Choose SQL Server from the Database Platform drop-down list.Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.The following steps describe using the Database Connection dialog box: 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. If you run the 32-bit installation on a 64-bit ![]() If you are installing the driver on a 64-bit operating system, run the 64-bit executable it installs both 32- and 64-bit files. Install the driver on all computers where ArcMap is installed. Be sure to get the Microsoft ODBC driver that is supported for the version of SQL Server to which you want to connect. Obtain the Microsoft ODBC driver for SQL Server from the Microsoft Download Center or from My Esri. See the Microsoft SQL Server documentation for more information. If you have a new installation of SQL Server, be sure the SQL Server service is running and listening on the correct ports. Configure the instance to allow connectionsīy default, SQL Server instances are not configured to allow connections from other computers. First, though, be sure your SQL Server instance can accept connections from remote computers. Connect from ArcMapĬonnect to a database or geodatabase in SQL Server from ArcMap, install the Microsoft ODBC driver for SQL Server on the ArcMap computer and create a connection file in the Catalog tree. To publish ArcGIS Server web services that reference the data in your SQL Server database, register the database connection file with your ArcGIS Server sites. Once the SQL Server ODBC driver is configured on all your ArcGIS client machines, create a database connection file. To connect to Microsoft SQL Server from an ArcGIS client, install a supported Microsoft SQL Server ODBC driver on the ArcGIS client machine and connect to the database from the ArcGIS client. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |