topic Registering SQL Database Connection in Server Manager Problems in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48234#M1744 <HTML><HEAD></HEAD><BODY><H2>I keep getting the following error:</H2><H2></H2><H2><SPAN style="color: #505051; font-family: Verdana, Geneva, sans-serif; font-size: 12px; background-color: #ffcdcd;">The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.No extended error.]</SPAN></H2><H2></H2><H2><SPAN style="color: #505051; font-family: Verdana, Geneva, sans-serif; font-size: 12px; background-color: #ffcdcd;">I have googled and tried everything I can think of and have found with no luck in registering my databases, maybe I'm missing something i did in my previous server installation, i have registered my server username in sql and gave proper priveledges, along with my windows login. Any help would be greatly appreciated.</SPAN></H2></BODY></HTML> Fri, 06 Nov 2015 17:42:10 GMT RandyHansford 2015-11-06T17:42:10Z Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48234#M1744 <HTML><HEAD></HEAD><BODY><H2>I keep getting the following error:</H2><H2></H2><H2><SPAN style="color: #505051; font-family: Verdana, Geneva, sans-serif; font-size: 12px; background-color: #ffcdcd;">The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.No extended error.]</SPAN></H2><H2></H2><H2><SPAN style="color: #505051; font-family: Verdana, Geneva, sans-serif; font-size: 12px; background-color: #ffcdcd;">I have googled and tried everything I can think of and have found with no luck in registering my databases, maybe I'm missing something i did in my previous server installation, i have registered my server username in sql and gave proper priveledges, along with my windows login. Any help would be greatly appreciated.</SPAN></H2></BODY></HTML> Fri, 06 Nov 2015 17:42:10 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48234#M1744 RandyHansford 2015-11-06T17:42:10Z Re: Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48235#M1745 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><PRE class="lia-code-sample line-numbers language-none">Randy Hansford wrote: </PRE></TD></TR></TBODY></TABLE></BLOCKQUOTE><H2 style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;" id="toc-hId--1330334928"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 12px; font-family: Verdana, Geneva, sans-serif; color: #505051; background-color: #ffcdcd;">The login is from an untrusted domain and cannot be used with Windows authentication.</SPAN></H2><P>Try using a Database Authenticated login with proper permissions, instead of the Windows login. See if that helps.</P></BODY></HTML> Fri, 10 Dec 2021 21:51:42 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48235#M1745 AsrujitSengupta 2021-12-10T21:51:42Z Re: Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48236#M1746 <HTML><HEAD></HEAD><BODY><P>can ya help me figure out how to do that exactly? is that a setting in server manager? </P></BODY></HTML> Fri, 06 Nov 2015 18:58:28 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48236#M1746 RandyHansford 2015-11-06T18:58:28Z Re: Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48237#M1747 <HTML><HEAD></HEAD><BODY><P>No, its not a setting, You will have create a Database Authenticated login, grant it required permissions and then make a connection with that in ArcCatalog. Then use this connection to register the database with ArcGIS Server.</P></BODY></HTML> Fri, 06 Nov 2015 19:46:41 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48237#M1747 AsrujitSengupta 2015-11-06T19:46:41Z Re: Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48238#M1748 <HTML><HEAD></HEAD><BODY><P>Could you give me an idea of your machine configuration?</P><P></P><P>If you are using ArcGIS Server in one machine and SQL Server in another, then the SQL Server is not trusting the account associated with ArcGIS Server. So, i would suggest that you modify the local ArcGIS User account into a domain account and then add that as a user to the database you want to map to. </P><P></P><P>Please let us know if that works for you! </P></BODY></HTML> Thu, 12 Nov 2015 17:14:39 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48238#M1748 AravindatStoryMaps 2015-11-12T17:14:39Z Re: Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48239#M1749 <HTML><HEAD></HEAD><BODY><P>This "could" be related to your use of a Domain Service account on ArcGIS SVR and/or SQL, and is related to the Server Principal Name not being registered in Active Directory. Try registering the SPN for SQL <A href="https://technet.microsoft.com/en-us/library/bb735885.aspx" title="https://technet.microsoft.com/en-us/library/bb735885.aspx">How to Configure an SPN for SQL Server Site Database Servers</A> and see if that works.</P></BODY></HTML> Fri, 13 Nov 2015 15:21:43 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/48239#M1749 ThomasColson 2015-11-13T15:21:43Z Re: Registering SQL Database Connection in Server Manager Problems https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/1673649#M43603 <P>I suddenly started getting this error and it turned out we were the first to notice that we were having widespread organization network issues, so it wasn't an issue with GIS in particular.</P> Wed, 17 Dec 2025 16:36:00 GMT https://community.esri.com/t5/arcgis-enterprise-questions/registering-sql-database-connection-in-server/m-p/1673649#M43603 ChelseaRozek 2025-12-17T16:36:00Z