| Author |
Message |
Kurlan
Guest
|
 Posted:
Mon Oct 24, 2005 12:51 pm Post subject:
MOM environment on 2 Machines |
|
|
Hi Champs!
I am trying to install MOM on one machine and want to connect to a backend
SQL Server.
The SQL server does not have ASP.NET nor does it have IIS installed.
The MOM server is running ASP.NET and IIS.
Questions: on what server do I install Reporting services.
And how do I, from the MOM server, contact the SQL server? |
|
| Back to top |
|
 |
Daniel Lai [MVP-Managemen
Guest
|
| Posted:
Mon Oct 24, 2005 4:51 pm Post subject:
Re: MOM environment on 2 Machines |
|
|
Hello,
Thank you for your posting!
For the SQL Server Reporting Service, Please install on the MOM Server.
Please also install MOM Reporting by using the MOM product disk on the MOM
Server.
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Kurlan" <Kurlan@discussions.microsoft.com> wrote in message
news:29F3D664-EBED-4873-8BC3-130B8E0E4553@microsoft.com...
| Quote: | Hi Champs!
I am trying to install MOM on one machine and want to connect to a backend
SQL Server.
The SQL server does not have ASP.NET nor does it have IIS installed.
The MOM server is running ASP.NET and IIS.
Questions: on what server do I install Reporting services.
And how do I, from the MOM server, contact the SQL server? |
|
|
| Back to top |
|
|
davidtyra@hotmail.com
Guest
|
| Posted:
Tue Oct 25, 2005 12:51 am Post subject:
Re: MOM environment on 2 Machines |
|
|
Kurlan,
The SQL Reporting Services can be installed on either server or a
different server entirely, but you will have to be running IIS on the
MOM Reporting Server. The Reporting database will have to go on a SQL
server obviously. SQL Reporting Services can then be installed on the
Reporting Database server or the Reporting Server or a separate server.
You will be asked the location of the Reporting Database server during
the setup of MOM Reporting. You will also have to supply two accounts
during setup: one used by the MOM Reporting Server to access the
database and the other to run the DTS job to transfer data from the
Onepoint database to the Reporting database.
Regards,
David Tyra |
|
| Back to top |
|
|
Kurlan
Guest
|
| Posted:
Wed Oct 26, 2005 4:51 pm Post subject:
Re: MOM environment on 2 Machines |
|
|
I have a SQL server, as I only want to use as a backend database server; I do
not want IIS on this server.
Then I have a MOM server with ASP.net, IIS but no SQL server.
If I try to install on SQL, I get error that there is no ASP.NET and no IIS.
If I try to install on MOM, I get error that there is no SQL server.
"davidtyra@hotmail.com" wrote:
| Quote: | Kurlan,
The SQL Reporting Services can be installed on either server or a
different server entirely, but you will have to be running IIS on the
MOM Reporting Server. The Reporting database will have to go on a SQL
server obviously. SQL Reporting Services can then be installed on the
Reporting Database server or the Reporting Server or a separate server.
You will be asked the location of the Reporting Database server during
the setup of MOM Reporting. You will also have to supply two accounts
during setup: one used by the MOM Reporting Server to access the
database and the other to run the DTS job to transfer data from the
Onepoint database to the Reporting database.
Regards,
David Tyra
|
|
|
| Back to top |
|
|
davidtyra@hotmail.com
Guest
|
| Posted:
Wed Oct 26, 2005 8:51 pm Post subject:
Re: MOM environment on 2 Machines |
|
|
Kurlan,
The MOM Reporting setup must be run on the SQL server where the
reporting database will be installed. During the installation, a
different server can be specified where SQL Reporting Services will be
installed. Note that SQL Reporting Services should already be installed
before running MOM Reporting setup. This server will need to be running
IIS and SQL Reporting Services. Unfortunately, ASP.NET is required for
MOM Reporting setup to succeed. However, you can remove ASP.NET after
the MOM Reporting installation is finished since the ASP.NET is only
used for the prerequisite check.
Regards,
David Tyra |
|
| Back to top |
|
|
Kurlan
Guest
|
| Posted:
Thu Oct 27, 2005 8:51 am Post subject:
Re: MOM environment on 2 Machines |
|
|
Many thanks for the answer!
"davidtyra@hotmail.com" wrote:
| Quote: | Kurlan,
The MOM Reporting setup must be run on the SQL server where the
reporting database will be installed. During the installation, a
different server can be specified where SQL Reporting Services will be
installed. Note that SQL Reporting Services should already be installed
before running MOM Reporting setup. This server will need to be running
IIS and SQL Reporting Services. Unfortunately, ASP.NET is required for
MOM Reporting setup to succeed. However, you can remove ASP.NET after
the MOM Reporting installation is finished since the ASP.NET is only
used for the prerequisite check.
Regards,
David Tyra
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in