NOTE: We suggest that steps 3 to 5 be completed outside of business hours by your IT team.
All APS users must have DB ownership on the aps_dsql database
Create an Active Directory group
Add APS users to this group
Launch SQL Management Studio
Assign the group DB ownership to the APS database
If the Login name has not been updated in the Fee earner console, the Windows login name for each APS user needs to be entered in the Login Name field.
Apply the following changes to all APS workstations and servers if your site is using ODBC\DSN connection
Change the ODBC connection to NT authentication
Update the connection string in the C:\adv2000\AAdbconf.exe as below in all APS
DSN=NAME of the DSN in ODBCsettings; DATABASE= name of your database
If your site is using DSNLESS connection, following changes should be applied to all APS workstations and servers.
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DATABASE NAME;Data Source=SQLSERVERNAME
Change the LOGINMODE in System and user Setting to 1.