@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