I am attempting to install the 5.2 CSA MC on a Windows 2003 server w/ SQL 2005 locally.
The SQL server permissions are tightened down, but my login has complete access to the server (both OS and SQL server). I also followed the install instructions for the local install w/ SQL 2005.
However, during the install, after being questioned about rebooting after install, I get the following in my install log.
"[1-24-2008 08:54:50]: Setup is checking for the existence of other customer databases
[1-24-2008 08:54:50]: Resuming service MSSQLSERVER
[1-24-2008 08:54:50]: --8-- Start Process Log ==> net.exe
[1-24-2008 08:54:50]: The SQL Server (MSSQLSERVER) service was continued successfully.
[1-24-2008 08:54:50]: --8-- End Process Log ==> net.exe
[1-24-2008 08:54:50]: An ERROR occurred executing the database counting query. Work file 'dbcount.tmp' data conversion failed. First record should be numeric. Query result message is : < Msg 208, Level 16, State 1, Server SQLSERVER1, Line 1 Invalid object name 'sysdatabases'. >
[1-24-2008 08:54:57]: ERROR: Setup has encountered an error interpreting the results from an internal SQL query. Query result message is : < Msg 208, Level 16, State 1, Server SQLSERVER1, Line 1 Invalid object name 'sysdatabases'. > Setup will now abort.
Yes the default DB were present. The tightening is actually only tightening permissions to the SQL server and the databases.
After getting my DBAs to give my login and a domain service account, complete access to the SQL server, I was able to do the install.
However, once the install completed the services would not start. This is because they were starting under the Local System account. I changed the CSA services to use the aforementioned service account. The CSA services then worked correctly and are still working correctly. I have tightened down the database/SQL server access to those prescribed in the install guide.
But the root cause of my issue here was the "Local System" account being denied access to the SQL server.
Ya, that's about it. They are doing a good job though.
I've ran into this issue with other products as well. No vendor is prepared to install in a properly tightened down SQL environment. In this case, I have the CSA agent to protect the server. But on another product install the box was somewhat vulnerable.
DocumentationCode download linksGoalRequirementLimitationsSupported ISR
and UCS-E ModelSupported ISRG2 and UCS-E Blades:Supported ISR4K and
UCS-E Blades:Step by Step ConfigurationConfigure one of the connectivity
options to access the Cisco IMC from the n...
Firepower Threat Defense (NGFWv) on UCS E-series - Transparent Mode in
HA DocumentationCode download linksGoalRequirementLimitationsSupported
ISR and UCS-E ModelSupported ISRG2 and UCS-E Blades:Supported ISR4K and
UCS-E Blades:Step by Step ConfigurationCo...
Question I am currently unable to specify "crypto keyring" command when
configuring VPN connection on my cisco 2901 router. The following
licenses have been activated on my router :