"The connection with MS SQL Server database has been lost. Please check that the database is accessible and try again."
"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.
"Error occurred while cleaning up the database. Please try again."
"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.
"Error occurred while retrieving database info. Please try again."
"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.
There are too many records in the database
There are too many records in the database
Use automatic or manual database cleanup to remove old records.
I defined a new database — what happened to the old one?
I defined a new database — what happened to the old one?
The old database remains untouched and unchanged.
I need a non-default MS SQL Server database user for the Application Server to use
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.I need to transfer data from an existing database to a new one
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.
I want to change the database type without losing data
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).
I want to move the MS SQL Server database to another computer
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 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.
I accidentally removed the database from MS SQL Server
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.
Related
Database management
Archive, cleanup, and transaction log maintenance.
Database parameters
Change database connection settings.
Creating databases manually
Manual database and user setup.
PostgreSQL performance tuning
Optimize PostgreSQL connection handling.