Showing posts with label situation. Show all posts
Showing posts with label situation. Show all posts

Wednesday, March 28, 2012

Reporting Services setup error 29528

Here’s my situation.At what must have been the last dialog of setup I clicked

Finish, then got this message:

SQL Server Setup was unable to install on your computer. SQL Setup has encountered a problem and will end.

The summary log indicates that only the setup of Reporting Services failed.Here’s the section of the log:

--

Machine: HERE

Product: Microsoft SQL Server 2005 Reporting Services

Product Version : 9.00.1399.06

Install: Failed

Log File: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_HERE_RS.log

Last Action: InstallFinalize

Error String: The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

Error Number: 29528

--

All other products seemed to install ok, appear on my menu, and start ok.My server is serving up SQL data to the website and various applications.

What should I do next?

After further research, I find that my configuration did not meet the requirements for a default Report Server Installation. See article ms143711. And now that the Database Engine has been installed, I had to use the filesonly option to install Reporting Services.

-r

|||Please open the IIS,and open the sub tree :application pool,and stop the Report Server .So ,Click Rerty,This error is didn't saw.

Reporting Services setup error 29528

Here’s my situation.At what must have been the last dialog of setup I clicked

Finish, then got this message:

SQL Server Setup was unable to install on your computer. SQL Setup has encountered a problem and will end.

The summary log indicates that only the setup of Reporting Services failed.Here’s the section of the log:

--

Machine: HERE

Product: Microsoft SQL Server 2005 Reporting Services

Product Version : 9.00.1399.06

Install: Failed

Log File: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_HERE_RS.log

Last Action: InstallFinalize

Error String: The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

Error Number: 29528

--

All other products seemed to install ok, appear on my menu, and start ok.My server is serving up SQL data to the website and various applications.

What should I do next?

After further research, I find that my configuration did not meet the requirements for a default Report Server Installation. See article ms143711. And now that the Database Engine has been installed, I had to use the filesonly option to install Reporting Services.

-r

|||Please open the IIS,and open the sub tree :application pool,and stop the Report Server .So ,Click Rerty,This error is didn't saw.

Reporting Services setup error 29528

Here’s my situation.At what must have been the last dialog of setup I clicked

Finish, then got this message:

SQL Server Setup was unable to install on your computer. SQL Setup has encountered a problem and will end.

The summary log indicates that only the setup of Reporting Services failed.Here’s the section of the log:

--

Machine: HERE

Product: Microsoft SQL Server 2005 Reporting Services

Product Version : 9.00.1399.06

Install: Failed

Log File: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_HERE_RS.log

Last Action: InstallFinalize

Error String: The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

Error Number: 29528

--

All other products seemed to install ok, appear on my menu, and start ok.My server is serving up SQL data to the website and various applications.

What should I do next?

After further research, I find that my configuration did not meet the requirements for a default Report Server Installation. See article ms143711. And now that the Database Engine has been installed, I had to use the filesonly option to install Reporting Services.

-r

|||Please open the IIS,and open the sub tree :application pool,and stop the Report Server .So ,Click Rerty,This error is didn't saw.

Wednesday, March 21, 2012

Reporting Services Login Issue

I have a client that has a unique situation. Here is the back ground
information:
A Reporting Services 2005 server in a DMZ. This server is not part of
any domain, only has local users.
A SQL Server with the Report Database and an Analysis Services Server
with the Cubes on which the reports are built are behind the
firewall. These servers are in a Windowss 2003 Domain using Domain
accounts for access.
The issue is getting the Report Server in the DMZ to successfully open
a report based on a Cube. Using a Standard SQL Server Login we can
successfully open a report from the Reporting Server in the DMZ that
uses a relational database behind the firewall. This works obviously
since we can use a Standard Login and not deal with the domain/no
domain issue.
When we try to setup a report that uses the CUBE, we can not get the
Domain Server to accept our "ghost" user we created. We create a
user, "reptusr" on the local server in the DMZ. We also created a
user, "reptusr" in the domain behind the firewall and gave that user
id access to the CUBE. This is not working.
I can't find a lot of information on this specific scenario so any
information anyone may have would be greatly appreciated!
Thanks in advance!
MartinDid you write full username (domain\reptusr)? Also, check Use as Windows
credentials when connecting to the data source in datasource properties.
Stjepan
<martinghale@.gmail.com> wrote in message
news:1170983260.446204.25060@.a75g2000cwd.googlegroups.com...
>I have a client that has a unique situation. Here is the back ground
> information:
> A Reporting Services 2005 server in a DMZ. This server is not part of
> any domain, only has local users.
> A SQL Server with the Report Database and an Analysis Services Server
> with the Cubes on which the reports are built are behind the
> firewall. These servers are in a Windowss 2003 Domain using Domain
> accounts for access.
> The issue is getting the Report Server in the DMZ to successfully open
> a report based on a Cube. Using a Standard SQL Server Login we can
> successfully open a report from the Reporting Server in the DMZ that
> uses a relational database behind the firewall. This works obviously
> since we can use a Standard Login and not deal with the domain/no
> domain issue.
> When we try to setup a report that uses the CUBE, we can not get the
> Domain Server to accept our "ghost" user we created. We create a
> user, "reptusr" on the local server in the DMZ. We also created a
> user, "reptusr" in the domain behind the firewall and gave that user
> id access to the CUBE. This is not working.
> I can't find a lot of information on this specific scenario so any
> information anyone may have would be greatly appreciated!
> Thanks in advance!
> Martin
>|||Thank you. Sorry for the delay in getting back. Was out sick.
We have tried that. Have tried everything it seems like. We simply
can not get the report or the Data Source to be able to use Windows
crendentials. Works perfect with SQL Server Login. Plus we are at a
disadvantage as our 'admins' won't actually give us access to the
servers to troubleshoot so we are currently building out a virtual
environment.
Thanks for the suggestion.
Martin

Tuesday, March 20, 2012

Reporting Services Key Management

I have a situation where I need to delete the keys from my SRS install and have new ones created. I see from here: http://msdn2.microsoft.com/en-us/library/ms162822.aspx

that I can use a -s switch but I don't have that. I have this installed on SQL 2000.

Here are the options I have:

Microsoft (R) Reporting Services Key Manager
Version 8.00.1038.00 x86

Extracts from the report server and applies to the report server the key used during encryption.

RSKeyMgmt [-e] [-a] [-d] [-r installationID] [-f file] [-p password] [-t]

-e extract Extracts a key from a report server instance
-a apply Applies a key to a report server instance
-d deletecontent Deletes all encrypted content from a report server
database
-r installationID Remove the key for the specified installation ID
-f file Full path and file name to read/write key.
-p password Password used to encrypt or decrypt key.
-t trace Include trace information in error message

I don't see a way to get the new ones created, if I use rskeymgmt.exe I see ways to extract the existing and apply an extracted key but nothing about creating new keys.

Anyone know how to create new keys and apply them to an exising install?

Joe

I am not too familar with RS2000, so try this at your own risk :). You can use -d, and then -r to remove the installation from RS catalog, then restart the RS service. This should create a new key for you. However, you'll loose the encrypted content.

Monday, March 12, 2012

Reporting Services Installation Problem

Hi,

Here's the situation:
* I had an older beta (beta 1) of RS installed on a machine at an earlier time.
* Someone manually deleted the RS files on the machine as opposed to a add/remove programs operation.
* I installed the RTM Reporing Services on the machine.
* I try to author a report and get the following message:

'The located assembly's manifest definition with name 'Microsoft.VisualStudio.Shell.Interop' does not match the assembly reference.'

I have removed VS 2003 and Reporting Services, and re-installed them numerous times, but still keep getting the same error message when I try to author a report.

Can anyone help?Which OS you are using...(Please dont tell me its XP:)..u r in trouble then)