Installing SCOM 2012 on SQL cluster
Good day, Trying to install System Center Operations Manager 2012, checked all requirements and start installation. on step: Configure the Operational database, i receive some errors: server and instance name: mssqlsrv02\SC 1433 database: OperationsManager size: 2000 data file folder: ( path on SQL Cluster) J:\Data\MSSQL10_50.SC\MSSQL\DATA\ Error: (The Data file folder location does not contain enough disk space for a database of this size.) log file folder: J:\Log\MSSQL10_50.SC\MSSQL\Log Error: (The Log file folder location does not contain enough disk space for a database of this size. The required disk space for the log file is 50% of the database size.) how can I fix this, when I got 50 gb size for DB and 30gb for logs.. ?
May 10th, 2012 7:52am

Hi It might be a misleading error message ... a couple of things to check: 1) Check the port that SQL is using. You have stated port 1433 yet this is not a default instance. Is it definitely using port 1433? SQL is definitely detected ok? 2) What size are you setting the files to? Is it 2000? Can you try and leave the sizes on their default settings for the install. If the install does complete, then you can change the size in SQL Management Studio. Cheers Graham Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 3:53pm

Hi It might be a misleading error message ... a couple of things to check: 1) Check the port that SQL is using. You have stated port 1433 yet this is not a default instance. Is it definitely using port 1433? SQL is definitely detected ok? 2) What size are you setting the files to? Is it 2000? Can you try and leave the sizes on their default settings for the install. If the install does complete, then you can change the size in SQL Management Studio. Cheers Graham Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
May 10th, 2012 3:53pm

One more thing Is mssqlsrv02 is a cluster node or physical node? also check whether DB server is open the port UDP 1434. Moreover, it is not recommend to install operation database and data warehouse on single cluster for active-passive cluster. Roger
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 5:46pm

One more thing Is mssqlsrv02 is a cluster node or physical node? also check whether DB server is open the port UDP 1434. Moreover, it is not recommend to install operation database and data warehouse on single cluster for active-passive cluster. Roger
May 10th, 2012 5:46pm

Graham Davies, checked port and changed to 50002, same picture changed size to default 1000mb, and again nothing.. microsoft hopeless guy, yes mssqlsrv02 its a cluster node you are right. Cannot connect on 1434, should i? It's not recommended, hmm.. I didn't see that post, anyway why cant I use it.. trying to save my company money using sql cluster.. (c) said guy with full pack of system center components.. :P
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 10:12pm

Graham Davies, checked port and changed to 50002, same picture changed size to default 1000mb, and again nothing.. microsoft hopeless guy, yes mssqlsrv02 its a cluster node you are right. Cannot connect on 1434, should i? It's not recommended, hmm.. I didn't see that post, anyway why cant I use it.. trying to save my company money using sql cluster.. (c) said guy with full pack of system center components.. :P
May 10th, 2012 10:12pm

If you are trying to share the SQL cluster with other system center components then there are some capability considerations: http://nocentdocent.wordpress.com/articles-and-series/planning-sql-server-for-system-center-2012/ http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_ClusterConfig I'd be careful on hosting the databases within the same SQL instance (I note it is named SC), for a number of reasons: 1) Some components don't work together. Reporting Services for SCOM and SCSM + SQL RS is not cluster aware. 2) Performance. Service Manager in particular can be resource intensive and also SCOM, especially with APM and network device monitoring Can you try using a local disk to see if it really is disk issue. You don't need to install - just see if you get the same error if you choose another drive. If you do then I suspect that it is a firewall issue as you are using a named instance: http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_Firewall Operational database SQL Server database server 1433/TCPIf using a named instance, add. 1434/UDP Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2012 9:55am

If you are trying to share the SQL cluster with other system center components then there are some capability considerations: http://nocentdocent.wordpress.com/articles-and-series/planning-sql-server-for-system-center-2012/ http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_ClusterConfig I'd be careful on hosting the databases within the same SQL instance (I note it is named SC), for a number of reasons: 1) Some components don't work together. Reporting Services for SCOM and SCSM + SQL RS is not cluster aware. 2) Performance. Service Manager in particular can be resource intensive and also SCOM, especially with APM and network device monitoring Can you try using a local disk to see if it really is disk issue. You don't need to install - just see if you get the same error if you choose another drive. If you do then I suspect that it is a firewall issue as you are using a named instance: http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_Firewall Operational database SQL Server database server 1433/TCPIf using a named instance, add. 1434/UDP Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
May 11th, 2012 9:55am

ElHasuel with refer to technet document http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_ClusterConfig, it is not recommend, although it is possible, for install operation database and data warehouse on single cluster for active-passive cluster. Roger
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2012 12:45pm

ElHasuel with refer to technet document http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_ClusterConfig, it is not recommend, although it is possible, for install operation database and data warehouse on single cluster for active-passive cluster. Roger
May 11th, 2012 12:45pm

ElHasuel, Are you by chance using NTFS mount points on your cluster? I am running in to a similar issue. The installer goes out and checks how much space is available on the SQL Server, but it seems the installer is not mount-point aware. I have over 200GB free on my mounted Data lun, but only 1GB free on the root volume.
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2012 6:36pm

ElHasuel, Are you by chance using NTFS mount points on your cluster? I am running in to a similar issue. The installer goes out and checks how much space is available on the SQL Server, but it seems the installer is not mount-point aware. I have over 200GB free on my mounted Data lun, but only 1GB free on the root volume.
May 11th, 2012 6:36pm

dunno, I have a lot of free space in my root volume like 50Gb in data and 30Gb logs, correct was that Ops Mgr don't work with active passive cluster, that was I used.. yesterday I installed local sql and installation completed successfully.
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2012 12:53am

dunno, I have a lot of free space in my root volume like 50Gb in data and 30Gb logs, correct was that Ops Mgr don't work with active passive cluster, that was I used.. yesterday I installed local sql and installation completed successfully.
May 12th, 2012 12:53am

OpsMgr works fine with an active \ passive cluster - this is a configuration issue in your environment. If you want to continue to troubleshoot then please reopen the thread. Regards GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2012 5:23am

OpsMgr works fine with an active \ passive cluster - this is a configuration issue in your environment. If you want to continue to troubleshoot then please reopen the thread. Regards GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
May 12th, 2012 5:23am

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

Other recent topics Other recent topics