MS SQL2005 reporting Services + AD. Security question

Hi we run completely Windows shop. So Windows Authentication for Reporting Services is only acceptable solution. Idea is that I assign user in RS manager but they get their security check through AD using Cerberus or whatever it is. We did this setup for intranet web site which consist three machine

PC#1 Domain controller (AD)

PC#2 IIS (intranet web site)

PC#3 MS SQL server. (data)

People logon on web server newer asked for credentials on pull up data from SQL server though IIS being themselves, impersonation.

Now I have setup

PC#1 SSRS, IIS for Reports Server, MS SQL 2k5 for RS metadata etc

PC#2 Domain controller (AD)

PC#3 MS SQL2k (data)

I did same setspn procedure but when I tried to log on Report server it asked me for credentials. Moreover when I provide my logon and password it denies it, accepting only admin credentials.

I went trough few books, number article but nobody describe this scenario in spite it should be most popular solution if network based on Windows.

Any help is really appreciated

I am a way out of my league here, but I don't think it is the Report Server who prompts for credentials but IIS. If you create a web app in IIS configured for Windows authentiction and drop a simple html file in it, i bet you will be prompted for when you try to browse it. As far as what's causing it (excluding configuration issues), you may find the following article useful.|||

Teo,

Thanks a lot. I should read this article monthes ago. It is simple and nice compilation about delegation. I will try my luck with tweaking Report Server config and SPN.

I'll keep posting how I am doing, I think it will be helpfull for everybody who will decide to implement SSRS2k5 similar way

MS SQL Table JOIN with Oracle Table

I've got an Oracle table that I need to JOIN with a SQL table, and I've created the two datasets to pull the data I need. Is there any way Reporting Services can put them together for me?

No, SSRS cannot join data in two datasets.

Why not link your Oracle table into SQL, then write a view JOINing the data there...you could then provide the view to SSRS as a data source...

|||We tried it, but it was way slow. It also means installing the Oracle client on the SQL box and we're trying to avoid that if we can for security reasons.|||Not too much else you can do -- Although you could store your Oracle data in an SSRS cube...as long as the data wasn't too dynamic could get a good response that way at the cost of having to copy data over in the first place

MS SQL Server 2005 June CTP Setup Error

Hello,
I'm trying to setup MS SQL Server 2005 June CTP. Everything seemed to be
fine except Reporting Services failed to install, blow is the Setup Log with
the section that has the relavent failure:
CreateAspApp: start time: 11:44:01
CreateAspApp: CustomActionData: /LM/W3SVC/1/Root/Reports
CreateAspApp: Error 0x8004e00f: failed to create web application:
/LM/W3SVC/1/Root/Reports
MSI (s) (38!B0) [11:44:12:625]: Product: Microsoft SQL Server 2005 Reporting
Services CTP -- Error 25619. The setup failed to create web application:
/LM/W3SVC/1/Root/Reports. The error code is -2147164145.
Error 25619. The setup failed to create web application:
/LM/W3SVC/1/Root/Reports. The error code is -2147164145.
CreateAspApp: end time: 11:44:12, elapsed: 38475601.000000 (seconds)
Can someone shed some light on this?
--
GeorgeWorked fine for me.
--
Thanks,
ID
"George P boutwell" wrote:
> Hello,
> I'm trying to setup MS SQL Server 2005 June CTP. Everything seemed to be
> fine except Reporting Services failed to install, blow is the Setup Log with
> the section that has the relavent failure:
> CreateAspApp: start time: 11:44:01
> CreateAspApp: CustomActionData: /LM/W3SVC/1/Root/Reports
> CreateAspApp: Error 0x8004e00f: failed to create web application:
> /LM/W3SVC/1/Root/Reports
> MSI (s) (38!B0) [11:44:12:625]: Product: Microsoft SQL Server 2005 Reporting
> Services CTP -- Error 25619. The setup failed to create web application:
> /LM/W3SVC/1/Root/Reports. The error code is -2147164145.
> Error 25619. The setup failed to create web application:
> /LM/W3SVC/1/Root/Reports. The error code is -2147164145.
> CreateAspApp: end time: 11:44:12, elapsed: 38475601.000000 (seconds)
> Can someone shed some light on this?
> --
> George|||Great! Now if only I could get it to work for me, I could get back to real
coding and getting some real work done...
I did some digging there isn't really and 2005 documentation that covers
this problem, there is some SQL 2000 that says to ensure the
IWAM_computername user isn't disabled and the DTC (Distributed Transaction
Coordinator) service is running. That could be my problem DTC is not
running, however, when I try to run it it gives me an error:
The Distributed Transaction Coordinator service terminated with
service-specific error 3221229584 (0xC0001010).
So I'm back to still not able to do it. :(
--
George
"exkievan" wrote:
> Worked fine for me.
> --
> Thanks,
> ID
>
> "George P boutwell" wrote:
> > Hello,
> >
> > I'm trying to setup MS SQL Server 2005 June CTP. Everything seemed to be
> > fine except Reporting Services failed to install, blow is the Setup Log with
> > the section that has the relavent failure:
> >
> > CreateAspApp: start time: 11:44:01
> > CreateAspApp: CustomActionData: /LM/W3SVC/1/Root/Reports
> > CreateAspApp: Error 0x8004e00f: failed to create web application:
> > /LM/W3SVC/1/Root/Reports
> > MSI (s) (38!B0) [11:44:12:625]: Product: Microsoft SQL Server 2005 Reporting
> > Services CTP -- Error 25619. The setup failed to create web application:
> > /LM/W3SVC/1/Root/Reports. The error code is -2147164145.
> >
> > Error 25619. The setup failed to create web application:
> > /LM/W3SVC/1/Root/Reports. The error code is -2147164145.
> > CreateAspApp: end time: 11:44:12, elapsed: 38475601.000000 (seconds)
> >
> > Can someone shed some light on this?
> >
> > --
> > George|||On Wed, 22 Jun 2005 06:31:08 -0700, George P Boutwell wrote:
> Great! Now if only I could get it to work for me, I could get back to real
> coding and getting some real work done...
> I did some digging there isn't really and 2005 documentation that covers
> this problem, there is some SQL 2000 that says to ensure the
> IWAM_computername user isn't disabled and the DTC (Distributed Transaction
> Coordinator) service is running. That could be my problem DTC is not
> running, however, when I try to run it it gives me an error:
> The Distributed Transaction Coordinator service terminated with
> service-specific error 3221229584 (0xC0001010).
> So I'm back to still not able to do it. :(
I tried several searches on KnowledgeBase and come-up empty, till I tried
an search on service-specified error 3221229584, which produced the
following:
http://news.gmane.org/gmane.linux.colinux.devel/cutoff=2420
this seemed to have fixed my DTC service, it now runs as expected. And
after uninstalling, rebooting, and re-installing SQL Server 2005 June CTP,
I now have the Report Services working.
Georgesql

MS SQL Server 2005 Express Edition and Reporting Services question...

Will my reports that I have created with "Microsoft SQL Server
Reporting Services Designers
Version" (This is the free RS designer) work on my new website with
SQL Server 2005 Express?
What I'm saying is, Can my website work with:
SQL Server 2005 Express Edition?
SQL Server "Express" Reporting Services?
Thanks for any help.
TrintNot sure about the version you are talking about. Is it the developers
version? There are very few differences between versions. Most differences
is not the report itself but other things like data driven subscriptions. A
report is the same between versions.
The main issue with SQL Server Express Reporting Services is not the report
you designed but other limitations such as where the data resides. If you
data is in Express Edition then you are fine. If you are wanting to report
off of data on another SQL Server box then you will have problems.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1184073842.297362.294370@.n2g2000hse.googlegroups.com...
> Will my reports that I have created with "Microsoft SQL Server
> Reporting Services Designers
> Version" (This is the free RS designer) work on my new website with
> SQL Server 2005 Express?
> What I'm saying is, Can my website work with:
> SQL Server 2005 Express Edition?
> SQL Server "Express" Reporting Services?
> Thanks for any help.
> Trint
>|||On Jul 10, 9:37 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Not sure about the version you are talking about. Is it the developers
> version? There are very few differences between versions. Most differences
> is not the report itself but other things like data driven subscriptions. A
> report is the same between versions.
> The main issue with SQL Server Express Reporting Services is not the report
> you designed but other limitations such as where the data resides. If you
> data is in Express Edition then you are fine. If you are wanting to report
> off of data on another SQL Server box then you will have problems.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1184073842.297362.294370@.n2g2000hse.googlegroups.com...
>
> > Will my reports that I have created with "Microsoft SQL Server
> > Reporting Services Designers
> > Version" (This is the free RS designer) work on my new website with
> > SQL Server 2005 Express?
> > What I'm saying is, Can my website work with:
> > SQL Server 2005 Express Edition?
> > SQL Server "Express" Reporting Services?
> > Thanks for any help.
> > Trint- Hide quoted text -
> - Show quoted text -
I was just wondering if it is limited to local instead of being able
to work as the paid version across the internet.
Thanks,
Trint|||Feature differences:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
If you are trying to do this over the internet then you need custom
authentication which is not express. You need at least workgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1184077157.243178.67010@.g4g2000hsf.googlegroups.com...
> On Jul 10, 9:37 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Not sure about the version you are talking about. Is it the developers
>> version? There are very few differences between versions. Most
>> differences
>> is not the report itself but other things like data driven subscriptions.
>> A
>> report is the same between versions.
>> The main issue with SQL Server Express Reporting Services is not the
>> report
>> you designed but other limitations such as where the data resides. If you
>> data is in Express Edition then you are fine. If you are wanting to
>> report
>> off of data on another SQL Server box then you will have problems.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1184073842.297362.294370@.n2g2000hse.googlegroups.com...
>>
>> > Will my reports that I have created with "Microsoft SQL Server
>> > Reporting Services Designers
>> > Version" (This is the free RS designer) work on my new website with
>> > SQL Server 2005 Express?
>> > What I'm saying is, Can my website work with:
>> > SQL Server 2005 Express Edition?
>> > SQL Server "Express" Reporting Services?
>> > Thanks for any help.
>> > Trint- Hide quoted text -
>> - Show quoted text -
> I was just wondering if it is limited to local instead of being able
> to work as the paid version across the internet.
> Thanks,
> Trint
>

MS SQL Server 2005 Express Edition and Reporting Services

Hi,

Is it possible to use third party controls for reporting services, such as Dundas Chart for Reporting Services, in MS SQL Server 2005 Express Edition?

Thank you in advance.

Goran

No, this kind of extensibility functionality is not supported in the Express Edition.

-- Robert

sql

MS SQL Server 2005 Database Documenter

I have started a Reporting Service project called "SQLDB.Documenter" that can be used to document databases hosted on MS SQL Server 2005. Now, the project is in its alpha phase. I am willing to give it out to people who might be interested to give it a try. It can only document MS SQL Server 2005 databases and requires SQL Server Reporting Services to run it.

Please contact me directly if you are interested and want to give it a try. Any suggestions and/or feedbacks will be highly appreciated.

My e-mail address is <George.Liu@.iko.com>.

Good to hear. You may also want to post this in the Reporting Services area, since this one deals primarily with documentation.

sql

MS SQL Server 2005 Database Documenter

I have started a Reporting Service project called "SQLDB.Documenter" that can be used to document databases hosted on MS SQL Server 2005. Now, the project is in its alpha phase. I am willing to give it out to people who might be interested to give it a try. It can only document MS SQL Server 2005 databases and requires SQL Server Reporting Services to run it.

Please contact me directly if you are interested and want to give it a try. Any suggestions and/or feedbacks will be highly appreciated.

My e-mail address is <George.Liu@.iko.com>.

Good to hear. You may also want to post this in the Reporting Services area, since this one deals primarily with documentation.

MS SQL Reporting Services Server - Activation errors

When running the following:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsactivate -c
"C:\Program Files\Microsoft SQL
Server\MSSQL\ReportingServices\ReportServer\RSRepo rtServer.co
nfig" -t

I get the following error:

Failure starting the web service:
System.Exception: The local NT Service is disabled 0x80090005 -->
System.E
xception: 0x80090005
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate. RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate. InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLin eMain(String[]
args, BaseCmdLine instance)
Any insight into this. What am I doing wrong."moedap" <moedap@.yahoo.com> wrote in message
news:1105721152.907594.241730@.c13g2000cwb.googlegr oups.com...
> When running the following:
>
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsactivate -c
> "C:\Program Files\Microsoft SQL
> Server\MSSQL\ReportingServices\ReportServer\RSRepo rtServer.co
> nfig" -t
>
> I get the following error:
> Failure starting the web service:
> System.Exception: The local NT Service is disabled 0x80090005 -->
> System.E
> xception: 0x80090005
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate. RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate. InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLin eMain(String[]
> args, BaseCmdLine instance)
> Any insight into this. What am I doing wrong.

See this thread for one possible reason:

http://groups.google.ch/groups?hl=e...FTNGP09.phx.gbl

Simon

MS SQL Reporting Services 2000

---

Hi, Everybody.

I'm new to MS SQL Reporting services, and i've got some troubles with it. I cannot integrate my report with the site. I've tried to do it in such two ways:
1) using ReportViewer control. But the server where report is stored need authentication, and this control doen't supports it. So every time someone viewed the report authenication screen appeared. And also no images where shown on this report.
2) using Render method. Now i have NO troubles with authentication and with images. It's all great. But there is no Toolbar at the top of the screen where u could export to different formats. But i really need this toolbar. I pass "<DeviceInfo><Toolbar>true</Toolbar>.....</DeviceInfo>" parameter to Render method but still no luck!

Can someone give me some hints about it?
Maybe it is better to do it via ICQ - 237551782

Thanks,

The XML Tags are case sensitive.

Try:

<DeviceInfo><Toolbar>True</Toolbar></DeviceInfo>

|||Are u sure about it? That this is supposed to work? I've tried it, but no result anyway!!!

MS SQL Reporting Service in Windows 2003 Server

Hi,

I tried to Develop one Report in SQL Reporting Service. I have
installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
Database is in another machine, running on Windows 2000. I developed
and deployed the report and all went fine.

When I tried to see the report through the Report Service Manager Web
Page it is comming properly. But When I tried to See the report in
another web page, I'm not able to see the images. But the Data is
getting Displayed and only Image is not comming. When I exported the
report to Excel, the Image is comming over there.

I am using Report Viewer control (Which came as Sample Program) in
the ASPX Page to render the report. I'm using SQL Server 2000 with SP3a
and SQL Server 2000 reporting Service with SP1.

I tried setting the Mime Time for the GIF image and even "*.*" in
the Mime Type settings of IIS 6.0. Even then its not displaying the
image.

Can any one help me out in solving the problem?

Thanks in Advance.

With Regds
KrishRS sp2 is an option. There have been a lot of fixes, but I can't tell if
this specific one was in it.

Regards
----------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@.epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Krish" <jmkrish@.gmail.com> wrote in message
news:1122361416.772274.179410@.g14g2000cwa.googlegr oups.com...
> Hi,
> I tried to Develop one Report in SQL Reporting Service. I have
> installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
> Database is in another machine, running on Windows 2000. I developed
> and deployed the report and all went fine.
> When I tried to see the report through the Report Service Manager Web
> Page it is comming properly. But When I tried to See the report in
> another web page, I'm not able to see the images. But the Data is
> getting Displayed and only Image is not comming. When I exported the
> report to Excel, the Image is comming over there.
> I am using Report Viewer control (Which came as Sample Program) in
> the ASPX Page to render the report. I'm using SQL Server 2000 with SP3a
> and SQL Server 2000 reporting Service with SP1.
> I tried setting the Mime Time for the GIF image and even "*.*" in
> the Mime Type settings of IIS 6.0. Even then its not displaying the
> image.
> Can any one help me out in solving the problem?
> Thanks in Advance.
> With Regds
> Krish

MS RS Reportviewer, sparklines and bullet graphs in the report.

Hello All,

For a new reporting project compact we are using MS Reporting Services and hosting the report in an ASP.NET reportviewer.

"Tufte-like" and very clean, simple data visualizations as sparklines and bullet graphs have become a requirement.

We've had some success redering these in ASP but it's become necessary to render them in the reports themselves and we have not found a good way to do it.
Even third party charting products do not seem to support RS very much, one that does requires it on top of analysis services and their sparklines are actually defined in the KPI-s, but we are not using AS.

Have any of you had reports inspired by Tufte or Few and implemented it,
how did you manage it?

as always, your help is greatly appreciated!

Edward Tufte reports!!! Great way to go!

I did some a while back - basically, take a regular column chart and strip away everything from it:

Chart Area - no border/line, no fill
Plot Area - no border/line, no fill
Axis - no labels, no scales, no tickmarks
No Legend
The Palette doesn't have enough options, but the default is best

If you are doing comparisons against, say regions or products, create a separate column chart for each. Keep them the same scale, and lined up (stacked).

You really can do a lot of nice Sparklines using SSRS.

Good luck.