We were getting below mention error while installing SmartAuditor on SQL 2008 cluster . Tried following CTX123288 but looks like some changes is required from SQL 2008 cluster prospective.
- All About Citrix Smartauditor App
- All About Citrix Smartauditor Workspace
- All About Citrix Smartauditor User
- All About Citrix Smartauditor Access
- All About Citrix Smartauditor Cloud
Sep 30, 2015 Record all dormant icl files to a text file and save for later use. Run REMOVEALL command to remove all session entries from the database. Note: Remember that, running REMOVEALL command does not remove the actual.ICL files from the file structure. Last updated: January 8, 2021. Refer to this table for product lifecycle dates. The Product Matrix table below provides information for Citrix products whose product lifecycle is governed by lifecycle phases.Product lifecycle milestones include Notice of Status Change (NSC), End of Sale (EOS), End of Maintenance (EOM) and End of Life (EOL). Citrix recommends you install the Session Recording Administration, Session Recording Agent, and Session Recording Player components on separate servers. The Session Recording Administration components include the Session Recording Database, Session Recording Server, and Session Recording Policy Console. Apr 02, 2019 LB on the Netscaler – Make sure to configure all 3 ports: HTTP-80 / HTTPS-443 / TCP-1801; The reg key to tell Session Recording to load balance HKLM Software Citrix SmartAuditor Server EnableLB=dword:1; SQL Permissions on the DB – Make sure to set all Server accounts with the dbowner membership on the database.
All About Citrix Smartauditor App
Symptoms
When opening the Citrix SmartAuditor Policy Console, the following error message appears:
“Unable to connect to the SmartAuditor Server. Ensure that the SmartAuditor Server is running.
Unable to load farm configuration.
An error occurred while accessing the SmartAuditor Database. More details about the error have been logged on the server.”
Citrix SmartAuditor Events like the one below appear:
Event Type: Error
Event Source: Citrix SmartAuditor Broker
Event Category: None
Event ID: 0
Date: 11/4/2009
Time: 6:52:51 PM
User: N/A
Computer: SMARTAUDITOR01
Description:
Exception caught while loading SmartAuditor Policy Console configuration file.
--- Exception Details ---
Type: System.Data.SqlClient.SqlException
Message: Cannot open database 'CitrixSmartAuditor' requested by the login. The login failed.
Login failed for user ‘CITRIXSMARTAUDITOR01$'.
Stack trace:
at SmAudDatabaseProxy.DatabaseProxy.get_DatabaseConnection()
at SmAudDatabaseProxy.DatabaseProxy.LoadPolicyConsoleConfigurationFile(Int16 policyType, Int64& configFileModifiedTimeUtcTicks, Int32& configFileFormatMajorVersion, Int32& configFileFormatMinorVersion, Byte[]& configFile)
at SmAudBroker.PolicyAdministration.LoadPolicyConsoleConfigurationFile(PolicyType policyType, Int64& configFileModifiedTimeUtcTicks, Int32& configFileFormatMajorVersion, Int32& configFileFormatMinorVersion, Byte[]& configFile)
After installing Citrix SmartAuditor, the following events are seen (usually at 30-second intervals) in the Application Event Logs.:
Event Type: Warning
Event Source: Citrix SmartAuditor Storage Manager
Event Category: None
Event ID: 0
Date: 11/4/2009
Time: 6:35:32 PM
User: N/A
Computer: SMARTAUDITOR01
Description:
Exception caught while establishing database connection.
--- Exception Details ---
Type: System.Data.SqlClient.SqlException
Message: Cannot open database 'CitrixSmartAuditor' requested by the login. The login failed.
Login failed for user 'CITRIXSMARTAUDITOR01$'.
Stack trace:
at SmAudDatabaseProxy.DatabaseProxy.get_DatabaseConnection()
at SmAudDatabaseProxy.DatabaseProxy.CheckSupportedSchemaVersion()
at SmAudDatabaseProxy.DatabaseProxy.TestConnection()
at SmAudStorageManager.DataQueueConsumer.WaitConnectDatabase()
ICA sessions are not being recorded and ICL files only appear for a short time and then disappear.
Cause
Probable causes can include the following:
• The computer account for the Citrix SmartAuditor Server does not exist in the SmartAuditor Database.
• The computer account has been deleted and re-created using the same name resulting in a new Security Identifier being issued by Windows Active Directory.
Resolution
The computer account for the Citrix SmartAuditor server must be created in the Citrix SmartAuditor Database.
1. Go to the Microsoft SQL Server and launch the Microsoft SQL Server Management Studio.
2. Under Object Explorer in the console, go to DatabasesCitrixSmartAuditorSchemas right-click and select New Schema.
2. A) Under Object Explorer in the console, go to DatabasesCitrixSmartAuditorSecuritySchemas right-click and select New Schema.
3. In the Schema name: field enter the computer name of the Citrix SmartAuditor Server in this format DomainMachine-Name$. For example, if the domain is Citrix and the hostname of the Citrix SmartAuditor server is SMARTAUDITOR01, then the entry should be: CITRIXSMARTAUDITOR01$. Note that this entry is not case-sensitive.
4. Leave the entry for Schema Owner field blank. This will be taken care of later when the user account is created. Click OK to continue.
5. Back in the SQL Server Management Studio console, under Object Explorer, go to DatabasesCitrixSmartAuditorUsers right-click and select New User.
All About Citrix Smartauditor Workspace
5. A) Back in the SQL Server Management Studio console, under Object Explorer, go to SecurityLogins right-click and select New Login...
6. The Database User – New dialog opens. Enter the computer account name (in the same format as used to create the Schema in step 3) for the User name, for the Login name, and for the Default Schema.
6. A) The Login – New dialog opens. Enter the computer account name (in the same format as used to create the Schema in step 3) for the Login name.
7. Under Owned Schemas, click on the check-box for the schema created for this computer account.
All About Citrix Smartauditor User
7. A) Now go to the CitrixSmartAuditor Database and expand to go to Security –> Users and Right click on the CITRIXSMARTAUDITOR01$ which you have created and go to Properties. Under Owned Schemas, click on the check-box for the schema created for this computer account.
8. Under Role Members, click on the db_owner role.
All About Citrix Smartauditor Access
The picture below shows the result of steps 6 through 8.
All About Citrix Smartauditor Cloud
9. Click OK to continue.
10. Go back to the Citrix SmartAuditor Server and restart the Citrix SmartAuditor Storage Manager Service.
11. Test by opening the Citrix SmartAuditor Policy Console and by launching ICA sessions that are known to fit the criteria set in the Citrix SmartAuditor Policy Console for a recorded session.