After changing the password in SQL, you must update the connection string in the Net2 Configuration Utility under the "Database" tab so the software can reconnect. 3. What is a Database "Repack"?
Open the Configuration Utility, navigate to the Database tab, and select Maintain Database or Repack .
Scans for minor corruption within the tables. 4. How to Perform a Repack
Right-click the sa user (or the specific Net2 SQL user), select Properties , and enter a new password.
If you have lost access to the Net2 SQL instance, you cannot simply "view" the password in the Net2 Configuration Utility. You must reset it through :
By default, Paxton Net2 installs a specific instance of SQL (often named NET2 ) using .
The Repack utility is built into the .
Over time, as users are added, deleted, and events are logged, the SQL database can become fragmented or bloated with "white space." This leads to sluggish performance when opening the Net2 software or running reports.
Depending on the size of your event log (e.g., millions of entries), this can take anywhere from five minutes to over an hour. 5. Security Best Practices