Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > MOM 2005 Reporting on SQL2005 installation problem
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 5th August 07:55
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem



I have a similar problem as Morthy (MOM Reporting inst problem 5/7/2006) had.
I have no problem to open SQL 2005 Reports Home (https) page with IE 6.0,
but I have an errors:

Unable to contact the Microsoft SQL Server Reporting Services server
via Web
Service
if I try to configure pages manually, or

Unable to contact the Microsoft SQL Server Reporting Services server
via WMI
if I try to do it automatically.

I tried all the combinations you advice, of cource, but it still does not
work.
As Morthy I have no problems with SQL 2000 SP4 and Reporting Services SP2.

Could you help?

Cas


--
cas
  Reply With Quote


  sponsored links


2 5th August 07:55
pete zerger
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem



Hello cas,

Two things come to mind:

Be sure to provide the Reports and ReportServer directories when prompted
(dont auto-dectect).

Disable loopback checking as follows:

1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Contro l\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer


Regards,


Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailtoete.zerger@gmail.com

c> I have a similar problem as Morthy (MOM Reporting inst problem
c> 5/7/2006) had. I have no problem to open SQL 2005 Reports Home
c> (https) page with IE 6.0, but I have an errors:
c>
c> Unable to contact the Microsoft SQL Server Reporting Services server
c> via Web
c> Service
c> if I try to configure pages manually, or
c> Unable to contact the Microsoft SQL Server Reporting Services server
c> via WMI
c> if I try to do it automatically.
c> I tried all the combinations you advice, of cource, but it still does
c> not
c> work.
c> As Morthy I have no problems with SQL 2000 SP4 and Reporting Services
c> SP2.
c> Could you help?
c>
c> Cas
c>
  Reply With Quote
3 5th August 07:55
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hello Pete,

Thanks,
After I have chnged the registry key I could start the installation, but
then I have the same error Morty had:

Product: Microsoft Operations Manager 2005 Reporting -- Error 25310. Failed
to create data source for Data Warehouse. An exception occurred. Check that
you can access the SQL Services Reporting Server from this machine. Error
Code: -2147467259 (Unspecified error).


Could you help?

--
cas
  Reply With Quote
4 5th August 07:55
pete zerger
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hello cas,

There was a good thread quite recently on this error as well, with some additional
KBs to help. The loopback was the first step.

check this discussion
http://groups.google.com/group/microsoft.public.mom.setup_upgrade/browse_thread/thread/8e9cc923c0a4eeb/848823fb29ea1fb8?lnk=st&q=Error+25310.+Failed+to+create+data+source+for+Data+Warehouse&rnum=2&hl=en#848823fb29ea1fb8

which references the following KBs with additional steps that should assist.
http://support.microsoft.com/Default.aspx?kbid=898921
http://support.microsoft.com/kb/896861/


Regards,


Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailtoete.zerger@gmail.com

c> Hello Pete,
c>
c> Thanks,
c> After I have chnged the registry key I could start the installation,
c> but
c> then I have the same error Morty had:
c> Product: Microsoft Operations Manager 2005 Reporting -- Error 25310.
c> Failed to create data source for Data Warehouse. An exception
c> occurred. Check that you can access the SQL Services Reporting
c> Server from this machine. Error Code: -2147467259 (Unspecified
c> error).
c>
c> Could you help?
c>
  Reply With Quote
5 13th August 13:25
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hello Pete,

Thanks!
I tried it with clean boot, but it still das not work.
I get the same installation error.

If you have any idea....?

--
cas
  Reply With Quote
6 16th August 09:47
wilson sekigutiz)l¢tž’(.¶b±Ë¬²*²hœ®‹(~×(
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hi CAS,

I got the same error as you.
I installed the MOM reporting using the following command:

msiexec /i momreporting.msi DB_SIZE=10000 SQLSVR_INSTANCE=<Report
servername> TASK_USER_ACCOUNT=<user> TASK_USER_PASSWORD=<Passwrord>
TASK_USER_DOMAIN=<domain> REPORTING_USER=<user>
REPORTING_PASSWORD=<Passwrord> REPORTING_DOMAIN=<domain>
MOM_DB_SERVER=<OnePoing DB servername> AUTOMATICALLY_DETECT_ROSETTA_VDIRS=0
PREREQ_COMPLETED=1 REPORT_SERVER_VDIR=ReportServer
REPORT_MANAGER_VDIR=Reports DATA_DIR=<path for systemcenterreporting db>
log_dir=<path for systemcenterreporting log> /qn /l reporting.log

check the reporting.log file for installation details.

Regards,
Wilson

"cas" escreveu:
  Reply With Quote
7 16th August 09:47
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hi,

Thanks!

I've tried it but it does not work. I have the same error. The setup can't
connect to the Report Server.

Regards,
--
cas
  Reply With Quote
8 16th August 09:47
pete zerger
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hello cas,

Are you both using an SSL certificate on your reporting server?

Regards,


Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailtoete.zerger@gmail.com

c> Hi,
c>
c> Thanks!
c>
c> I've tried it but it does not work. I have the same error. The setup
c> can't connect to the Report Server.
c>
c> Regards,
c>
  Reply With Quote
9 16th August 09:47
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hello Pete,

I use the SSL certificate on the report server, but I have tested the
installation without the SSL certificate, too. It has not worked.

Regards,
--
cas
  Reply With Quote
10 16th August 09:47
pete zerger
External User
 
Posts: 1
Default MOM 2005 Reporting on SQL2005 installation problem


Hello cas,

Are you still fighting this problem, or did you resolve? If so, what was
the fix?

Regards,


Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMResources.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailtoete.zerger@gmail.com

....or find me in the forums at http://momcommunity.com

c> I have a similar problem as Morthy (MOM Reporting inst problem
c> 5/7/2006) had. I have no problem to open SQL 2005 Reports Home
c> (https) page with IE 6.0, but I have an errors:
c>
c> Unable to contact the Microsoft SQL Server Reporting Services server
c> via Web
c> Service
c> if I try to configure pages manually, or
c> Unable to contact the Microsoft SQL Server Reporting Services server
c> via WMI
c> if I try to do it automatically.
c> I tried all the combinations you advice, of cource, but it still does
c> not
c> work.
c> As Morthy I have no problems with SQL 2000 SP4 and Reporting Services
c> SP2.
c> Could you help?
c>
c> Cas
c>
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666