@SETLOCAL @ECHO OFF CLS :Main CALL :StopSQL CALL :PasswordPolicyQuery CALL :ResetSQLQuery CALL :StartSQL PAUSE GOTO End :Display CLS ECHO ****************************** ECHO * SQL Password Reset Utility * ECHO ****************************** ECHO. GOTO End :StopSQL CALL :StopSQLDisplay NET STOP MSSQL$ACT7 CALL :StopSQLDisplay NET START MSSQL$ACT7 /m GOTO End :StopSQLDisplay CALL :Display ECHO Stopping SQL... ECHO. GOTO End :PasswordPolicyQuery CALL :Display SET /P Policy=Turn off Password Policy? (y/n) ECHO. IF %Policy%==y GOTO PasswordPolicy IF %Policy%==Y GOTO PasswordPolicy GOTO End :PasswordPolicy CALL :Display ECHO Turning off password policy... ECHO. SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTADMIN WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTOLEDB WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTACCESS WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTQUERY WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTREADER WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTREPORT WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTSYNC WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN ACTUSER WITH CHECK_POLICY = OFF" SQLCMD -S(local)\ACT7 -E -Q "ALTER LOGIN sa WITH CHECK_POLICY = OFF" GOTO End :ResetSQLQuery CALL :Display SET /P Reset=Reset SQL Password? (y/n) ECHO. IF %Reset%==y GOTO ResetSQL IF %Reset%==Y GOTO ResetSQL GOTO End :ResetSQL CALL :Display ECHO Resetting SQL Password... ECHO. SQLCMD -S(local)\ACT7 -E -Q "SP_PASSWORD null, Sage#2010, sa" GOTO End :StartSQL CALL :StartSQLDisplay NET STOP MSSQL$ACT7 CALL :StartSQLDisplay NET START MSSQL$ACT7 IF %Reset%==y GOTO SecurityCmdLnApp IF %Reset%==Y GOTO SecurityCmdLnApp GOTO End :StartSQLDisplay CALL :Display ECHO Starting SQL... ECHO. GOTO End :SecurityCmdLnApp CALL :Display FOR /F "tokens=2*" %%a in ('REG QUERY HKLM\SOFTWARE\ACT\Install /v InstallPath ^|FINDSTR Path') DO SET ActPath32=%%b FOR /F "tokens=2*" %%a in ('REG QUERY HKLM\SOFTWARE\Wow6432Node\ACT\Install /v InstallPath ^|FINDSTR Path') DO SET ActPath64=%%b IF DEFINED ActPath32 SET ActPath=%ActPath32% IF DEFINED Actpath64 SET ActPath=%Actpath64% CALL :Display ECHO Running Security Command Line Application... ECHO. cd %ActPath% SECURITYCMDLNAPP Sage#2010 GOTO End :End