Hi all,Please provide any link or procedure for installing scom 2007 on windows server 2008 r2 where SQL is at remote machine. There are plenty of articles on single machine installations, but not much with remote sql.1. SQL 2005 Enterprise Edition is installed on Windows Server 2008 R2 - Machine 1 2. I want to install SCOM 2007 on Windows Server 2008 r2 - Machine 2kindly, share system requirements and step by step procedure.

Hi1) Install Operations Manager database on SQL Server2) Install Root Management Server on seperate server3) Install Operations Manager datawarehouse on SQL ServerYou can see step by step for different scenarios here:http://technet.microsoft.com/en-gb/library/bb432137.aspxIf you haven't installed SQL 2008 on Windows 2008 R2 before then be aware that it doesn't work- you need to slipstream SQL 2008 SP1 first.http://support.microsoft.com/kb/955725CheersGrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

thanks for quick response.can I install or create database through createdbwizard?when i try to install RMS on separate server, the prerequisite chcecker fails as it looks for sql on the local server and it is clearly not there, so cannot go forward

When you run the pre-requisite check on the RMS, deselect the options you don't want. E.g. database \ reporting .. a few steps later it will ask you for the name of the remote SQL Server.Kevin Holman discusses the pros and cons of CreateDB wizard here:http://blogs.technet.com/kevinholman/archive/2008/05/03/dbcreatewizard-or-just-run-good-old-setupom-exe-which-should-i-use-to-install-the-database-component-of-opsmgr.aspxCheersGrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

probably there is something wrong with the media or what, but when I run the setup, it always fails saying sql is not installed and it never gives an option to select or deselect any option?can you provide little details on system requirements or guide to a link. really appreaciate your quick responses. thanks.

I think you are missing it .. from here - http://technet.microsoft.com/en-gb/library/dd789046.aspx1) Make sure you have installed the OperationsManager database locally on the SQL Server first.2) Installing the RMS. On your installation media, start SetupOM.exe. This starts the System Center Operations Manager2007 R2 Setup Wizard on the Start page. Under the Install heading, click Install Operations Manager 2007 R2. This starts the Operations Manager2007 R2 Setup Wizard. On the Welcome page, click Next. On the End User License Agreement page, select the I accept the terms in the license agreement option, and then click Next. On the Product Registration page, enter the appropriate values in the User Name and Organization fields. Enter your 25-digit CD Key, and then click Next. On the Custom Setup page, leave the management server and User Interfaces options set to This component, and all dependent components, will be installed on the local disk drive. Set the Database, Command Shell and Web Console components to This component will not be available, accept the default installation location, and then click Next. On the SQL Server Database Instance page, type the SQL Server name and database instance in the SQL Database Name box. This is in the format of SQL Server\SQL Instance. If the SQL Server database was installed in the default instance, you only need to enter the SQL Cluster name that was created when you installed SQL Server2008 in the cluster. Check that the SQL Database Name field reads OperationsManager. Check that the SQL Server Port field has the value of 1433 Click Next. On the Management Server Action Account page, accept the default Domain or Local Computer Account option, enter the credentials of the MSAA, and then click Next. By using a domain-based account, it will be much easier to perform discovery and push agent installation later on than if you chose the Local System account. On the SDK and Config Service Account page, select the Domain or Local Account option, enter the credentials for the Data Access and Config service account, and then click Next. Note In this configuration, the account must be a domain account, because reporting is installed on a separate server. This account must have permissions on the reporting system. Note If you receive an Account Verification Error when you click Next, it is most likely that you mistyped the credentials or the SDK and Config service account was not added to the local Administrators group. On the Customer Experience Improvement Program page, optionally indicate whether you want to join this program, and then click Next. On the Microsoft Update page, optionally indicate whether you want to use the Microsoft Update services to check for updates, and then click Next. On the Ready to Install the Program page, click Install when you are ready for the installation to proceed. On the Completing the System Center Operations Manager2007 R2 Setup Wizard page, clear the Start the Console check box, ensure that the Back up Encryption Key check box is selected, and then click Finish. The Encryption Key Backup or Restore Wizard will now launch. Important Even though the Operations console has been installed, do not launch the console at this point. Clear the Launch the Operations Console check box to prevent the Operations console from launching. Note If setup fails, it provides you with a value to search on and a link to open the setup log. On the Introduction page of the Encryption Key Backup or Restore Wizard, click Next. On the Backup or Restore? page, select Backup the Encryption Key option, and then click Next. On the Provide a Location page, specify a valid path and file name for the encryption key and click Next. On the Provide a Password page, enter a password to secure the encryption key backup file and click Next to start the backup process. You will be prompted for this password when you restore the RMS encryption key later in this procedure. You should see the Secure Storage Backup Complete page. Click Finish. View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

yes, probably I am missing. I will definately try in the morning and let you know. Thanks alot. God Bless you. if you could have guided me to system requirements for server 2008 as well that would have been nicer, but you have already pointed me into the right direction, so thanks.

Here goes:Powershell is part of windows 2008 and I think WSManagement 1.1 is as well (though it might be it is part of R2). ASP.Net and .Net 3 are roles \ features of Windows 2008 and can be installed from the Server Management window.Kevin Holman has a couple of more detailed walk throughs that can help:http://blogs.technet.com/kevinholman/archive/2008/09/24/installing-the-web-console-on-a-2008-management-server-using-windows-authentication.aspxhttp://blogs.technet.com/kevinholman/archive/2008/09/26/how-to-install-iis-on-server-2008-to-support-opsmgr-web-console-and-reporting.aspxCheersGrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

thank s alot once again. I will let you know in 4-5 hours. I hope you will be around.

I HAVE INSTALLED THE DATABASE ON THE DATABASE SERVER.I get the following error when i am installing scom on server 2008"setup cannot locate the sc database"the sql is installed in the default instance i am defining sql as SERVER_NAME\MSSQLSERVERThe account that i am logged in with is a dbowner of OperationsManager Database and sysadmin on SQL Server, however, i have not made it local administrator?any clues?

Just use ServerName when you specify the sql server .. no need for \mssqlserver for a default instance.To ensure permissions aren't a problem, make the account you are using to do the install a sysamdinor log on to the RMS as the SDK account to install the RMS .... There are the permissions you need:http://systemcentersolutions.wordpress.com/category/security/CheersGrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

i have moved forward by just defining the server name as my instance is default.do i need to have dbowner on OperationsManager Database if I have sysadmin on teh sql server?

If you are a sysadmin then that will work.But I would log on to the RMS as the SDK account you have created. Then install the RMS while logged in as the SDK account.CheersGrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

the account that i logged in with is scom administrative account that is added in the global security group which is being used as operations manager administrators group - is there something wrong with this routine?During installation, it gave warning about health service that it could not start - is this normal? now, the health service is started and working fine.After installation, i added the machines that i want to monitor - which was step 1.after that it prompted for import of management pack which i am importing now from the media - is this normal.I dont see any server 2008 management packs - is this normal? do i need to download the server 2008 management pack?

the account that i logged in with is scom administrative account that is added in the global security group which is being used as operations manager administrators group - is there something wrong with this routine?During installation, it gave warning about health service that it could not start - is this normal? now, the health service is started and working fine.After installation, i added the machines that i want to monitor - which was step 1.after that it prompted for import of management pack which i am importing now from the media - is this normal.I dont see any server 2008 management packs - is this normal? do i need to download the server 2008 management pack? With questions like those - I honestly and openly recommend you stop messing with an install or deployment, and read through ALL the published documentation. You need a much deeper understanding of how OpsMgr works before you get to the point of deploying and asking these questions. This type of information is readily covered.I recommend you start with the support config, deployment, design, concepts, security. From here: http://technet.microsoft.com/en-us/opsmgr/bb498235.aspxWhen you finish reading that material, then I'd recommend coming back here if you get stuck somewhere.

I also need to use a remote SQL Server. When we talked through the design with Microsoft they suggested having the Operations Manager database run on one SQL Server and the Data Warehouse database run on another. Is this a valid setup, will i have an opportunity to tell the install where each one is?

I have already created the SCOM OperationsManager and OperationsManagerDW database in SQL Server 2008 R2 using the steps in KB2425714, when I installed the SCOM 2007 Reporting in the remote VM with SQL Server 2008 R2 installed. The SetupOM.exe hang during after the step of "SQL Server Reporting Services Instance". The Windows Applications Event Log shown the error of "Report Server Windows Service (SCOM_DB) cannot connect to the report server database." How do I resolve the problem ?

The problem was finally resolved after consulting with Microsoft Premier Service. The Microsoft engineer found that my SQL Server 2008 R2 named instance contains an underscore (_) character which is NOT supported. After I re-install the SQL Server 2008 R2 and create a named instance without the underscore (_) character, I was able to install the System Center Operations Manager 2007 R2 Reporting component.