Do GFI products support the use of the SQL case sensitive installation mode?

The information in this article applies to:

• GFI FAXmaker for Exchange/SMTP 12
• GFI FAXmaker for Exchange/SMTP 14
• GFI LANguard 9.0
• GFI LANguard Network Security Scanner 5
• GFI LANguard Network Security Scanner 6
• GFI LANguard Network Security Scanner 7
• GFI LANguard Network Security Scanner 8
• GFI LANguard Security Event Log Monitor 5
• GFI MailArchiver for Exchange 2
• GFI MailArchiver for Exchange 3
• GFI MailArchiver for Exchange 4
• GFI MailArchiver for Exchange 5
• GFI MailArchiver for Exchange 6

Article ID: KBID002277

Query keywords: case sensitive, sql

During a custom install of Microsoft SQL it is possible to choose from several types of collation modes. The collation modes mainly refer to character sets used and the case sensitiveness behaviour. 

The GFI products need to be installed on a Microsoft SQL which is not installed in case sensitive mode.

More Information:

The Microsoft SQL server collation modes apply to all Microsoft SQL server objects including login names. In such cases if a user changes a property in the name and does not make EXACT character case matches, the GFI Products installed will fail since they would not find the resources required.

Notes:

• By default, Microsoft SQL server installs with case insensitive collation mode.
   
• Once installed, It is not possible to change the Microsoft SQL server collation mode easily. It requires a rebuild of the master database using advanced Microsoft SQL specific tools or methods. The best solution is to install another instance of Microsoft SQL Server (set to operate in insensitive collation mode).
   
• Information on how to install a named instance of Microsoft SQL 2000 can be found at: http://msdn2.microsoft.com/en-us/library/aa197928(SQL.80).aspx