If you choose Operating system authentication, you do not need to type a username and password-the connection is made using the login name and password used to sign in to the operating system. Also note that you must check Save user name and password if you use the connection file to provide ArcGIS services with access to the database or geodatabase, or if you want to use the Catalog pane search to locate data accessed through this connection file. However, if you do this, you'll be prompted to provide a username and password every time you connect. Uncheck Save user name and password if you prefer not to save your login information as part of the connection doing this can help maintain the security of the database. For more information on regular and delimited identifiers, see your SQL Server documentation.

For example, if your username is map.user, type map.user, not 'map.user', in the User name text box. ArcGIS adds the delimiter automatically when it is passed to SQL Server you do not need to include delimiters with the username. These usernames must be delimited whenever they are used. Outside of ArcGIS, you can create usernames in Microsoft SQL Server that contain special characters. If you choose Database authentication, you must provide a valid database username and password in the User name and Password text boxes, respectively. To access nonspatial data in databases that ArcGIS doesn't directly support, see Work with OLE DB connections.įor most supported databases and database service offerings, there are two login options for creating a connection to a database or enterprise geodatabase: database authentication and operating system authentication.įor Microsoft Azure SQL Managed Instance and Microsoft Azure SQL Database instances that are configured to use Microsoft Azure Active Directory, you have additional Azure Active Directory authentication options. ArcGIS supports connections to a specific set of databases.For information on connecting to a cloud data warehouse using a database connection, see Connections to cloud data warehouses in ArcGIS Pro. The information here does not apply to connections to cloud data warehouses.See Work with SQLite databases and GeoPackage files in ArcGIS Pro for instructions on connecting to these types of files. The information in this help page does not apply to connections to SQLite databases or GeoPackage files.

Navicat connect to postgresql