topic Connection Properties - User Name in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/connection-properties-user-name/m-p/844724#M4880 <HTML><HEAD></HEAD><BODY><P>I am using ArcGIS for Server 10.2.2 Enterprise with SQL Server 2012 with Database Authentication. Our Enterprise Geodatabase is one of many databases inside our SQL Server Instance.&nbsp;</P><P></P><P>I want to have multiple users connect to the Enterprise Geodatabase from ArcCatalog using ArcGIS for Desktop Basic. I have one user name and one password. It is the admin user name and password. I would prefer not to give this out to all our users.&nbsp;</P><P></P><P>How can I set up the security settings to allow for each user to use their individual network username and password to connect, and not have them all use the admin user name and password?</P></BODY></HTML> Thu, 29 Jun 2017 19:26:53 GMT TimHayes 2017-06-29T19:26:53Z Connection Properties - User Name https://community.esri.com/t5/geodatabase-questions/connection-properties-user-name/m-p/844724#M4880 <HTML><HEAD></HEAD><BODY><P>I am using ArcGIS for Server 10.2.2 Enterprise with SQL Server 2012 with Database Authentication. Our Enterprise Geodatabase is one of many databases inside our SQL Server Instance.&nbsp;</P><P></P><P>I want to have multiple users connect to the Enterprise Geodatabase from ArcCatalog using ArcGIS for Desktop Basic. I have one user name and one password. It is the admin user name and password. I would prefer not to give this out to all our users.&nbsp;</P><P></P><P>How can I set up the security settings to allow for each user to use their individual network username and password to connect, and not have them all use the admin user name and password?</P></BODY></HTML> Thu, 29 Jun 2017 19:26:53 GMT https://community.esri.com/t5/geodatabase-questions/connection-properties-user-name/m-p/844724#M4880 TimHayes 2017-06-29T19:26:53Z Re: Connection Properties - User Name https://community.esri.com/t5/geodatabase-questions/connection-properties-user-name/m-p/844725#M4881 <HTML><HEAD></HEAD><BODY><P>If you can add Windows groups to the SQL instance for authentication you can just do that and keep them as connect and view only, which is all you can do with Desktop basic.</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/add-users-sqlserver.htm#ESRI_SECTION1_1EF70F32F80041FB9666781BD3D78754" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/add-users-sqlserver.htm#ESRI_SECTION1_1EF70F32F80041FB9666781BD3D78754">Add logins and users to SQL Server—Help | ArcGIS Desktop</A>&nbsp;</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/geodatabase-functionality-basic.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/geodatabase-functionality-basic.htm">Geodatabase functionality in ArcGIS Desktop Basic—ArcGIS Help | ArcGIS Desktop</A>&nbsp;</P><P></P><P>I know this help is for 10.5.x, but the same principals would apply.</P></BODY></HTML> Thu, 29 Jun 2017 19:33:56 GMT https://community.esri.com/t5/geodatabase-questions/connection-properties-user-name/m-p/844725#M4881 George_Thompson 2017-06-29T19:33:56Z