How to solve the Cannot Generate SSPI Context error

If you get the Cannot Generate SSPI Context error from our Server Monitoring tool as shown in the figure below, we should use SQL Server Authentication instead of Windows Authentication as a login method.

To fix this problem, we need to create a new SQL Server account.

1. Run Microsoft SQL Server Management Studio.

2. Expand the Security item in Object Explorer and right-click Logins and choose New Login….

3. Enter an account name in the Login name field and choose SQL Server authentication. Then, enter a password for the account.

4. Uncheck the following options to set the password as you want:

Enforce password policy

Enforce password expiration

User must change password at next login

If the options are checked, you should the password according to security policy in Windows.

5. Choose BioStar from the Default database drop-down list.

6. Go to the Server Roles page and select sysadmin.

7. Go to the User Mapping page and choose BioStar and db_owner.

8. Go to the Status page and set Permission to connect to database engine to Grant and Login to Enabled.

12. If you succeed to connect to the database server, the account is successfully created. Run BioStar Server Config.

13. Choose Server Authentication and enter the ID and password. Before clicking Start, we should check if the port specified here matches the port of MS SQL Database Server.

14. Run SQL Server configuration manager.

15. Choose SQL Server Network Configuration and then Protocols for SQLEXPRESS. Then, double-click TCP/IP. You can see what number is set to TCP Dynamic Ports and type the number in the Port field in BioStar Server Config.

16. Before clicking Start in BioStar Server Config, make sure that the BSServer.exe process is not running (you can check this on Task Manager). If it's running, please kill the process or stop the service.