Database status critical when viewed from secondary site
Hi,Inmy Config Manager console I can see that the Site Systems Status for my Primarysite is ok/green for all its roles, the SCCM database and the DB Transaction logs. When I expand the view in the console further I can check the Site System Status for my Secondary site also. All the roles are fine. However, the Database and Transaction Log items show upas Critical the Availability andDisk Total/Free columns are reported as Unknown.I've added the Secondary Site Server's computeraccount to Administrators group of the SQL Server and even made it a DB Owner in SQL. MyConfig Manager installation appears to be working perfectly so I am very confused as to why this is happening.Regards,Michael
November 11th, 2009 1:04pm

Is port 1433 open from the secondary to it's parent site?
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2009 1:09pm

Hi Eirik, yes I have verified 1433 is open to the Secondary.I checked the sitestat.log file on the secondary and I repeatedly get the following errors.CSql Error: Cannot find type data, cannot get a connection.SMS_SITE_SYSTEM_STATUS_SUMMARIZER11/11/2009 10:07:311016 (0x03F8)Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The operation completed successfully.SMS_SITE_SYSTEM_STATUS_SUMMARIZER11/11/2009 10:07:311016 (0x03F8)Michael
November 11th, 2009 1:17pm

I see this thread is quite old. Is the problem solved or do you still need help?
Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2010 3:36pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics