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