Error Reporting service

hi
i am using SQL Server 2005 reporting services, i am getting an error message while deploying .rdl file error is:" Connection could not be established to remote server http://localhost/ReportServer"
Additional information is :
"client found response content type of text/html; charset=utf-8 but expected text/XML"Are you just trying to connect through the browser or to upload a file?|||Oh sorry I see. Are you able to connet to the instance through the browser?|||now its working properly, i have executed aspnet_regsql -ga aspnet commond on command prompt. But now while deploying i m getting another problem: "An internal error occurred on the report server. See the error log for more details."

Error renaming analysis services project

After renaming an analysis services project in bi development studio I receive the following error when deploying the project to SQL2005 AS (SP1):

Error 1 The 'Database' with 'ID' = 'AS UPC Chain Sales ' doesn't exist in the collection. 0 0

However the database is available on the server and can be processed and used. Any ideas how to fix this error?

Try to rename your live database on the Analysis Server using SQL Management Studio.

Then create a new project in BI Dev Studio. Select a project type as "Import Analysis Services 9.0 Database...". Follow the steps and get your project re-created based on the live version of the database.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks, Edward. Worked like a charm!

Error on Exporting Matrix to Excel

I get the following error when deploying my matrix to excel:
Reporting Services Error
----
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
Object reference not set to an instance of an object.
----
Microsoft Reporting Services
I was previously able to export(prior to SP1). Any thoughts?
Thanks,
ShaneCan you post the RDL? Can you view source on the error page and see the
stack trace?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shane Castle" <ShaneCastle@.discussions.microsoft.com> wrote in message
news:E54AA708-882E-4960-98AB-A16A0F34A27C@.microsoft.com...
>I get the following error when deploying my matrix to excel:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> ----
> Microsoft Reporting Services
> I was previously able to export(prior to SP1). Any thoughts?
> Thanks,
> Shane

Error Message When Deploying Report - The Item '/Data Sources'

Hi All,
I am wondering is someone can point me in the right direction,
I updated to the latest service pack on my Report Server Production Machine
and now when I attempt to deloy a report I get the following message
The Item '/Data Sources' already exists
I have tried everything I can think of to stop the message
~ Disabling and Enabling the OverwriteDataSources
~ Adding the Shared Datasource directly into the SQL frontend...
~ Running around like a chicken with no head
all seem to have the same effect...
Currently all other reports seem to work ok...
Has anyone got idea... apart from never ever ever updating to the latest
patches ;)
...Cheers
MattOn Sep 11, 10:26 pm, Aussie Matt
<AussieM...@.discussions.microsoft.com> wrote:
> Hi All,
> I am wondering is someone can point me in the right direction,
> I updated to the latest service pack on my Report Server Production Machine
> and now when I attempt to deloy a report I get the following message
> The Item '/Data Sources' already exists
> I have tried everything I can think of to stop the message
> ~ Disabling and Enabling the OverwriteDataSources
> ~ Adding the Shared Datasource directly into the SQL frontend...
> ~ Running around like a chicken with no head
> all seem to have the same effect...
> Currently all other reports seem to work ok...
> Has anyone got idea... apart from never ever ever updating to the latest
> patches ;)
> ...Cheers
> Matt
This might be overly simplistic, but have you tried to reselect the
datasource in the Report Mgr for the report? I have installed SP2 on a
couple different Report Servers w/no problems.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
Hi mate... yes that seems to be ok..
The report actually renders ok in the development environment...
I even tried creating a new report to see if that would overwrite the
existing shared data source but it has the same problemâ?¦. I am wondering if
it actually related to IIS6 somehow.. thou all the permissions look ok...
Thanks for the advice thou,
Cheers
Matt
"EMartinez" wrote:
> On Sep 11, 10:26 pm, Aussie Matt
> <AussieM...@.discussions.microsoft.com> wrote:
> > Hi All,
> > I am wondering is someone can point me in the right direction,
> > I updated to the latest service pack on my Report Server Production Machine
> > and now when I attempt to deloy a report I get the following message
> >
> > The Item '/Data Sources' already exists
> >
> > I have tried everything I can think of to stop the message
> > ~ Disabling and Enabling the OverwriteDataSources
> > ~ Adding the Shared Datasource directly into the SQL frontend...
> > ~ Running around like a chicken with no head
> >
> > all seem to have the same effect...
> >
> > Currently all other reports seem to work ok...
> >
> > Has anyone got idea... apart from never ever ever updating to the latest
> > patches ;)
> >
> > ...Cheers
> >
> > Matt
>
> This might be overly simplistic, but have you tried to reselect the
> datasource in the Report Mgr for the report? I have installed SP2 on a
> couple different Report Servers w/no problems.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hello Again,
Well I fixed it, not sure how / why it got screwy, to fix it I went to the
Reporting Services Configuration Manager
and reset the default properties for the the Report Server Virtual
Directory and Report Manager Virtual Directory... this seem to rectify
whatever the problem
was...
Cheers
Matt
"Aussie Matt" wrote:
> Enrique,
> Hi mate... yes that seems to be ok..
> The report actually renders ok in the development environment...
> I even tried creating a new report to see if that would overwrite the
> existing shared data source but it has the same problemâ?¦. I am wondering if
> it actually related to IIS6 somehow.. thou all the permissions look ok...
> Thanks for the advice thou,
> Cheers
> Matt
> "EMartinez" wrote:
> > On Sep 11, 10:26 pm, Aussie Matt
> > <AussieM...@.discussions.microsoft.com> wrote:
> > > Hi All,
> > > I am wondering is someone can point me in the right direction,
> > > I updated to the latest service pack on my Report Server Production Machine
> > > and now when I attempt to deloy a report I get the following message
> > >
> > > The Item '/Data Sources' already exists
> > >
> > > I have tried everything I can think of to stop the message
> > > ~ Disabling and Enabling the OverwriteDataSources
> > > ~ Adding the Shared Datasource directly into the SQL frontend...
> > > ~ Running around like a chicken with no head
> > >
> > > all seem to have the same effect...
> > >
> > > Currently all other reports seem to work ok...
> > >
> > > Has anyone got idea... apart from never ever ever updating to the latest
> > > patches ;)
> > >
> > > ...Cheers
> > >
> > > Matt
> >
> >
> > This might be overly simplistic, but have you tried to reselect the
> > datasource in the Report Mgr for the report? I have installed SP2 on a
> > couple different Report Servers w/no problems.
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> >
> >|||On Sep 12, 5:24 am, Aussie Matt <AussieM...@.discussions.microsoft.com>
wrote:
> Hello Again,
> Well I fixed it, not sure how / why it got screwy, to fix it I went to the
> Reporting Services Configuration Manager
> and reset the default properties for the the Report Server Virtual
> Directory and Report Manager Virtual Directory... this seem to rectify
> whatever the problem
> was...
> Cheers
> Matt
> "Aussie Matt" wrote:
> > Enrique,
> > Hi mate... yes that seems to be ok..
> > The report actually renders ok in the development environment...
> > I even tried creating a new report to see if that would overwrite the
> > existing shared data source but it has the same problem... I am wondering if
> > it actually related to IIS6 somehow.. thou all the permissions look ok...
> > Thanks for the advice thou,
> > Cheers
> > Matt
> > "EMartinez" wrote:
> > > On Sep 11, 10:26 pm, Aussie Matt
> > > <AussieM...@.discussions.microsoft.com> wrote:
> > > > Hi All,
> > > > I am wondering is someone can point me in the right direction,
> > > > I updated to the latest service pack on my Report Server Production Machine
> > > > and now when I attempt to deloy a report I get the following message
> > > > The Item '/Data Sources' already exists
> > > > I have tried everything I can think of to stop the message
> > > > ~ Disabling and Enabling the OverwriteDataSources
> > > > ~ Adding the Shared Datasource directly into the SQL frontend...
> > > > ~ Running around like a chicken with no head
> > > > all seem to have the same effect...
> > > > Currently all other reports seem to work ok...
> > > > Has anyone got idea... apart from never ever ever updating to the latest
> > > > patches ;)
> > > > ...Cheers
> > > > Matt
> > > This might be overly simplistic, but have you tried to reselect the
> > > datasource in the Report Mgr for the report? I have installed SP2 on a
> > > couple different Report Servers w/no problems.
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
I'm surprised that this resolved the issue; however, I'm glad you
fixed the problem. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||I just spent a considerable amount of time trying to debug this error, and in
the end it was a permissions problem. As a new employee I had been given
access to the Reports folder but not to the Data Sources folder.
Hopefully this note can save someone else some time (and frustration)
diagnosing this error.

Error message when deploying cube to remote server

Hello,

I created an account called sa2 to obtain access to create a datasource for the AdventureworksDW sample database on a remote server, and granted this user all rights on the database.

When I was ready to deploy the cube I typed in the machine name (sserver) in connection settings, and then deployed. However, I got an error:

"The connection either timed out or was lost."

I then tried:

sserver\sserver

but got:

"Error 1 The project could not be deployed to the 'sserver\sserver' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

Permissions issue for the sa2 account?

Are you trying to deploy from BIDS? Is the error message coming up during deployment or during processing?|||

Hello,

Yes, from Bids. Not sure at what point the error occurs, I select deploy, processing occurs and then the error message is displayed.

Since this post I dropped the firewall on the server, and the database seems to be ceated but errors occur, so deployment is not successful.

This link:

http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

is suggesting that I can only login with a Windows account.

|||You need a Windows Account with administrator access to the Analysis Server to deploy the database (not necessarily an Windows Administrator account). You can use a SQL Server login for the connection from Analysis Services to the relational engine.|||Make sure you used the same windows login with remote server, same username and same password. I think the problem was in authentication method.

Best regards,

Hery|||

Hello,

Thanks for the suggestions everyone. The computer from which I am trying to deploy does not login to the network, so I don't have a profile which I can apply to the database. As a workaround for now I will deploy to localhost.

Error message

Hi,

I keep getting this error message while creating and deploying my report. I already restart the SQL server services(MSSQLServer) a lot of times, it is still the same.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'AdventureWorks'. (rsErrorOpeningConnection)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I also got another error message while deploying my report.

The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)

Anybody knows how to solve this?

For the first error, try enabling named pipe for SQL server. Make sure you restart RS service after restarting SQL service.|||

I already tried that. Sometimes it works, but after a few minutes, it give me back the same error message or this:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)|||

Oh ... You need to fix "Initialization" first. I am surprised it worked for you at all. However, the error message doesn't make sense to me. Can you try resetting database connection from the config tool? Make sure every tab is green.

Perhaps the easiest solution is to reinstall RS.