can we deploy the reports to SP2010 using sql 2005

Hi All,

Does any one have good blogs for creating different types of charts using SQL Server Business Intelligence Development Studio 2005 which pulls data from the sharepoint list and display in graphical format. iam new to SSRS.

Thanks in advance

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.

1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or  something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

Hi,

I am looking for suggestion on deploying;

1) Performance Point Scorecards, KPI's, Dashboard, Reports created using dashboard designer from one enviornment to another.

2) Performance Point Web Parts like KPI web part, scorecard web part and report web part.

3) Performance Point Data Sources

Does SharePoint Solution Package support this scenario? How will this work?

Our goal is to define all the configuration for each release which will include add new content, webe pages having various sharepoint web parts and update sharepoint content for future release.

Thank you for your input in advance.

Amit

Hello,

i want to deploy a Master Page as a Feature in Sharepoint 2010.
I followed the Steps in this Article, but i get some Errors.
http://www.sharepointchick.com/archive/2010/03/26/deploying-a-custom-master-page-in-sharepoint-2010.aspx

When i deploy the Solution in VS2010 and enter my SP Site, i get an Error: File not found.
I discover, that my sample.master File were not copied into the _catalogs/masterpage Directory.
When i copy the File manuell into this Directory, i can open my Site correctly, but in the Feature Overview my Feature is deactivated.
When i try to activate it, i get an Errormessage:
The specified File in this Modul section is already in place.
I renamed my sample.master File but is still the same Error.

Can anyone help me?

I have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.

These reports can be called succesfully from both the report manager and my asp.net website.

Everything has been working fine.

Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.

Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.

The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"

I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.

I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.

So I'm at a complete standstill and haven't a clue what to try next.

Has anyone come across this issue and if so how did you resolve it?

Thanks

Im attempting to create a sharepoint project, with one module containing a master page, stylesheet, theme and images to provide a clean, accessible and reuseable feature with this complete rebranding solution!

But im finding that i get an error when the deployment tries to activate the feature, i will want to move on from this when it finally works and create event recievers to setup the files to automatically install and use the template and themes files with a stylesheet.

Error: Error occurred in deployment step 'Activate Features': Feature with Id '{ID HERE}' is not installed in this farm, and cannot be added to this scope.