> ## Documentation Index
> Fetch the complete documentation index at: https://syteca.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Server Issues and Error Messages

> Causes and fixes for common Application Server database connection errors, cleanup failures, and database migration questions.

<Warning>
  **NOT AVAILABLE IN SAAS.**
</Warning>

<AccordionGroup>
  <Accordion title={'"The connection with MS SQL Server database has been lost. Please check that the database is accessible and try again."'}>
    * The Application Server has lost its connection to MS SQL Server. Confirm MS SQL Server is running, online, and accessible — from the Application Server, run `ping <MS SQL Server computer name>`.
    * The connection may be blocked by a firewall. Try disabling the firewall on the MS SQL Server side to confirm.
  </Accordion>

  <Accordion title={'"Error occurred while cleaning up the database. Please try again."'}>
    * An unexpected error occurred during cleanup. Try the cleanup again.
    * Confirm the Application Server service is running.
    * Confirm the database computer is online and accessible — run `ping <database computer name>`.
    * If unresolved, send the **ServerLogs** folder (by default in `C:\Program Files\Ekran System\Ekran System`) to Syteca Support.
  </Accordion>

  <Accordion title={'"Error occurred while retrieving database info. Please try again."'}>
    * An unexpected error occurred while performing a database action. Try again.
    * Confirm the database computer is online and accessible — run `ping <database computer name>`.
    * If unresolved, send the **ServerLogs** folder to Syteca Support.
  </Accordion>

  <Accordion title="There are too many records in the database">
    Use [automatic or manual database cleanup](/docs/administration/deployment/database-management) to remove old records.
  </Accordion>

  <Accordion title="I defined a new database — what happened to the old one?">
    The old database remains untouched and unchanged.
  </Accordion>

  <Accordion title="I need a non-default MS SQL Server database user for the Application Server to use">
    Grant the user both the `dbcreator` and `public` roles, and make sure **User must change password at next login** is deselected.
  </Accordion>

  <Accordion title="I need to transfer data from an existing database to a new one">
    Restore the existing database from a backup copy into the new database.
  </Accordion>

  <Accordion title="I want to change the database type without losing data">
    This isn't possible — data can't be transferred between database types (for example, MS SQL Server to PostgreSQL).
  </Accordion>

  <Accordion title="I want to move the MS SQL Server database to another computer">
    Back up the database in SQL Server Management Studio (SSMS) and restore it on the new server. See [Upgrade from an older MS SQL Server version](/docs/administration/deployment/database-management#upgrade-from-an-older-ms-sql-server-version) for the full backup-and-restore procedure — it applies to moving a database to a new computer as well as upgrading MS SQL Server versions.
  </Accordion>

  <Accordion title="I accidentally removed the database from MS SQL Server">
    Restore it from a backup. Without a backup, you'll need to define a new database when reinstalling the Application Server.
  </Accordion>

  <Accordion title="The &#x22;Shrink Transaction Log&#x22; button is not available on the Database Management tab">
    Shrinking the transaction log is only supported for MS SQL Server — PostgreSQL doesn\`t support this operation.

    <Note>
      Shrinking can't be performed while a cleanup operation is in progress.
    </Note>
  </Accordion>
</AccordionGroup>

## Related

<CardGroup cols={2}>
  <Card title="Database management" icon="database" href="/docs/administration/deployment/database-management">
    Archive, cleanup, and transaction log maintenance.
  </Card>

  <Card title="Database parameters" icon="database" href="/docs/administration/database/database-parameters">
    Change database connection settings.
  </Card>

  <Card title="Creating databases manually" icon="database" href="/docs/administration/database/creating-databases-manually">
    Manual database and user setup.
  </Card>

  <Card title="PostgreSQL performance tuning" icon="gauge" href="/docs/resources/troubleshooting/postgresql-performance-tuning">
    Optimize PostgreSQL connection handling.
  </Card>
</CardGroup>