

If the login used for the operating system is not a valid database login, the connection fails. If you choose Operating system authenticationyou 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. Also note that Save user name and password must be checked for connection files that 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 will be prompted to provide a user name 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. ArcGIS will add the delimiter automatically when it is passed to SQL Server you do not need to include delimiters with the user name.įor example, if your user name is map. These user names must be delimited whenever they are used. User names can be a maximum of 30 characters. If you choose Database authenticationyou must provide a valid database user name and password in the User name and Password text boxes, respectively. There are two login options for creating a connection to a database or enterprise geodatabase: database authentication and operating system authentication. These properties help ArcGIS Pro locate the database, and provide authentication information to allow you to log in to the database. When you connect to a database in ArcGIS Proyou will be prompted to fill in the connection properties. Most types of databases require you install and configure a database client on the machine that will connect to the database. Some of the databases you access can contain geodatabase tables, functions, and procedures, but they don't have to you can connect to any supported database and view the data from ArcGIS Pro. You can connect to databases from ArcGIS to view, query, and analyze the data they contain.
