topic Upgrade SQL Database in Data Management Questions https://community.esri.com/t5/data-management-questions/upgrade-sql-database/m-p/695386#M39520 <HTML><HEAD></HEAD><BODY><SPAN>We are in the process of migrating to ArcGIS10, however; before we do this we need to upgrade our SQL Server database.</SPAN><BR /><BR /><SPAN>I was told that there was a way to write the user accounts and password information to a file that can be imported after the upgrade is performed.&nbsp; Does anyone know what the command line syntax is?</SPAN><BR /><BR /><SPAN>We have been delaying our upgrade because we do not know what some of the passwords are.</SPAN></BODY></HTML> Mon, 30 Aug 2010 18:05:06 GMT NicholasBarger 2010-08-30T18:05:06Z Upgrade SQL Database https://community.esri.com/t5/data-management-questions/upgrade-sql-database/m-p/695386#M39520 <HTML><HEAD></HEAD><BODY><SPAN>We are in the process of migrating to ArcGIS10, however; before we do this we need to upgrade our SQL Server database.</SPAN><BR /><BR /><SPAN>I was told that there was a way to write the user accounts and password information to a file that can be imported after the upgrade is performed.&nbsp; Does anyone know what the command line syntax is?</SPAN><BR /><BR /><SPAN>We have been delaying our upgrade because we do not know what some of the passwords are.</SPAN></BODY></HTML> Mon, 30 Aug 2010 18:05:06 GMT https://community.esri.com/t5/data-management-questions/upgrade-sql-database/m-p/695386#M39520 NicholasBarger 2010-08-30T18:05:06Z Re: Upgrade SQL Database https://community.esri.com/t5/data-management-questions/upgrade-sql-database/m-p/695387#M39521 <HTML><HEAD></HEAD><BODY><SPAN>Hi Nicholas,</SPAN><BR /><BR /><SPAN>I don't have a sure solution for you. But based on what we did in Oracle, I think you can do it in SQL Server this way,</SPAN><BR /><BR /><SPAN>1. Export user name and password_hash information from sys.sql_logins system view to a text file. </SPAN><BR /><SPAN>2. Run CREATE LOGIN &lt;loginName&gt; WITH PASSWORD = &lt;hashed_password&gt; HASHED &lt;other options&gt;, where the loginName is a user name from the text file, the hashed_password is the associated hashed code.</SPAN><BR /><BR /><SPAN>Hopefully this is what you are looking for. Thanks!</SPAN></BODY></HTML> Tue, 31 Aug 2010 14:52:39 GMT https://community.esri.com/t5/data-management-questions/upgrade-sql-database/m-p/695387#M39521 RobertHu 2010-08-31T14:52:39Z