Installation Guide III: SQL Server
SQL Server
Please, pay attention to the following points before installing the SQL Server.
If instead you are connecting to a Microsoft Azure SQL, please read this article.
Using Microsoft SQL Express Server
- Use Express versions of Microsoft SQL Server only for demonstration purposes and for very small organizations.
- SQL Express Server size is limited to 10 GB. This limit may be reached quickly, especially when using Secure Audit. In this case errors will occur when executing EgoSecure Data Protection.
Connecting to the Microsoft SQL Server
When using the named instances on the Microsoft SQL Server, meet the following conditions so that the EgoSecure Server can connect to the SQL Server during the installation and can create the database for EgoSecure:
- Firewall: Open ports 1434/udp and 1434/tcp and set the SQL Browser service to Start Automatically.
- Firewall: Allow the application for incoming connections. The SQL server executable file can usually be found at %ProgramFiles%\Microsoft SQL Server\<name of instance>\MSSQL\Binn\sqlservr.exe.
- Assign the dbcreator server role for the SQL user used for the EgoSecure installation. After the installation, the dbowner server role can be assigned instead.
Microsoft SQL Express always uses a named instance.
Logging in to the database
| Database authentication via a mixed mode: | To select the mixed mode as the authentication method during the database installation, perform a custom installation depending on the version number, or customize the authentication method in the SQL Installation Center later. |
| Database authentication via Windows user account: | To login to the database using a Windows user account, specify an authorized Windows user during the EgoSecure Server installation. For details, see Windows authentication. |