FIX2.03.03 · Released 30 October 2015

FIXfinPOWER Connect

Released in

2.03.03

30 October 2015

1. Opened23 Sep
2. Closed1 Oct
3. Released30 Oct

Article 13311 Job J016274

SQL Server Databases; cannot open a database in Exclusive mode

Cannot open a SQL Server database in Exclusive mode.

finPOWER Connect always fails with "Failed to open Database '[database name]'. Failed to open database. The Database cannot be opened in Exclusive mode since other Users are currently connected to it.".

Added new functionality for SQL Server databases to detect if the user has permission "VIEW SERVER STATE". If they do not have rights to this permission, then a database cannot be opened in exclusive mode - as finPOWER Connect cannot determine if other users have the database open.

Note, this also means the Tools, Database, View Database Users and Locks will now return an error message.