topic How can I make a database connection as a user when I am using Windows authentification and a Windows Domain? in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/how-can-i-make-a-database-connection-as-a-user/m-p/488033#M18910 <HTML><HEAD></HEAD><BODY><P>I added a new user to a role in ArcServer 10.3.1, on SQL server, in a networking environment using a&nbsp; windows domain. The new user added in in the form of domain\username.&nbsp; I wanted to test the privileges I granted the new user, but couldn't figure out a good test.&nbsp; I tried both the new user and an existing user's login to start ArcCatalog 10.3.1 as a different user (right click, run as a different user), ArcCatalog started I guess as that user,&nbsp; but I couldn't seem to make the database connection as one of the users.&nbsp; For Authentication type, the OS authentication choice grays out the User name, password boxes as I expected, but I would suppose that means the connection would be with my current machine login credentials, not one of the users.&nbsp; If I choose Database authentication,&nbsp; then I can't make the domain\username or just the user name with the user's password work to see any database on my server.&nbsp; </P><P></P><P>Or wait, maybe I am getting a different list of databases when I run ArcCatalog as one of these users and using OS authentication than when I start AC as myself.</P><P></P><P>How did I get talked into using Windows OS authentication? I get so confused.&nbsp;</P></BODY></HTML> Wed, 10 May 2017 00:59:54 GMT PaulHuffman 2017-05-10T00:59:54Z How can I make a database connection as a user when I am using Windows authentification and a Windows Domain? https://community.esri.com/t5/arcgis-enterprise-questions/how-can-i-make-a-database-connection-as-a-user/m-p/488033#M18910 <HTML><HEAD></HEAD><BODY><P>I added a new user to a role in ArcServer 10.3.1, on SQL server, in a networking environment using a&nbsp; windows domain. The new user added in in the form of domain\username.&nbsp; I wanted to test the privileges I granted the new user, but couldn't figure out a good test.&nbsp; I tried both the new user and an existing user's login to start ArcCatalog 10.3.1 as a different user (right click, run as a different user), ArcCatalog started I guess as that user,&nbsp; but I couldn't seem to make the database connection as one of the users.&nbsp; For Authentication type, the OS authentication choice grays out the User name, password boxes as I expected, but I would suppose that means the connection would be with my current machine login credentials, not one of the users.&nbsp; If I choose Database authentication,&nbsp; then I can't make the domain\username or just the user name with the user's password work to see any database on my server.&nbsp; </P><P></P><P>Or wait, maybe I am getting a different list of databases when I run ArcCatalog as one of these users and using OS authentication than when I start AC as myself.</P><P></P><P>How did I get talked into using Windows OS authentication? I get so confused.&nbsp;</P></BODY></HTML> Wed, 10 May 2017 00:59:54 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-can-i-make-a-database-connection-as-a-user/m-p/488033#M18910 PaulHuffman 2017-05-10T00:59:54Z