New to SQL 2000 Reporting Services - Need Some Help

I am trying to get SQL 2000 reporting services up and running, and am trying to get a condensed explanation of what I need to do, and any other software I may need to purchase.

I have already installed the Reporting Services, and after reading the help, it seems that I have to install MS Visual Studio 2003 in order to design the reports. Is this true.

Anyone that can give me some help in getting this up and running - I would be grateful.

Thanks so much - Joe

This is correct, to design reports there is an extension project system that is available for VS 2003, you must install VS and then re-run Reporting Services Setup so it can install the client bits.

SQL Server 2005 does not require you to buy a copy of VS as it includes a cut down copy. To design reports for SQL 2005 you need VS 2005, the versions don't cross over.

sql

New to Reporting Services

I am used to using Crystal Reports, but now with having Visual Studio 2005 and SQL Server 2005, I am trying to get along and use Reporting Services.

I need to understand or have somebody point me to a website or good book that I can use to learn about Report Server and the reports.

Here is the actual problem that I am having: I have built a report into the company intranet. This report works if I run it locally, however the print button does not show up understandably. Somebody mentioned making it a server-side report. So I imported the report into the Report Server of the SQL Server. At first I was getting an error message "The path of the item "\Reports\report.rdlc" is not valid. The path must be less than 260 characters long and restrictions apply. (rsInvalidItemPath)"

I believe I solved that error, but now when the page displays I do not get an error message, but I also do not have a report. The reportViewer is empty.

I then noticed that maybe I had to copy the report to IIS (I am using IIS 5.1). So I used the copy tool to copy the report to the directory for the report server in IIS (reportserver$sql). I have the property for the Server URL set to this directory and I have the report path set to \Reports\report.rdlc. Now I am getting an error message about "the item cannot be found."

Thanks for any information and help.

In SSRS all reports are actually stored inside of the Reporting Services database. As far I know, copying a file to the reporting server will not do anything for you. You need to 'Deploy' the report to the reporting services server from inside the report designer or BIDS (Business Intelligence Design Studio or something like that). However, you could also deploy the report from inside of reporting services web interface. I would also recommend the apress book on reporting services 2005. I bought the book because it was the first rs2005 book out of the gate. But it is actually really good. I started out with no knowledge of SSRS2005 and very limited knowledge of reporting technologies in general. This book made reporting services easy to learn.

Pro SQL Server 2005 Reporting Services

http://www.amazon.com/gp/product/1590594983/sr=1-4/qid=1138689829/ref=pd_bbs_4/002-0186147-5716036?%5Fencoding=UTF8

new to Reporting Services

Friends...

I am new to SQL Server Reporting Services... Pls let me know where and how to start... I browsed thru many sites, none of them provides easy and simple explanation with examples... Pls refer me any useful websites which has step-by-step simple and base explanations with simple examples or demos...

Thanx & Regards...

Salai

chk out this blog for a step by step tutorial on creating reports. If you comment out the code inPageSaveStateComplete then you will get a report else a pdf.

http://technoblab.blogspot.com

....................................................................

Remember to "Mark as Answer" on the post that helped you

|||

Look aroundhttp://www.databasejournal.com

|||

This might help you:

http://www.codeproject.com/aspnet/ReportViewer.asp

sql

New to Reporting Services

We have a license for SQL Server Enterprise.The license is per processor.We plan to use Reporting Services. I was wondering if there is going to be a limitation for the number of the users that can use this. Similar with Crystal asking for license for more than 5 concurrent users.
We'll access Reporting Services from a web site.Unfortunately the web site is plain ASP.Is there any way I can use Reporting Service(maybe the web service) from plain ASP, or should I think about a way to integrate an ASP.NET page?
The report is generated based on some data the users are entering, and is not related in any way to any database, can I push some xml from my page to the Reporting Service?
Do I need to have a SSL certificate to use Reporting Services?
Can I just download Reporting Services from Microsoft, or is it available only on a CD? We are somehow in a hurry, I don't have too much time to wait for CD's.
Thanks,
IoanaThe requirements for SQL Server Reporting Services are listed herehttp://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx you will see that the server needs the .NET framework. When that is setup ASP applications should be able to call the reports with a URL or you can use the web service that is part of it.
To my knowledge there is no limit for the number of concurrent Reporting Services users.
An SSL certificate isn't essential but is advisable.
You can download the demonstration which should get you going until you get the CD
Steve|||Thank you Steve.That answers all my questions.:o)

New to Reporting Services

hi
I am new to reporting services of SQL Server. I just read an article about
it. In our organization, we are using Crystal Reports to develop reports for
our system. Backend is of course SQL Server 2000.
Can anyone please guide me that from where I should start to explore this
new technology?
Also is it necessary to use the reporting services of SQL Server 2000 via
VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
Thanks in advance.
Syed Hussain Itiba NaqviI would purchase the book "Hitchiker's Guide to SQL Server 2000 Reporting
Services."
You can get a good deal at www.BookPool.com
David
"Syed Hussain Itiba Naqvi" <Syed Hussain Itiba
Naqvi@.discussions.microsoft.com> wrote in message
news:6E7B4BEB-9417-448F-B430-D29411BA114D@.microsoft.com...
> hi
> I am new to reporting services of SQL Server. I just read an article about
> it. In our organization, we are using Crystal Reports to develop reports
> for
> our system. Backend is of course SQL Server 2000.
> Can anyone please guide me that from where I should start to explore this
> new technology?
> Also is it necessary to use the reporting services of SQL Server 2000 via
> VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
> Thanks in advance.
> Syed Hussain Itiba Naqvi|||Syed,
Reporting Services comes in two parts.
1. The Server
2. Development Tools.
Ideally The Server components need to be on the same box as a SQL instance
(if you want to run it under the same license - see licensing for further
details) and the same box should have Web Server on also. RS uses the SQL
instance to store it's two new DBs to run the service.
The Development tools can be loaded onto any development machine, but
require VS.NET 2003. Once installed it adds Business Intelligence Projects to
the available solutions, and the Report Designer runs inside of VS.NET IDE
(as does the Crystal designer).
The cool thing about the designer is that you can preview (in like
real-time) the report results from inside the IDE, and also, by deploying it
to your localhost, you can see how the Reporting Server will handle it also,
all prior to deploying it to the 'real' server.
two books to get: Professional SQL Server Reporting Services - WROX and
Step-by-Step SQL Server 2000 Reporting Services - Microsoft. These two books
hold so much instructional info for the beginner.
Also, contact your local Microsoft Area Rep, they will assist you greatly. I
did, and they web-demo'd the technology to myself and my Managers during a
conference call. They have been excellent and very supportive.
Hope this assists,
Tony
"Syed Hussain Itiba Naqvi" wrote:
> hi
> I am new to reporting services of SQL Server. I just read an article about
> it. In our organization, we are using Crystal Reports to develop reports for
> our system. Backend is of course SQL Server 2000.
> Can anyone please guide me that from where I should start to explore this
> new technology?
> Also is it necessary to use the reporting services of SQL Server 2000 via
> VS.NET 2003 or can my VB 6 application develop the same kinds of reoprts?
> Thanks in advance.
> Syed Hussain Itiba Naqvi

New to reporting service

I am new to reporting service but has used VS 2005 beta to develop winform app for a long time. I have the following questions:

1. Are the report object and report viewer in VS2005(winform) related to those of SQL server reporting service? If yes, what are the relationship?
2. If I just want to create/view report with report viewer of VS2005 in my app which connect to SQL Server Express, do I need reporting service?
3. I can see there are options to install reporting service while installing SQL Server Express(free of charge), can I develop app for my client which use reporting service with SQL Server Express?

Thank a lot!Any idea?|||

Okay, here we go.

Reporting Services
Reporting Services is a component of SQL Server 2000 and SQL Server 2005. Basically the Reporting Services acts as a Report Repository and supports such features as:
* Server-Side Rendering = The server does the work
* Subscriptions - Reports can be generated at scheduled times and be automatically distributed to email or file shares.
* Report Snapshots - Report output can be rendered and stored on the server, for instance a monthly report can have a monthly snapshot. This way you never to need to print and store common reports, the server has the old copy even if the orginial report data is gone.

ReportViewer Control
Okay, so Reporting Services basically rocks because it solved the majority of your reporting issues and comes free with most versions of SQL Server. Now, in with SQL Server 2005 and Visual Studio 2005 there are 2 new controls that make reporting services even better. There is a Windows forms and asp.net ReportViewer control. The control can work in 2 modes, Remote and Local. In Remote mode it can be used to integrate with Reporting Services as users can view reports stored on the server. In local mode (what you want) it can displayed reports that have been embedded within your application. In this mode Reporting Services is not required, which makes it ideal to use with SQL Express. There are only 2 minor disadvantages to running in local mode. The first is that the client computer has to do all the work and report rendering, but its not bad for smaller applications. The second is that the client must have this ReportViewer pack installed. Basically, it contains all of the rendering pieces needed to render a report on the client machine. The great news is that if you deploy your application using the new ClickOnce, you can automatically deploy the ReportViewerPack (also it is very small like only a couple of MB!).

|||Thanks

New to reporting service

I am new to reporting service but has used VS 2005 beta to develop winform app for a long time. I have the following questions:

1. Are the report object and report viewer in VS2005(winform) related to those of SQL server reporting service? If yes, what are the relationship?
2. If I just want to create/view report with report viewer of VS2005 in my app which connect to SQL Server Express, do I need reporting service?
3. I can see there are options to install reporting service while installing SQL Server Express(free of charge), can I develop app for my client which use reporting service with SQL Server Express?

Thank a lot!

Any idea?|||

Okay, here we go.

Reporting Services
Reporting Services is a component of SQL Server 2000 and SQL Server 2005. Basically the Reporting Services acts as a Report Repository and supports such features as:
* Server-Side Rendering = The server does the work
* Subscriptions - Reports can be generated at scheduled times and be automatically distributed to email or file shares.
* Report Snapshots - Report output can be rendered and stored on the server, for instance a monthly report can have a monthly snapshot. This way you never to need to print and store common reports, the server has the old copy even if the orginial report data is gone.

ReportViewer Control
Okay, so Reporting Services basically rocks because it solved the majority of your reporting issues and comes free with most versions of SQL Server. Now, in with SQL Server 2005 and Visual Studio 2005 there are 2 new controls that make reporting services even better. There is a Windows forms and asp.net ReportViewer control. The control can work in 2 modes, Remote and Local. In Remote mode it can be used to integrate with Reporting Services as users can view reports stored on the server. In local mode (what you want) it can displayed reports that have been embedded within your application. In this mode Reporting Services is not required, which makes it ideal to use with SQL Express. There are only 2 minor disadvantages to running in local mode. The first is that the client computer has to do all the work and report rendering, but its not bad for smaller applications. The second is that the client must have this ReportViewer pack installed. Basically, it contains all of the rendering pieces needed to render a report on the client machine. The great news is that if you deploy your application using the new ClickOnce, you can automatically deploy the ReportViewerPack (also it is very small like only a couple of MB!).

|||Thanks

New to Analysis Services. Some general questions

Hi everyone,

I am running a complex reporting system on SQL Reporting Services and I think that analysis services may provide some benifits, however as I am new to it, i could use a little guidance.

Basically I am reporting on a huge volume of very granular information. Because there is so much data we prune the system such that at any point it only reflects 30 days worth of information. Because of this, I can't really run reports to look at statistical information or trends over time (say 6 months to a year).

I was wondering, would it be possible to take certain information from the database before it is pruned and store this seperately to be used by Analysis services to report on long term trend data? Can analysis services do something like this?

Any help or advice would be appreciated!

Kind regards
Taz

Analysis services will use your detailed information only when the cube is processed. After that the cube is a separate, multidimensional structure with aggregations designed above your data source leaf level.

Be aware of a problem with designing cubes from report systems. Do not use more than 10-15 dimensions in the cube. Report applications can often have more than this.

I recommend building a star schema. You can see that in the Adventure works DW db that is part of the samples in the SQL Server 2005 installation. You can also find information about star schemas here(www.kimballgroup.com). Star scemas can be built by using views.

HTH

Thomas Ivarsson

New Template, open exsisting, any way to call reporting wizard now?

Any way to load my new template, and then call wizard? seems wizard is
not accessable if after I start with open existing item.
Can anybody recommend and easy to follow book on on reporting services
2005?
dumb question, say I have a grouping report like this
group
detail detail datetime
detail detail datetime
detail detail datetime
and I want to change the background color any datetime fields that
elapsed more than 4 hours since last entry to red. How? where? what?
Thanks.In the background color - have an expression :
I hardcoded the date/time below as an example, but this would actually be
your Fields!dtDateField.Value and getdate() would be Now()
If it is greater than 4 hours, it is displayed in red, otherwise blue - but
=iif(datediff(hh, '10/27/06 8:00:00AM', Now()) > 4, "Red", "White")
=-Chris
"Jason" <jason@.cyberpine.com> wrote in message
news:1161914681.963331.129650@.i3g2000cwc.googlegroups.com...
> Any way to load my new template, and then call wizard? seems wizard is
> not accessable if after I start with open existing item.
> Can anybody recommend and easy to follow book on on reporting services
> 2005?
>
> dumb question, say I have a grouping report like this
>
> group
> detail detail datetime
> detail detail datetime
> detail detail datetime
>
> and I want to change the background color any datetime fields that
> elapsed more than 4 hours since last entry to red. How? where? what?
> Thanks.
>|||sorry, 4 hours greater than than the date/time on the subsiquent row
the row.
But, the thing I really stuck on is the report design, if I'm limited
to one dataset the group. Can I have two datasets in a groupset, or
will I have create a view with duplicating data?
I have two tables
filelog:
id
filename
datelog:
id
date
type
I'm trying to do this
Id
filename, filename, filename (line wraping if neccessary)
date type
date type
id
filename, filename, filename (line wraping if neccessary)
date type
date type
==there might be some 5 to 20 filelog rows for every id, there can number
of datelog entries with the same id, but other than Id there is no
other corrilationbe between filelog and datelog
Chris Conner wrote:
> In the background color - have an expression :
> I hardcoded the date/time below as an example, but this would actually be
> your Fields!dtDateField.Value and getdate() would be Now()
> If it is greater than 4 hours, it is displayed in red, otherwise blue - but
> =iif(datediff(hh, '10/27/06 8:00:00AM', Now()) > 4, "Red", "White")
> =-Chris
> "Jason" <jason@.cyberpine.com> wrote in message
> news:1161914681.963331.129650@.i3g2000cwc.googlegroups.com...
> > Any way to load my new template, and then call wizard? seems wizard is
> > not accessable if after I start with open existing item.
> >
> > Can anybody recommend and easy to follow book on on reporting services
> > 2005?
> >
> >
> > dumb question, say I have a grouping report like this
> >
> >
> > group
> > detail detail datetime
> > detail detail datetime
> > detail detail datetime
> >
> >
> > and I want to change the background color any datetime fields that
> > elapsed more than 4 hours since last entry to red. How? where? what?
> >
> > Thanks.
> >

New Subscriptions Not Running

Hello,
I am running Microsoft SQL Server 2000.
For some reason all of the sudden any subscription I make in reporting
services will not run.
The status just stays at "New Subscription". I made a test schedule
that runs every 5 minutes.
I have even added old subscriptions to this schedule and I get email
every 5 minutes. Why would any new subscription I make not be running?
I don't even get an error message under the status heading in the
subscription list.
Thanks,
JeffJeffrae wrote:
> Hello,
> I am running Microsoft SQL Server 2000.
> For some reason all of the sudden any subscription I make in reporting
> services will not run.
> The status just stays at "New Subscription". I made a test schedule
> that runs every 5 minutes.
> I have even added old subscriptions to this schedule and I get email
> every 5 minutes. Why would any new subscription I make not be running?
>
> I don't even get an error message under the status heading in the
> subscription list.
>
> Thanks,
> Jeff
Ok... Here is something that I forgot to mention.. This is actually a
big thing.. I recently upgraded my computer so had to migrate the SQL
server and reporting services.. All of the existing reports run like a
charm.. I just can not get any new ones to run..
Thanks,
Jeff|||Jeffrae wrote:
> Jeffrae wrote:
> > Hello,
> >
> > I am running Microsoft SQL Server 2000.
> >
> > For some reason all of the sudden any subscription I make in reporting
> > services will not run.
> >
> > The status just stays at "New Subscription". I made a test schedule
> > that runs every 5 minutes.
> >
> > I have even added old subscriptions to this schedule and I get email
> > every 5 minutes. Why would any new subscription I make not be running?
> >
> >
> > I don't even get an error message under the status heading in the
> > subscription list.
> >
> >
> > Thanks,
> > Jeff
> Ok... Here is something that I forgot to mention.. This is actually a
> big thing.. I recently upgraded my computer so had to migrate the SQL
> server and reporting services.. All of the existing reports run like a
> charm.. I just can not get any new ones to run..
> Thanks,
> Jeff
Is there another newsgroup that I may want to post this question in?
Thanks,
Jeff

New SQL Server 2000 Reporting Services Report Pack

There is a new Report Pack for Reporting Services 2000 at
http://www.microsoft.com/downloads/details.aspx?FamilyId=2805D337-14C7-40E3-820B-E7EE653C68C0&displaylang=en.
Further Report Packs, which provide useful sample reports, are can be
downloaded using links on
http://www.microsoft.com/sql/reporting/downloads/default.asp.
Report Packs are not to be confused with the long-awaited Service Pack
2.
Andrew Watt
MVP - InfoPathAndrew ,
Thank you very much.
It is hard to keep track of what is out there. you made life easier here.
:)
John
--
Message posted via http://www.sqlmonster.com|||A full list is at
http://www.microsoft.com/sql/reporting/downloads/default.asp.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:u55251hhdcejo3cde1ue56q4o65dijblcu@.4ax.com...
> There is a new Report Pack for Reporting Services 2000 at
> http://www.microsoft.com/downloads/details.aspx?FamilyId=2805D337-14C7-40E3-820B-E7EE653C68C0&displaylang=en.
> Further Report Packs, which provide useful sample reports, are can be
> downloaded using links on
> http://www.microsoft.com/sql/reporting/downloads/default.asp.
> Report Packs are not to be confused with the long-awaited Service Pack
> 2.
> Andrew Watt
> MVP - InfoPath|||This is a multipart message in MIME format.
--=_alternative 004630FB86256FDA_=Content-Type: text/plain; charset="us-ascii"
Anyone have a similar thing for reports that describe Reporting Service
usage (such as execution times, users running reports, etc.)?
--=_alternative 004630FB86256FDA_=Content-Type: text/html; charset="us-ascii"
<br><font size=1 face="sans-serif">Anyone have a similar thing for reports that describe Reporting Service usage (such as execution times, users running reports, etc.)?</font>
--=_alternative 004630FB86256FDA_=--|||This exists, I found it and downloaded it, but I can't find it :(
There is a nasty DTS package that comes with it to make it readable, as
well as a few reports. I'll keep looking...|||Acutally there is a DTS package and report pack for execution times and
what not...I believe they are both on the Reporting Services CD.
Otherwise you can find them on microsofts website somewhere.|||were you able to run this DTS package succesfully ? It fails for me at
different
steps - not able to open a connection etc --
is this feature integrated into rs2005 ?
"John" wrote:
> This exists, I found it and downloaded it, but I can't find it :(
> There is a nasty DTS package that comes with it to make it readable, as
> well as a few reports. I'll keep looking...
>|||Yes, I was able to run the DTS package. I think I had to make some
changes ...I don't remember exactly. There is a document on how to get
this to work also...again not sure where that is. I run the DTS package
once a week and view stats on my reports. It's fairly handy.|||Sorry, I forgot the link.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
"ranga" wrote:
> were you able to run this DTS package succesfully ? It fails for me at
> different
> steps - not able to open a connection etc --
> is this feature integrated into rs2005 ?
> "John" wrote:
> > This exists, I found it and downloaded it, but I can't find it :(
> > There is a nasty DTS package that comes with it to make it readable, as
> > well as a few reports. I'll keep looking...
> >
> >|||This article explains how to set up the DTS package, and deploy the reports.
"ranga" wrote:
> were you able to run this DTS package succesfully ? It fails for me at
> different
> steps - not able to open a connection etc --
> is this feature integrated into rs2005 ?
> "John" wrote:
> > This exists, I found it and downloaded it, but I can't find it :(
> > There is a nasty DTS package that comes with it to make it readable, as
> > well as a few reports. I'll keep looking...
> >
> >

New RS server TimeProcessing very large

We just installed a new server dedicated to Reporting Services. I uploaded
our report definitions and ran a test. The TimeProcessing value is huge
compared to our old server.
Old server: RS 2005 as part of database cluster on an instances that also
hosts data, 32-bit OS and SQL (SP2), 2.79GHz, 16GB RAM with 7.5GB dedicated
to SQL, Xeon 2.80GHz, PAE
New server: Dedicated to Reporting Services 2005, 64-bit OS and SQL (SP2),
2.66GHz, 16GB RAM, min server memory and max server memory configuration
values are still the defaults, Xeon X5355@.2.66 GHz
Do you have any suggestions on where I can look to begin troubleshooting
this performance issue?
StephanieStephanie, I am also facing the same issue in the same kind of 64-bit OS,
RS2005.
Have you got any solution to this issue?
Kavitha
url:http://www.ureader.com/msg/115713370.aspx|||The volume of data being brought back in our case was too large (we were
trying to bring back data files, not reports) and we were using Excel, which
consumes a tremendous amount of memory. Microsoft's answer was that we
should not be using RS to deliver files, only reports of a printable size,
i.e. not 300 page reports.
"Kavitha" wrote:
> Stephanie, I am also facing the same issue in the same kind of 64-bit OS,
> RS2005.
> Have you got any solution to this issue?
> Kavitha
> url:http://www.ureader.com/msg/115713370.aspx
>|||Keep in mind that if you want to bring over data try CSV ASCII instead of
Excel for large data amounts of data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> The volume of data being brought back in our case was too large (we were
> trying to bring back data files, not reports) and we were using Excel,
> which
> consumes a tremendous amount of memory. Microsoft's answer was that we
> should not be using RS to deliver files, only reports of a printable size,
> i.e. not 300 page reports.
>
> "Kavitha" wrote:
>> Stephanie, I am also facing the same issue in the same kind of 64-bit OS,
>> RS2005.
>> Have you got any solution to this issue?
>> Kavitha
>> url:http://www.ureader.com/msg/115713370.aspx|||Thanks, Bruce. I think that is exactly the direction that we are going in.
Stephanie
"Bruce L-C [MVP]" wrote:
> Keep in mind that if you want to bring over data try CSV ASCII instead of
> Excel for large data amounts of data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> > The volume of data being brought back in our case was too large (we were
> > trying to bring back data files, not reports) and we were using Excel,
> > which
> > consumes a tremendous amount of memory. Microsoft's answer was that we
> > should not be using RS to deliver files, only reports of a printable size,
> > i.e. not 300 page reports.
> >
> >
> > "Kavitha" wrote:
> >
> >> Stephanie, I am also facing the same issue in the same kind of 64-bit OS,
> >> RS2005.
> >>
> >> Have you got any solution to this issue?
> >>
> >> Kavitha
> >>
> >> url:http://www.ureader.com/msg/115713370.aspx
> >>
>
>|||One other point then (that is obscure) there is a server setting that will
default CSV to ascii so that Excel brings up the data properly split between
cells. Otherwise the default is unicode that Excel doesn't know what to do
with so it puts it all into one column that the user then has to split
(there is a menu in Excel to do this).
Let me know if you need the config setting for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
> Thanks, Bruce. I think that is exactly the direction that we are going
> in.
> Stephanie
>
> "Bruce L-C [MVP]" wrote:
>> Keep in mind that if you want to bring over data try CSV ASCII instead of
>> Excel for large data amounts of data.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
>> > The volume of data being brought back in our case was too large (we
>> > were
>> > trying to bring back data files, not reports) and we were using Excel,
>> > which
>> > consumes a tremendous amount of memory. Microsoft's answer was that
>> > we
>> > should not be using RS to deliver files, only reports of a printable
>> > size,
>> > i.e. not 300 page reports.
>> >
>> >
>> > "Kavitha" wrote:
>> >
>> >> Stephanie, I am also facing the same issue in the same kind of 64-bit
>> >> OS,
>> >> RS2005.
>> >>
>> >> Have you got any solution to this issue?
>> >>
>> >> Kavitha
>> >>
>> >> url:http://www.ureader.com/msg/115713370.aspx
>> >>
>>|||Really? That would be GREAT! I'm always having to break it up into the
multiple columns manually. I didn't know that you could have this done
automatically. This is a RS configuration setting? Or RS server setting?
How do I update that setting?
Stephanie
"Bruce L-C [MVP]" wrote:
> One other point then (that is obscure) there is a server setting that will
> default CSV to ascii so that Excel brings up the data properly split between
> cells. Otherwise the default is unicode that Excel doesn't know what to do
> with so it puts it all into one column that the user then has to split
> (there is a menu in Excel to do this).
> Let me know if you need the config setting for this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
> > Thanks, Bruce. I think that is exactly the direction that we are going
> > in.
> >
> > Stephanie
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Keep in mind that if you want to bring over data try CSV ASCII instead of
> >> Excel for large data amounts of data.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> >> > The volume of data being brought back in our case was too large (we
> >> > were
> >> > trying to bring back data files, not reports) and we were using Excel,
> >> > which
> >> > consumes a tremendous amount of memory. Microsoft's answer was that
> >> > we
> >> > should not be using RS to deliver files, only reports of a printable
> >> > size,
> >> > i.e. not 300 page reports.
> >> >
> >> >
> >> > "Kavitha" wrote:
> >> >
> >> >> Stephanie, I am also facing the same issue in the same kind of 64-bit
> >> >> OS,
> >> >> RS2005.
> >> >>
> >> >> Have you got any solution to this issue?
> >> >>
> >> >> Kavitha
> >> >>
> >> >> url:http://www.ureader.com/msg/115713370.aspx
> >> >>
> >>
> >>
> >>
>
>|||You only need to change in one place, rsreportserver.config. Reboot after
the change. The below shows commenting out the existing entry and putting in
the needed change to have CSV export as ASCII. I can understand this being a
default for MS because they are so international oriented but seeing as how
Excel doesn't understand Unicode CSV (at least through Excel 2003) , I don't
know about the most recent version. Anyway, this works great.
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
The other option is to use Jump to URL. Here is an example of a Jump to URL
link I use. This causes Excel to come up with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
I configure my server to export CSV in ASCII. Much handier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:F3F00888-F052-4EFD-9079-29E829EB63F3@.microsoft.com...
> Really? That would be GREAT! I'm always having to break it up into the
> multiple columns manually. I didn't know that you could have this done
> automatically. This is a RS configuration setting? Or RS server setting?
> How do I update that setting?
> Stephanie
>
> "Bruce L-C [MVP]" wrote:
>> One other point then (that is obscure) there is a server setting that
>> will
>> default CSV to ascii so that Excel brings up the data properly split
>> between
>> cells. Otherwise the default is unicode that Excel doesn't know what to
>> do
>> with so it puts it all into one column that the user then has to split
>> (there is a menu in Excel to do this).
>> Let me know if you need the config setting for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
>> > Thanks, Bruce. I think that is exactly the direction that we are going
>> > in.
>> >
>> > Stephanie
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Keep in mind that if you want to bring over data try CSV ASCII instead
>> >> of
>> >> Excel for large data amounts of data.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
>> >> > The volume of data being brought back in our case was too large (we
>> >> > were
>> >> > trying to bring back data files, not reports) and we were using
>> >> > Excel,
>> >> > which
>> >> > consumes a tremendous amount of memory. Microsoft's answer was
>> >> > that
>> >> > we
>> >> > should not be using RS to deliver files, only reports of a printable
>> >> > size,
>> >> > i.e. not 300 page reports.
>> >> >
>> >> >
>> >> > "Kavitha" wrote:
>> >> >
>> >> >> Stephanie, I am also facing the same issue in the same kind of
>> >> >> 64-bit
>> >> >> OS,
>> >> >> RS2005.
>> >> >>
>> >> >> Have you got any solution to this issue?
>> >> >>
>> >> >> Kavitha
>> >> >>
>> >> >> url:http://www.ureader.com/msg/115713370.aspx
>> >> >>
>> >>
>> >>
>> >>
>>|||Bruce,
Great. I'll try the config change. I'm going to do some testing in my
development environment. Do I have to reboot the RS server or can I just
restart RS?
Stephanie
"Bruce L-C [MVP]" wrote:
> You only need to change in one place, rsreportserver.config. Reboot after
> the change. The below shows commenting out the existing entry and putting in
> the needed change to have CSV export as ASCII. I can understand this being a
> default for MS because they are so international oriented but seeing as how
> Excel doesn't understand Unicode CSV (at least through Excel 2003) , I don't
> know about the most recent version. Anyway, this works great.
> <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
> The other option is to use Jump to URL. Here is an example of a Jump to URL
> link I use. This causes Excel to come up with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> I configure my server to export CSV in ASCII. Much handier.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:F3F00888-F052-4EFD-9079-29E829EB63F3@.microsoft.com...
> > Really? That would be GREAT! I'm always having to break it up into the
> > multiple columns manually. I didn't know that you could have this done
> > automatically. This is a RS configuration setting? Or RS server setting?
> >
> > How do I update that setting?
> >
> > Stephanie
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> One other point then (that is obscure) there is a server setting that
> >> will
> >> default CSV to ascii so that Excel brings up the data properly split
> >> between
> >> cells. Otherwise the default is unicode that Excel doesn't know what to
> >> do
> >> with so it puts it all into one column that the user then has to split
> >> (there is a menu in Excel to do this).
> >>
> >> Let me know if you need the config setting for this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> >> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
> >> > Thanks, Bruce. I think that is exactly the direction that we are going
> >> > in.
> >> >
> >> > Stephanie
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Keep in mind that if you want to bring over data try CSV ASCII instead
> >> >> of
> >> >> Excel for large data amounts of data.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> >> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
> >> >> > The volume of data being brought back in our case was too large (we
> >> >> > were
> >> >> > trying to bring back data files, not reports) and we were using
> >> >> > Excel,
> >> >> > which
> >> >> > consumes a tremendous amount of memory. Microsoft's answer was
> >> >> > that
> >> >> > we
> >> >> > should not be using RS to deliver files, only reports of a printable
> >> >> > size,
> >> >> > i.e. not 300 page reports.
> >> >> >
> >> >> >
> >> >> > "Kavitha" wrote:
> >> >> >
> >> >> >> Stephanie, I am also facing the same issue in the same kind of
> >> >> >> 64-bit
> >> >> >> OS,
> >> >> >> RS2005.
> >> >> >>
> >> >> >> Have you got any solution to this issue?
> >> >> >>
> >> >> >> Kavitha
> >> >> >>
> >> >> >> url:http://www.ureader.com/msg/115713370.aspx
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I would assume restart will do it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:8A028412-E210-4A2D-8CC5-E395E5BD3474@.microsoft.com...
> Bruce,
> Great. I'll try the config change. I'm going to do some testing in my
> development environment. Do I have to reboot the RS server or can I just
> restart RS?
> Stephanie
>
> "Bruce L-C [MVP]" wrote:
>> You only need to change in one place, rsreportserver.config. Reboot after
>> the change. The below shows commenting out the existing entry and putting
>> in
>> the needed change to have CSV export as ASCII. I can understand this
>> being a
>> default for MS because they are so international oriented but seeing as
>> how
>> Excel doesn't understand Unicode CSV (at least through Excel 2003) , I
>> don't
>> know about the most recent version. Anyway, this works great.
>> <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>> The other option is to use Jump to URL. Here is an example of a Jump to
>> URL
>> link I use. This causes Excel to come up with the data in a separate
>> window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to
>> URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> I configure my server to export CSV in ASCII. Much handier.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:F3F00888-F052-4EFD-9079-29E829EB63F3@.microsoft.com...
>> > Really? That would be GREAT! I'm always having to break it up into
>> > the
>> > multiple columns manually. I didn't know that you could have this done
>> > automatically. This is a RS configuration setting? Or RS server
>> > setting?
>> >
>> > How do I update that setting?
>> >
>> > Stephanie
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> One other point then (that is obscure) there is a server setting that
>> >> will
>> >> default CSV to ascii so that Excel brings up the data properly split
>> >> between
>> >> cells. Otherwise the default is unicode that Excel doesn't know what
>> >> to
>> >> do
>> >> with so it puts it all into one column that the user then has to split
>> >> (there is a menu in Excel to do this).
>> >>
>> >> Let me know if you need the config setting for this.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> >> news:C7FD6C07-7965-4D15-AA73-F2DBC217559C@.microsoft.com...
>> >> > Thanks, Bruce. I think that is exactly the direction that we are
>> >> > going
>> >> > in.
>> >> >
>> >> > Stephanie
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Keep in mind that if you want to bring over data try CSV ASCII
>> >> >> instead
>> >> >> of
>> >> >> Excel for large data amounts of data.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> >> >> news:FB4109A9-B5DA-4509-8020-1747C3A2179A@.microsoft.com...
>> >> >> > The volume of data being brought back in our case was too large
>> >> >> > (we
>> >> >> > were
>> >> >> > trying to bring back data files, not reports) and we were using
>> >> >> > Excel,
>> >> >> > which
>> >> >> > consumes a tremendous amount of memory. Microsoft's answer was
>> >> >> > that
>> >> >> > we
>> >> >> > should not be using RS to deliver files, only reports of a
>> >> >> > printable
>> >> >> > size,
>> >> >> > i.e. not 300 page reports.
>> >> >> >
>> >> >> >
>> >> >> > "Kavitha" wrote:
>> >> >> >
>> >> >> >> Stephanie, I am also facing the same issue in the same kind of
>> >> >> >> 64-bit
>> >> >> >> OS,
>> >> >> >> RS2005.
>> >> >> >>
>> >> >> >> Have you got any solution to this issue?
>> >> >> >>
>> >> >> >> Kavitha
>> >> >> >>
>> >> >> >> url:http://www.ureader.com/msg/115713370.aspx
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

New Role Assignment Question

I have just set up SQL Reporting Services in our Development environment and
want to set all users with browser or read-only access to our reports but do
not see how. I am going in through the web interface and it tells me that I
must have a valid domain group or interface. Any idea on how to just select
"Everyone"?DomainName\Everyone
ComputerName\Everyone
HTH, Jens Süßmeyer
--
http://www.sqlserver2005.de
--
"Charles Collins" <Charles Collins@.discussions.microsoft.com> schrieb im
Newsbeitrag news:234DF76B-A041-4989-A116-6CADDEB19E9B@.microsoft.com...
>I have just set up SQL Reporting Services in our Development environment
>and
> want to set all users with browser or read-only access to our reports but
> do
> not see how. I am going in through the web interface and it tells me that
> I
> must have a valid domain group or interface. Any idea on how to just
> select
> "Everyone"?|||Currently Reporting Services only supports Windows Authentication. Which
means you need to create a network group (with everyone you want) in it and
then give that network group access to the reports. Reporting Services
security is extensible though if you want to create your own security
extension (Not an easy task). Here is link to a microsoft example of
creating your own security extension...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
"Charles Collins" wrote:
> I have just set up SQL Reporting Services in our Development environment and
> want to set all users with browser or read-only access to our reports but do
> not see how. I am going in through the web interface and it tells me that I
> must have a valid domain group or interface. Any idea on how to just select
> "Everyone"?|||When I try that I get:
The user or group name '(domain or computer name)\everyone' is not
recognized. (rsUnknownUserName)
"Jens Sü�meyer" wrote:
> DomainName\Everyone
> ComputerName\Everyone
> HTH, Jens Sü�meyer
> --
> http://www.sqlserver2005.de
> --
> "Charles Collins" <Charles Collins@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:234DF76B-A041-4989-A116-6CADDEB19E9B@.microsoft.com...
> >I have just set up SQL Reporting Services in our Development environment
> >and
> > want to set all users with browser or read-only access to our reports but
> > do
> > not see how. I am going in through the web interface and it tells me that
> > I
> > must have a valid domain group or interface. Any idea on how to just
> > select
> > "Everyone"?
>
>|||Is there an way to assign mulitple users an role at once?
"Jens Sü�meyer" wrote:
> DomainName\Everyone
> ComputerName\Everyone
> HTH, Jens Sü�meyer
> --
> http://www.sqlserver2005.de
> --
> "Charles Collins" <Charles Collins@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:234DF76B-A041-4989-A116-6CADDEB19E9B@.microsoft.com...
> >I have just set up SQL Reporting Services in our Development environment
> >and
> > want to set all users with browser or read-only access to our reports but
> > do
> > not see how. I am going in through the web interface and it tells me that
> > I
> > must have a valid domain group or interface. Any idea on how to just
> > select
> > "Everyone"?
>
>

new Reporting Services

I just read an article online about SQL Server Reporting Services. Any
sense of whether this functionality can be embeded in an ASP.NET web
application? The article made it sound like you'd have to go to a separate
web page in order to view the reports ...
http://www.sqlmag.com/articles/index.cfm?articleid=40529
Thanks in advance.
MarkYes you can. Have a look at the developer samples (if you are on B2). They
include a ReportViewer Sample ASP.NET Server Control for integrating
Reporting Services reports in a Web application. RS is basically a web
service so you can do pretty much what you want with it. Flexibility and
extensibility are key features
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mark" <mfield@.idonotlikespam.cce.umn.edu> wrote in message
news:uOCOw7rsDHA.2408@.tk2msftngp13.phx.gbl...
I just read an article online about SQL Server Reporting Services. Any
sense of whether this functionality can be embeded in an ASP.NET web
application? The article made it sound like you'd have to go to a separate
web page in order to view the reports ...
http://www.sqlmag.com/articles/index.cfm?articleid=40529
Thanks in advance.
Mark

New Reporting Control

Does the new report control for vs 2005 utilize SOAP or the URL method
to access the report server?
I need to utilize a pure SOAP based solution to get reports from the
report server. Just curious if the new solution is used that way or if
rolling my own is the only option.
ThanksThe new controls use soap (web services). They are a much more complete
solution that the old way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivaldi" <ZachMattson@.gmail.com> wrote in message
news:1131634098.219113.321000@.g49g2000cwa.googlegroups.com...
> Does the new report control for vs 2005 utilize SOAP or the URL method
> to access the report server?
> I need to utilize a pure SOAP based solution to get reports from the
> report server. Just curious if the new solution is used that way or if
> rolling my own is the only option.
> Thanks
>

New Installation Error

Hello all.
After suffering a complete RAID failure, I am now tasked with the
responsibility of setting up reporting services again, on a new and
different machine. I had been successful getting it running last time,
so I figured this wouldn't be too much problem. The installation goes
fine, until the end, when it reports that the service wont start for
the first time.
As for information. Server2003-sp1. For the ReportServer Windows
service I'm using account (NT AUTHORITY\NETWORK SERVICE). I've left
virtual directories the same, except that I've disabled SSL
connections. The Database is running locally, and for the runtime
connection credentials, I've chosen to use a Domain User Account (set
up especially for this purpose) "RSExec".
As I said, the install goes fine, but fails. The only thing I can
think of is that maybe my new RSExec user needs more permission than a
standard user. But I've read the books (Lachev, and Blackburn &
Vaughn), as well as the BOL, and I can't find any indication of what I
might be missing.
Opening the //machine/ReportServer page, I get the following error
message:
* The report server cannot open a connection to the report server
database. The logon failed. (rsReportServerDatabaseLogonFailed) Get
Online Help
o Logon failure: the user has not been granted the requested logon
type at this computer.
The error message from the log shows:
w3wp!ui!dc0!9/27/2005-08:25:37:: e ERROR:
System.Web.Services.Protocols.SoapException: The report server cannot
open a connection to the report server database. The logon failed. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseLogonFailedException:
The report server cannot open a connection to the report server
database. The logon failed. -->
System.Runtime.InteropServices.COMException (0x80070569): Logon
failure: the user has not been granted the requested logon type at this
computer.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr&
pImpToken)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetImpersonationToken(String
userName, String domain, String userPwd)
-- End of inner exception stack trace --
Thanks for all your help. It is sincerely appreciated.
Brian AckermannDid you grant RSExec permissions to logon to SQL server? If so, can you
check to see if the user has permission to the RS database?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Ackermann" <brian.ackermann@.gmail.com> wrote in message
news:1127830923.220944.153010@.g44g2000cwa.googlegroups.com...
> Hello all.
> After suffering a complete RAID failure, I am now tasked with the
> responsibility of setting up reporting services again, on a new and
> different machine. I had been successful getting it running last time,
> so I figured this wouldn't be too much problem. The installation goes
> fine, until the end, when it reports that the service wont start for
> the first time.
> As for information. Server2003-sp1. For the ReportServer Windows
> service I'm using account (NT AUTHORITY\NETWORK SERVICE). I've left
> virtual directories the same, except that I've disabled SSL
> connections. The Database is running locally, and for the runtime
> connection credentials, I've chosen to use a Domain User Account (set
> up especially for this purpose) "RSExec".
> As I said, the install goes fine, but fails. The only thing I can
> think of is that maybe my new RSExec user needs more permission than a
> standard user. But I've read the books (Lachev, and Blackburn &
> Vaughn), as well as the BOL, and I can't find any indication of what I
> might be missing.
> Opening the //machine/ReportServer page, I get the following error
> message:
> * The report server cannot open a connection to the report server
> database. The logon failed. (rsReportServerDatabaseLogonFailed) Get
> Online Help
> o Logon failure: the user has not been granted the requested logon
> type at this computer.
> The error message from the log shows:
> w3wp!ui!dc0!9/27/2005-08:25:37:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server cannot
> open a connection to the report server database. The logon failed. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseLogonFailedException:
> The report server cannot open a connection to the report server
> database. The logon failed. -->
> System.Runtime.InteropServices.COMException (0x80070569): Logon
> failure: the user has not been granted the requested logon type at this
> computer.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr&
> pImpToken)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetImpersonationToken(String
> userName, String domain, String userPwd)
> -- End of inner exception stack trace --
> Thanks for all your help. It is sincerely appreciated.
> Brian Ackermann
>|||Daniel,
Thanks for the reply.
As far as I can tell, the installer gives the RSExec user permissions
on the database. I must be missing it if there was something else.
There was a user called RSExec intalled on the database, with what
appeared to be appropriate values.
Can you be more explicit as to what settings exactly need to be set.
I'm sure its quite simple, and that I'm just not seeing it.
Thanks
Brian Ackermann|||From the look of the call stack, it appears that you are using a domain
account to talk to the RS database server. It doesn't appear that user has
permission to logon to the RS box. You should verify if that is the case.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Ackermann" <brian.ackermann@.gmail.com> wrote in message
news:1127939219.565435.135110@.o13g2000cwo.googlegroups.com...
> Daniel,
> Thanks for the reply.
> As far as I can tell, the installer gives the RSExec user permissions
> on the database. I must be missing it if there was something else.
> There was a user called RSExec intalled on the database, with what
> appeared to be appropriate values.
> Can you be more explicit as to what settings exactly need to be set.
> I'm sure its quite simple, and that I'm just not seeing it.
> Thanks
> Brian Ackermann
>

New Installation

Windows 2003 Advanced Server
SQL Server 2K sp3a
There was an existing reporting services database on the SQL Server
Instance. Tried to perform an new install of Reporting Services and point to
this existing database, ReportServer DB. Installation was successful.
However, RS would not activate becuase it thought I was adding to a WEB Farm.
To acivate I needed to run rsactivate from the active RS Server, there was
none. Decided to remove the databases and RS and start clean. Now, everytime
I try to install RS its trying to point to a database that does not exist and
the installation fails. Can anyone help?
ThanksWhat do you mean it tries to point to a DB that doesn't exist? During setup
you can specify a DB that does not exist, it should then create that DB.
What error are you getting?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> Windows 2003 Advanced Server
> SQL Server 2K sp3a
> There was an existing reporting services database on the SQL Server
> Instance. Tried to perform an new install of Reporting Services and point
> to
> this existing database, ReportServer DB. Installation was successful.
> However, RS would not activate becuase it thought I was adding to a WEB
> Farm.
> To acivate I needed to run rsactivate from the active RS Server, there was
> none. Decided to remove the databases and RS and start clean. Now,
> everytime
> I try to install RS its trying to point to a database that does not exist
> and
> the installation fails. Can anyone help?
> Thanks|||I know its suppose to create the database if it does not exist. The error is
"Database ReportServer does not exist".
"Daniel Reib [MSFT]" wrote:
> What do you mean it tries to point to a DB that doesn't exist? During setup
> you can specify a DB that does not exist, it should then create that DB.
> What error are you getting?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> > Windows 2003 Advanced Server
> > SQL Server 2K sp3a
> >
> > There was an existing reporting services database on the SQL Server
> > Instance. Tried to perform an new install of Reporting Services and point
> > to
> > this existing database, ReportServer DB. Installation was successful.
> > However, RS would not activate becuase it thought I was adding to a WEB
> > Farm.
> > To acivate I needed to run rsactivate from the active RS Server, there was
> > none. Decided to remove the databases and RS and start clean. Now,
> > everytime
> > I try to install RS its trying to point to a database that does not exist
> > and
> > the installation fails. Can anyone help?
> >
> > Thanks
>
>|||At what point in setup do you get this? Have you tried changing the DB
name?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
>I know its suppose to create the database if it does not exist. The error
>is
> "Database ReportServer does not exist".
> "Daniel Reib [MSFT]" wrote:
>> What do you mean it tries to point to a DB that doesn't exist? During
>> setup
>> you can specify a DB that does not exist, it should then create that DB.
>> What error are you getting?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "FredG" <FredG@.discussions.microsoft.com> wrote in message
>> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
>> > Windows 2003 Advanced Server
>> > SQL Server 2K sp3a
>> >
>> > There was an existing reporting services database on the SQL Server
>> > Instance. Tried to perform an new install of Reporting Services and
>> > point
>> > to
>> > this existing database, ReportServer DB. Installation was successful.
>> > However, RS would not activate becuase it thought I was adding to a WEB
>> > Farm.
>> > To acivate I needed to run rsactivate from the active RS Server, there
>> > was
>> > none. Decided to remove the databases and RS and start clean. Now,
>> > everytime
>> > I try to install RS its trying to point to a database that does not
>> > exist
>> > and
>> > the installation fails. Can anyone help?
>> >
>> > Thanks
>>|||Hello Daniel,
After I have completed all the setup questions then selected next. The
installation was running fine then it bombed out with that message. I was
able to track down the log file located in the C:\Progam Files\Microsoft SQL
Server\80\RS Setup Bootstrap\Log directory. I noticed that the account RS
setup was trying to use to create the database was DOMAIN\SERVER_NAME$, (I
believe this occured becuase I was running the Windows service under NT
AUTHORITY\NETWORK SERVICE). Once I added this account to SQL server and
granted CREATE DATABASE it worked fine. I have done other installs of RS and
never ran into this problem.
Thanks
"Daniel Reib [MSFT]" wrote:
> At what point in setup do you get this? Have you tried changing the DB
> name?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
> >I know its suppose to create the database if it does not exist. The error
> >is
> > "Database ReportServer does not exist".
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> What do you mean it tries to point to a DB that doesn't exist? During
> >> setup
> >> you can specify a DB that does not exist, it should then create that DB.
> >> What error are you getting?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> >> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> >> > Windows 2003 Advanced Server
> >> > SQL Server 2K sp3a
> >> >
> >> > There was an existing reporting services database on the SQL Server
> >> > Instance. Tried to perform an new install of Reporting Services and
> >> > point
> >> > to
> >> > this existing database, ReportServer DB. Installation was successful.
> >> > However, RS would not activate becuase it thought I was adding to a WEB
> >> > Farm.
> >> > To acivate I needed to run rsactivate from the active RS Server, there
> >> > was
> >> > none. Decided to remove the databases and RS and start clean. Now,
> >> > everytime
> >> > I try to install RS its trying to point to a database that does not
> >> > exist
> >> > and
> >> > the installation fails. Can anyone help?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>

New install shows nothing when I go to http://localhost/reportserver

I get a page that looks like a directory browsing page and it says

Microsoft SQL Server Reporting Services Version 9.00.1399.00

at the bottom. Any ideas?

report manager URL should be

http://localhost/reports

you can also select "Reporting Services Configuration Manager" from the start menu -> "Microsoft SQL Server 2005" -> "Configuration Tools" to view your virtual directory settings.

|||Duh. Thanks!

New Install Error

Hi,
I'm installing Reporting Services on our productions
server which is a domain controller, Windows 2003.
The database is on a different server, so it would be a
remote install of the databases. I keep getting error
messages that say 'can not create database'. I'm using sa
as a sql login, which has administrative rights.
Please let me know if you need anymore information.
Thanks in Advance,
MarciaBy default, setup uses the credentials of the user running setup to create
the report server database. The screen where you configure the report
server database only allows you to specify credentials the report server
uses to access the database (after setup is over).
To use a SQL login to create the report server database, you need to specify
RSSETUPACCOUNT and RSSETUPPASSWORD on the command line when running setup.
More info here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_6h6h.asp
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcia" <anonymous@.discussions.microsoft.com> wrote in message
news:461701c47332$7e57f870$a501280a@.phx.gbl...
> Hi,
> I'm installing Reporting Services on our productions
> server which is a domain controller, Windows 2003.
> The database is on a different server, so it would be a
> remote install of the databases. I keep getting error
> messages that say 'can not create database'. I'm using sa
> as a sql login, which has administrative rights.
> Please let me know if you need anymore information.
> Thanks in Advance,
> Marcia

New Install - Log Says Eval Expired, But It's Not an Eval

I have installed the standard edition of SQL2005 w Reporting Services on my XP Pro desktop. SQL2005 works fine, but SSRS will not. In the log, I see the message that the evaluation copy has expired--but the install is not an eval copy. I have tried uninstalling SQL Server a couple of times, but no change. Anyone know why this is happening?

What is the errors you are getting with trying to work with RS?

The message you see in the log file does not apply if you are installing any version except the Evaluation version.

|||Another log displays the message "object not set to instance of an object".