Resetting the database logon password

If you need to change the database logon password, first change it in the SQL Server and then in Sage CRM. For instructions on how to reset the database logon password in a Microsoft Azure SQL solution, see Authorize database access to SQL Database, SQL Managed Instance, and Azure Synapse Analytics on docs.microsoft.com.

1. In SQL Server, click the appropriate server.
2. Click the Security folder and then click Logins.
3. Right-click the relevant login, click Properties and change the password.
4. Go to the Management folder and right-click SQL Server Agent.
5. Click Properties | Connection and enter the new password.
6. Stop and start IIS. At the command prompt, type the following:
   Copy

   1
   2
   3
   net stop iisadmin /y
   net start w3svc
   net start msftpsvc

7. Log on to Sage CRM with system administrator rights.
8. Click <My Profile> | Administration | System | Database to view the login ID used to access the database.
9. Click Change, enter a new password, and click Save.