- 19 Mar 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
Cannot install Pharos Uniprint: Unable to open a connection to SQL Server. Check that your SQL Server service is started. The Pharos Database cannot be installed with the current settings.
- Updated on 19 Mar 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
Cannot install Pharos Uniprint: Unable to open a connection to SQL Server. Check that your SQL Server service is started. The Pharos Database cannot be installed with the current settings.
I am getting an error when attempting to connect to the Pharos database server when installing Uniprint
ERROR: Cannot connect to <server>. Login failed for user 'sa' when logging into SQL Server using Microsoft SQL Server Management Studio.
Uniprint must be installed on a SQL Server that is configured for 'mixed mode' access. This allows both Windows domain users and SQL logins to access the database.
To resolve, log into the SQL Server as the administrative Microsoft domain account credential and:
Right-click the server name.
Choose Properties (at the bottom of the shortcut list).
Click the Security option.
Select "SQL Server and Windows Authentication" under "Server authentication." Click OK.
Restart the SQL Server service as directed by Management Studio.