Reporting Services 2005 and SQL Server 2000

Can you use SQL Server Reporting Services that comes with SQL Server 2005 and
have that be the only thing that is installed on a SQL Server 2000 box? I
need to use reporting services with Whidbey but want to use them against a
SQL Server 2000 machine.
Thanks!Yes you can
It's the same format
"Raventhorn" <Raventhorn@.discussions.microsoft.com> a écrit dans le message
de news: 24F341CB-AFD9-4CE2-AF81-4D55C2521B73@.microsoft.com...
> Can you use SQL Server Reporting Services that comes with SQL Server 2005
> and
> have that be the only thing that is installed on a SQL Server 2000 box? I
> need to use reporting services with Whidbey but want to use them against a
> SQL Server 2000 machine.
> Thanks!

Reporting Services 2005 - Simple Q

Hi All,

We have an installation of 2005 on Win box. We have deployed reports in one folder Folder A and some reports in a subfolder of A called B.

Now we have put integrated windows authentication. I have edited the security of sub folder B and just provided login to User X. The main folder A has both users X and Y as users, X being content manager and Y being Browser. But whenever I login as User Y I still see the sub folder.

Is there any way to hide that folder?

Also to mention that both users X and Y are part of BUILT IN \ Adminsitrators group

Thanks

Manbish

This is behavior is because we try to prevent you from locking yourself out of the report server.

It is documented here: http://msdn2.microsoft.com/en-us/library/ms157255.aspx

Hope this helps,

-Lukasz

Reporting Services 2000 SP2 fails

I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.

When I try to run the SP (on server X), I get the following message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITY\NETWORK SERVICE'.

Hi,

Try to change the SSRS service account to a domain account, and add this account to your SSRS database server and map to your SSRS database. Also, you should add this account to the RsExecRole role.

I hope it helps.

Regards,

Janos

Reporting Services $$$

It is licensed the same as SQL Server so if you run it on the same box (web
service + db) as SQL then there is no additional cost above the SQL license
cost. If you install the web service on a separate server then you need a
SQL license for it in addition to the one on the server hosting the report
server databases.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
message news:8B63E947-80D1-490B-ACFA-29D6AD429E3B@.microsoft.com...
> Is there a cost associated with SQL 2000 Reporting Services, i.e., does
> one
> have to purchase it or does it come as a tool with SQL?
> Thanks!
> EleanorThanks!
"Jasper Smith" wrote:

> It is licensed the same as SQL Server so if you run it on the same box (we
b
> service + db) as SQL then there is no additional cost above the SQL licens
e
> cost. If you install the web service on a separate server then you need a
> SQL license for it in addition to the one on the server hosting the report
> server databases.
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
> message news:8B63E947-80D1-490B-ACFA-29D6AD429E3B@.microsoft.com...
>
>|||Where does one find the Reporting Tools? Are they on the SQL CD? Also, I
want to pull reports from another server (SharePoint). Does the Reporting
Tools have to reside on the same server?
Sorry, I am a newbie, as you can tell.
-Eleanor
"Jasper Smith" wrote:

> It is licensed the same as SQL Server so if you run it on the same box (we
b
> service + db) as SQL then there is no additional cost above the SQL licens
e
> cost. If you install the web service on a separate server then you need a
> SQL license for it in addition to the one on the server hosting the report
> server databases.
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
> message news:8B63E947-80D1-490B-ACFA-29D6AD429E3B@.microsoft.com...
>
>|||Is there a cost associated with SQL 2000 Reporting Services, i.e., does one
have to purchase it or does it come as a tool with SQL?
Thanks!
Eleanor|||It is licensed the same as SQL Server so if you run it on the same box (web
service + db) as SQL then there is no additional cost above the SQL license
cost. If you install the web service on a separate server then you need a
SQL license for it in addition to the one on the server hosting the report
server databases.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
message news:8B63E947-80D1-490B-ACFA-29D6AD429E3B@.microsoft.com...
> Is there a cost associated with SQL 2000 Reporting Services, i.e., does
> one
> have to purchase it or does it come as a tool with SQL?
> Thanks!
> Eleanor|||Thanks!
"Jasper Smith" wrote:

> It is licensed the same as SQL Server so if you run it on the same box (we
b
> service + db) as SQL then there is no additional cost above the SQL licens
e
> cost. If you install the web service on a separate server then you need a
> SQL license for it in addition to the one on the server hosting the report
> server databases.
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
> message news:8B63E947-80D1-490B-ACFA-29D6AD429E3B@.microsoft.com...
>
>|||Where does one find the Reporting Tools? Are they on the SQL CD? Also, I
want to pull reports from another server (SharePoint). Does the Reporting
Tools have to reside on the same server?
Sorry, I am a newbie, as you can tell.
-Eleanor
"Jasper Smith" wrote:

> It is licensed the same as SQL Server so if you run it on the same box (we
b
> service + db) as SQL then there is no additional cost above the SQL licens
e
> cost. If you install the web service on a separate server then you need a
> SQL license for it in addition to the one on the server hosting the report
> server databases.
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
> message news:8B63E947-80D1-490B-ACFA-29D6AD429E3B@.microsoft.com...
>
>|||Reporting Services is a separate CD.
[url]http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx[/
url]
Reporting Services can pull from almost any data source, local or remote.
It can even combine data from multiple sources.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
message news:7FBB43BF-C798-4617-94C8-63BCA3CBB5AC@.microsoft.com...[vbcol=seagreen]
> Where does one find the Reporting Tools? Are they on the SQL CD? Also, I
> want to pull reports from another server (SharePoint). Does the Reporting
> Tools have to reside on the same server?
> Sorry, I am a newbie, as you can tell.
> -Eleanor
> "Jasper Smith" wrote:
>|||Reporting Services is a separate CD.
[url]http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx[/
url]
Reporting Services can pull from almost any data source, local or remote.
It can even combine data from multiple sources.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
message news:7FBB43BF-C798-4617-94C8-63BCA3CBB5AC@.microsoft.com...[vbcol=seagreen]
> Where does one find the Reporting Tools? Are they on the SQL CD? Also, I
> want to pull reports from another server (SharePoint). Does the Reporting
> Tools have to reside on the same server?
> Sorry, I am a newbie, as you can tell.
> -Eleanor
> "Jasper Smith" wrote:
>|||Thank you for the response. I need this yesterday, as is the case with
everything in IT :-) My company has a volumn software license and MSDE. Is
this tool contained within any of these sources?
Thanks!
-Eleanor
"Geoff N. Hiten" wrote:

> Reporting Services is a separate CD.
> http://www.microsoft.com/sql/prodin...nt.mspx

> Reporting Services can pull from almost any data source, local or remote.
> It can even combine data from multiple sources.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Eleanor, MCSE/MCT" <EleanorMCSEMCT@.discussions.microsoft.com> wrote in
> message news:7FBB43BF-C798-4617-94C8-63BCA3CBB5AC@.microsoft.com...
>
>sql

Reporting Services - Tools

Hi there,
I am new to MS Reporting Services and would like to know if there is a way to add more controls to the tool box in vs .net to put variety of controls on the rdl reports. for instance by default the toolbox doesn't have a dropdownlist control. If there is a way of doing so, would someone please tell me how?

Thank you.
Because Reporting Services is output independent and we don't have an eventing model, you can't use regular VB or ASP controls on the page. We are looking at ways of making this possible in the future.

In SQL 2005, we have what is called 'Custom Report Items', which are Reporting Services specific controls. We expect that there will be serveral third parties offering these, including an enhanced chart from Dundas Software. See http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx for some information about Custom Report Items.

Reporting Services

I am trying to jump to a seprate report from a text box.

In properites on the Navigation tab I selected Jump to (name or report) and in the Parameters box I selected =Fields!ProjName.Value so it will only give me the project name.

When I run and try to jump to the report I get this error.

An error occured during local report processing. An attempt was made to set a report parameter ProjectName this is not difined in this report.

Hey David,

I am trying to get a good idea of what you are attempting to do, however I am having a difficult time seeing it.

Are you trying to change reports when someone types a report name in a text box?

Are you trying to run a specific report for a certain project?

Do you have a report that actually has a ProjectName parameter created in it?|||Here is what I am trying to do I have a report That lists projects in a table. I want to be able to click on a project and have it jump to a completely different report based on the value of the item I clicked on. so If I click on project A it will take me to a different report that contains all the data about project A. to do this I am right clicking on the cell or textbox in the table that contains the project field (=Fields!ProjName.Value) I bring up the Textbox Properties box and select the Navigation box in the Jump to report I select the other report I created called DevSummary I then click on the Parameters box and add the following Parameter Name ProjName Parameter Value: =Fields!ProjName.Value When I run the report I get this error. An error occurred during local report processing. An attempt was made to set a report parameter 'ProjName' that is not defined in this report. below is a screen shot of what I am trying to do.|||

Hi,

What are your parameter names in the DevSummary report?

Aidan

|||Apologies Awysbrke - just noticed that you had already asked the same question...|||

There are no parameters defend in the DevSummary report?

How do I define parameter names here?

|||Ok David, I may see what is going on here.

You are wanting to view a report named DevSummary, with the information for the project that was clicked on in the specific text box. As far as I know this is all correct.

Now, where we are getting tossed by SSRS is when we try to pull up the second report. You are telling SSRS that you want the DevSummary report to process all the information for Parameter Name "ProjName".

Your DevSummary report definition file does not contain a parameter for ProjName, so it is kicking it back.

When you created the DevSummary report file, specifically the dataset, did you put any parameters in your SQL statement? What is the criteria for the actual DevSummary report using to retrieve the data?

If you are making a report for a specific project, you probably used a parameter for teh criteria, get that parameter name and then put the new name into the textbox navigation instead of the one named "ProjName"

I apologize if I insulted anyones intelligence, I am still learning this myself and like to write things out in detail :)

I hope this helps!

Anthony|||

You did not insult my intelligence at all. It makes perfect sense now. I need to create a dataset with a parameter in it and use the value from that in my second report called DevSummary. So correct me if I am wrong but the SQL would go something like

SELECT ProjName, whatever, whatever, whatever

FROM ProjectTable

WHERE ProjName = @.ProjName

Then use the @.ProjName in the report parameter in the DevSummary Report.

|||Exactly bro :)|||

I am now getting this error.

A data source instance has not been supplied for the data source 'DataSet4_Project'.

What does it mean

|||David,

How are you accessing this report?

Are you using hte default Report Manager, or are you writing your own asp application to view the report using the Report Viewer?

Also, 2000 or 2005?|||

I am Wrinting my own app using Report Viewer and SQL Server 2000

I am doing my development in Visual Studio.net 2005

|||David,

The error you are getting is telling you that there is no datasource on the server for the report. When you created the report, the first thing it should have asked was how you wanted to connect. This should have created the Shared Datasource, or individual datasource.

I believe that the problem is that your datasource wasn't uploaded to the server correctly. I could be mistaken. Double check and make sure the datasource that the report is using, is actualy on the server. You may have to rightclick on the project properties and make sure that overwrite current datasources is either checked or unchecked. If you made changes to an existing datasource, and that box isn't checked, it won't overwrite it with the new one.|||

I created a new datasource. two thngs

First: when I go to the project properties I can not find anything called overwrite current datasources there is nothing about datasources.

Second: When you sayuploaded to the server are you talking about the Web Server or the SQLServer?

|||Here's my scenario.

I am using VS2005, with SQL 2005, and the 2005 Reporting Service.

When I create a report, I do it in VS2005 with the Report Project.

I go through the wizard, selecting the datasource, selecting the fields etc..etc..

Now, in the Project properties, you should see General > Deployment and it has options there to overwrite datasources, and settings for report server url and folder.

This tells Visual Studio where to deploy the files to. The overwrite datasource is usually defaulted to False.

So, you create the report file in VS2005(which still has me purplexed because I was under the impression you needed SSRS 2005 to create reports in VS2005), then when you run it, VS automatically uploads your files to the respective server. If the overwrite datasource option is true, then it will overwrite your current datasource.

The report server is different from the SQL server and the Web Server.

Reporting Server 2005 Login issues

Have SQL Server 2005 September CTP
I am Local admin on box
Sysadmin in SQL Server
Installed reporting server. I used the BI Development Suite (VS) to build
reports. I ran the build with no issues than deployed the reports to the
server successfully. I can log in and view the reports from IE on the server
itself. They show up fine. The security is set to windows in reporting
server. When I attempt to view the report from my workstation I get the
following error:
An error has occurred during report processing.
Cannot impersonate user for data source 'RemoteConnection'.
Logon failed.
For more information about this error navigate to the report server on the
local server machine, or enable remote errors
Again SQL Server 2005 Sept CTP. Any help would really be appreciated.In Report Manager, select the data source you are using in your
report. In the General tab you should see information about
credentials and other connection informaton relevant to the data
source. Have a careful look at all aspects of that, as a first step.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 10:07:04 -0700, "T Man"
<TMan@.discussions.microsoft.com> wrote:
>Have SQL Server 2005 September CTP
>I am Local admin on box
>Sysadmin in SQL Server
>Installed reporting server. I used the BI Development Suite (VS) to build
>reports. I ran the build with no issues than deployed the reports to the
>server successfully. I can log in and view the reports from IE on the server
>itself. They show up fine. The security is set to windows in reporting
>server. When I attempt to view the report from my workstation I get the
>following error:
>An error has occurred during report processing.
>Cannot impersonate user for data source 'RemoteConnection'.
>Logon failed.
>For more information about this error navigate to the report server on the
>local server machine, or enable remote errors
>
>Again SQL Server 2005 Sept CTP. Any help would really be appreciated.