Issue
The user cannot log in to the PAM Console and receives an Invalid Username error.
Cause
The MSSQL database drive is full due to excessive log files, preventing the database from writing new data.
Resolution
When the database drive is full, the standard database shrink procedure may fail due to insufficient disk space. Follow the steps below to free up storage by running SQL queries
-
Open SQL Server Management Studio (SSMS).
-
Click Connect, select the Server Name, and choose SQL Server Authentication.
-
Enter the database administrator credentials.
-
Open a new query window and execute the following query:
BACKUP log SectonaDB TO DISK = ‘null’
-
Execute the following query once to shrink the database log file:
dbcc shrinkfile (2,500)
-
Verify that disk space has been freed and PAM login is working.
MSSQL is a customer-managed database. For any issues, contact the database team to perform these operations.