Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts

Thursday, March 29, 2012

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

sql

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Directing batch pring jobs to a remote printer

Has anyone tried directing batch sql reporting services print jobs to a remote printer? Any tips on how to do this would be appreciated.
Thanks,
John

Take a look at the printer delivery extension that is included with the product.

Directing batch pring jobs to a remote printer

Has anyone tried directing batch sql reporting services print jobs to a remote printer? Any tips on how to do this would be appreciated.
Thanks,
John

Take a look at the printer delivery extension that is included with the product.

Direct Printing

Hallo,
we have a Windows Application in .Net.
Now we want to use Reporting Services. That is no problem.
But how we can print direct on a client pc?Hi sqlhaas,
You can do this by installing a new printer extension for RS. Take a look
at this article (under Yesterday's QOD):
http://www.sqlservercentral.com/newsletter/452004newsletter.htm
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
sqlhaas wrote:
> Hallo,
> we have a Windows Application in .Net.
> Now we want to use Reporting Services. That is no problem.
> But how we can print direct on a client pc?|||Check Bryan's log http://blogs.msdn.com/bryanke/articles/71491.aspx.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Jake Marx" <msnews@.longhead.com> wrote in message
news:u%23nFdEQvEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi sqlhaas,
> You can do this by installing a new printer extension for RS. Take a look
> at this article (under Yesterday's QOD):
> http://www.sqlservercentral.com/newsletter/452004newsletter.htm
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> sqlhaas wrote:
> > Hallo,
> > we have a Windows Application in .Net.
> > Now we want to use Reporting Services. That is no problem.
> > But how we can print direct on a client pc?
>

Tuesday, March 27, 2012

Dimensional Modelling and Userbased Reporting

We are using SSAS 2005 for the cubes and reports will be created in Reporting Services as well as Proclarity Desktop Professional (all using windows integrated authentication). The reports will be displayed using a Sharepoint portal, again using the windows integrated authentication.

We have a Fact Table like FactRevenues which has revenueamount and a few other measures.

It is linked to 2 Dimension tables - DimProjects and DimCustomers through ProjectCode and CustomerCode.

DimProjects contains 2 dimension fields (apart from many others) - ProjectMgr and ProjectDir.

Similarly DimCustomers contains 3 fields - AccountMgr,AccountDir and EngagementDir.

We have an User Dimension which is the referenced dimension. DimUser contains UserID and other details of the user. We store the NT login(or at least something from which NT login can be obtained) in the UserID.

The five fields mentioned above - ProjectMgr, ProjectDir,AccountMgr, AccountDir and EngagementDir stores the UserID and are linked to the UserID in the User Dimension.

We have created hierarchies/pseudo dimensions which link like RevenueFact-ProjectMgr-User, RevenueFact-ProjectDir-User, RevenueFact-AccountMgr-User,RevenueFact-AccountDir-User and RevenueFact-EngagementDir-User. So, for the MDX expression we can use these to check against the logged in User.

The Problem:

Our requirement is, the person logged in should be able to see only the details (measure values) that are relevant to him/her. Basically, the aggregate of RevenueAmount should be done based on the following conditions:

If the logged in user is a Project Manager for some projects, then the person should only be able to see the aggregated measure for the projects for which he/she is the manager (checked from the ProjectMgr field). Similarly for ProjectDir.

If the logged in user is an Account Manager for some clients, then the person should only be able to see the aggregated measure for the clients that he/she handles (checked from the AccountMgrfield). Similarly for AccountDir and EngagementDir.

There are possibilities, though remote, that a single person can be AccountDir as well as ProjectDir. Basically, the system should support the possiblity for a person to be in any combination of the five fields. This shouldn't be an issue as this will be taken care of automatically once we set up the dynamic dimension security for each of these dimensions.

There will a different set of users - SuperUser/Admins - who will be able to view all the details without any restrictions. We HAVE NO ISSUES WITH THIS AS we created a role specifically for Admins without any restrictions and a role for others (everyone) which will be applied with the dynamic dimension security.

What we tried:

We have actually gone through the links that you have sent earlier, when we were trying to solve the issue. But it seems like we are missing some small thing.

Our MDX for dimension security

Filter( [DIMIRLINE -IR FORM REF NO - IR H CUST - ACCOUNT MGR].[DIMUSERS].[DIMUSERS] = UserName)

UserName supposedly being the function for obtaining the currently logged in user.

But this didn’t seem to restrict the users.

Your syntax for the filter function does not look correct. You need to pass it a set and then the criteria with which to filter that set. I would expect to see something more like the following:

Filter(

[DIMIRLINE -IR FORM REF NO - IR H CUST - ACCOUNT MGR].[DIMUSERS].[DIMUSERS].members

, [DIMIRLINE -IR FORM REF NO - IR H CUST - ACCOUNT MGR].[DIMUSERS].[DIMUSERS].CurrentMember.Name = UserName()

)

|||

This following is the table I created through SSAS browser having UserID,EGName and Mothwisesales Column

where USerID is the member of [Account Mgr].[UsersID] Attribute

I want to show the only row when perticalur User LogsIn(NTlogin) insted of showing the details of all User.He should see only his details(I want to restrict this in Cube level rather on SSRS/Proclarity).

I created a Hierachy i.e UserHierachy -->Role->UserID

Role attribute always contains{User,Manager}.If UserID is belongs to User Role He ll be see only his details from NTLogin and if UserID is belongs to ManagerRole He ll be see all the userdetails.

Please help me regarding this.

Thank u

with regards

Saroj

userID

Mar

chandrashekar.cs

EG11

$700.00

EG12

$495.63

EG14

$1,500.00

EG21

$15,600.83

EG24

$0.83

EG26

$8,726.37

EG34

$2,103.34

EG39

$300.00

EG3P

$197.55

EG41

$5,866.68

EG42

$16,900.00

EG51

$2,200.00

EG52

$1,400.83

EG53

$0.00

EG61

$11,757.92

EG62

$199.96

EG65

$363.40

EG72

$3,400.00

EG74

$2,400.00

madhankumar.s

$228,385.98

ramaprasath.mss

$6,402.35

sarojkumar.nishanka

$6,308.43

sethumadhavan.sb

$284,112.19

sql

Sunday, March 25, 2012

dimension security doesn't work when you use {}

I think this is a bug, but I want to check that I've understood the expected behavior before reporting it.

1. Build a Geography dimension where the key attribute is City. Also add a State attribute.

2. Define dimension security for the Geography.City attribute and make the allowed set {Geography.City.Dallas}

3. When I run an MDX query with Geography.City.Members it returns only Dallas as expected

4. When I run an MDX query with Geography.State.Members it returns only Texas as expected.

5. Change the allowed set for Geography.City to be {} (that is, empty set)

6. When I run an MDX query with Geography.City.Members is returns empty set as expected

7. When I run an MDX query with Geography.State.Members is returns ALL STATES!! Is this a bug?

The real scenario behind this is dynamic security. If the allowed set MDX expression returns empty set, then I get the behavior described in step 7 for all the non-key attributes in that dimension. The only way I've been able to workaround this is to change the expression to return some bogus member like [Geography].[City].&[DOES NOT EXIST] instead of empty set. (Or I can make the allowed set on all attributes {})

I beleive that what you observe is the designed behavior of the system. I don't beleive that you will be able to use [Geography].[City].&[DOES NOT EXIST] instead of empty set, since inside dimension security MdxMissingMemberMode is always set to Error, so you will get error instead. I beleive that your scenario with dynamic security will work fine though, as long as expressions for allowed set preserve hierarchility properly, even if they result in empty set.|||

I want to use empty set. However I do not get the desired results (allowing this user to see no members of a dimension) when I use empty set.

However, when I use [Geography].[City].&[DOES NOT EXIST] then I DO get the desired results. I can't explain why it works, but it does.

Thursday, March 22, 2012

Dimension as Parameter in Reporting Services

Hallo everyone:

I am using reporting services and I am looking for a way to define a parameter “dimension”.

The problem is that in Reporting services are available just the fields resulting from the mdx statement.

Using the following statement I can use the fields “value” and “Customer”

Select {[Measures].[value]} on 0, {[Customer].allmembers} on 1 From [Cube1]

I could solve it like this

Select {[Measures].[value]} on 0,

Iif(@.DimParameter = “Customer”,

{[Customer].allmembers} [Cube1],

{[Products].allmembers})

on 1 From

but the fields available would be “value” and “Customer” if the standard value of @.DimParameter is “Customer”


I also tried to create a set but I got the same results.

Is there a function in mdx that works like sql to define the names of the retrieved fields?


Select Customer as myDim Fom table1

Thanks

I tried to do that a while ago, and ended up creating a sproc in SQL Server that connects to Analysis Services using OPENQUERY.

Something like this:

create proc Example

@.dimension varchar(1000)

as

declare @.sql as varchar(8000)

declare @.mdx as varchar(2300)

set @.mdx = 'select {[Measures].[Unit Sales]} on columns, {##rows##} on rows from Sales'

set @.mdx = replace(@.mdx, '##rows##', @.dimension)

set @.sql ='SELECT * FROM OpenRowset(''MSOLAP.3'',''DATASOURCE=localhost; Initial Catalog=Foodmart 2000;'',

''' + @.mdx + ''')'

print @.sql

exec (@.sql)

If you're using SQL Server 2005 you'll need sp1 for this to work.

Hope this helps,

Santi

|||

Many, Many Thanks!

I tried you’re example but I could not referred to the fields in the select statement.

Instead of using selec * I would like to do something like: select [Customer].[Name] as myDim.

I couldn’t achieved it. So I am creating a temporal table, inserting the results from the select statement and selecting the temporal table:

CREATE TABLE #t(Dimension varchar(100), Measure varchar(100))
INSERT INTO #t
exec(@.sql)
select * from #t
drop table #t

It works.

How did you manage it? Is there an easier way ?

|||I forgot to mention it, I also used a temporal table. Don′t know if there is an easier way, but since this works I'm happy with it.|||

Hi

How do I have to configure the users security. In such a way that, they can access the report that uses the stored procedure with the openset function?

|||

That could be a problem. In my case I filter users out with Reporting Services security, and then grant execute permissions to the stored procedure to Reporting Services.

|||

How did you configure your users in the Data Base and in the Analysis Services. Because when I try the report i works fine. But when someone else try it, they cannot connect to AS. I have other reports that access AS and everyone can access them with any problem.

|||

I have a Windows Group with the users. This group is added to the pertinent role in Analysis Services, and to the role in Reporting Services.

However, I have the RS Data Origin configured using Sql Server Security instead of Windows Security, saving the credentials in the Report server. Of course the Sql Server login must have the relevant permissions to execute the Stored Proc, and to create temporal tables.

Bottom line:

One group with the users, added to the roles in AS and RS|||I dont have idea what is wrong. However Thanks!|||

It seems you need Administrator rights to perform Openrowset operations

see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=417389&SiteID=1

Dimension as Parameter in Reporting Services

Hallo everyone:

I am using reporting services and I am looking for a way to define a parameter “dimension”.

The problem is that in Reporting services are available just the fields resulting from the mdx statement.

Using the following statement I can use the fields “value” and “Customer”

Select {[Measures].[value]} on 0, {[Customer].allmembers} on 1 From [Cube1]

I could solve it like this

Select {[Measures].[value]} on 0,

Iif(@.DimParameter = “Customer”,

{[Customer].allmembers} [Cube1],

{[Products].allmembers})

on 1 From

but the fields available would be “value” and “Customer” if the standard value of @.DimParameter is “Customer”


I also tried to create a set but I got the same results.

Is there a function in mdx that works like sql to define the names of the retrieved fields?


Select Customer as myDim Fom table1

Thanks

I tried to do that a while ago, and ended up creating a sproc in SQL Server that connects to Analysis Services using OPENQUERY.

Something like this:

create proc Example

@.dimension varchar(1000)

as

declare @.sql as varchar(8000)

declare @.mdx as varchar(2300)

set @.mdx = 'select {[Measures].[Unit Sales]} on columns, {##rows##} on rows from Sales'

set @.mdx = replace(@.mdx, '##rows##', @.dimension)

set @.sql ='SELECT * FROM OpenRowset(''MSOLAP.3'',''DATASOURCE=localhost; Initial Catalog=Foodmart 2000;'',

''' + @.mdx + ''')'

print @.sql

exec (@.sql)

If you're using SQL Server 2005 you'll need sp1 for this to work.

Hope this helps,

Santi

|||

Many, Many Thanks!

I tried you’re example but I could not referred to the fields in the select statement.

Instead of using selec * I would like to do something like: select [Customer].[Name] as myDim.

I couldn’t achieved it. So I am creating a temporal table, inserting the results from the select statement and selecting the temporal table:

CREATE TABLE #t(Dimension varchar(100), Measure varchar(100))
INSERT INTO #t
exec(@.sql)
select * from #t
drop table #t

It works.

How did you manage it? Is there an easier way ?

|||I forgot to mention it, I also used a temporal table. Don′t know if there is an easier way, but since this works I'm happy with it.|||

Hi

How do I have to configure the users security. In such a way that, they can access the report that uses the stored procedure with the openset function?

|||

That could be a problem. In my case I filter users out with Reporting Services security, and then grant execute permissions to the stored procedure to Reporting Services.

|||

How did you configure your users in the Data Base and in the Analysis Services. Because when I try the report i works fine. But when someone else try it, they cannot connect to AS. I have other reports that access AS and everyone can access them with any problem.

|||

I have a Windows Group with the users. This group is added to the pertinent role in Analysis Services, and to the role in Reporting Services.

However, I have the RS Data Origin configured using Sql Server Security instead of Windows Security, saving the credentials in the Report server. Of course the Sql Server login must have the relevant permissions to execute the Stored Proc, and to create temporal tables.

Bottom line:

One group with the users, added to the roles in AS and RS|||I dont have idea what is wrong. However Thanks!|||

It seems you need Administrator rights to perform Openrowset operations

see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=417389&SiteID=1

sql

Digitally Signing

I have two questions.

1. Has anyone ever digitally signed a PDF coming out of Reporting Services?
2. When will you be able to generate a Word document from a Reporting Services Report?

Dave

Currently there is no real way to sign a PDF in the true sense of the word - The best you can really do is generate a hash off of the fully rendered PDF and then store the hash somewhere else...later you can use the hash to make sure the report hasn't been modified.

There is no ETA on SSRS being able to render to Word...SoftArtisans has a product which will do this now, though (http://officewriter.softartisans.com/)

Difficulty Installing SQL Reporting Services on SBS 2003 Premium

I am trying to run reporting services on a SBS 2003 Premium server and have
been runninng into a lot of issues.
I have installed the SQL Reporting Services Components on the server and the
Visual Studio .Net components on my workstation. The goal behind installing
the components in the specified locations include: report authoring on my
workstation and finished reports available to all via the server.
The issues I have encountered include:
1) SQL Reporting Services activation error due to a conflict with
Sharepoint. I have removed Sharepoint from the server as outlined in KB
829114. After completion of the Sharepoint removal, I reinstalled SQL
Reporting Services and Reporting Services SP2 and was again informed that
activation was not possible due to a conflict with Sharepoint. How do I
work around this problem?
2) When accessing SQL Reporting Services from Visual Studio .Net on my
workstation, I can open an existing project but I can't view content within
the data sources tab. When trying to do so I get an error that states: "A
connection cannot be made to the database. Set and test the connection
string. Can't generate the SSPI context. How do I resolve this problem?
3) When creating a new SQL Reporting Services project using the Report
Wizard, the Shared Data Source field is blank and unavailable. Likewise,
attempts to access shared data sources using the Server Explorer window
result in the system prompting for a login when I try to select a listed in
the tree under my server. I am unable to login using our available network
or SQL User IDs.
My server is running SBS 2003 SP1 which includes SQL 2000 SP4. My
workstation is a member of the domain for which the server is the PDC.
Is my topology realistic and can my problems resolved or should I relocate
all components to the server? Even if located on the server, I will still
encounter the activation problem and need a work around.
Thanks for your help!Hello RS,
A few weeks ago I wanted to order SQL Server Reporting Services on a CD vom
Microsoft Direct. At that occasion, they told me that Reporting Services
simply are not supported on SBS. Seems like MS wants you to by the full SQL
Server product if you want to use RS. But please re-check that with your
contacts.
Greetings,
Stefan Falk|||Hi Stefan,
Sehr interesant. I initially posted my issue in the SBS forum and was
instructed by Microsoft to post in the reporting services forum. No mention
was made of non-compatability and I have noticed from the SBS forum that
other SBS users are running reporting services. You should be able to get a
copy of the software from one of the US Microsoft resellers.
Take care,
RS
"Stefan Falk" wrote:
> Hello RS,
> A few weeks ago I wanted to order SQL Server Reporting Services on a CD vom
> Microsoft Direct. At that occasion, they told me that Reporting Services
> simply are not supported on SBS. Seems like MS wants you to by the full SQL
> Server product if you want to use RS. But please re-check that with your
> contacts.
> Greetings,
> Stefan Falk
>
>

Difficulty installing reporting services server

G'day,
I am trying to install reporting services (development version) on a
Windows 2000 Server, and the setup will not allow me to install the
server components as it says "Internet Information Services 5.0 (IIS)
or later is either not installed, or it is configured in a way that is
incompatible with a Reporting Services installation."
Below is the rsstp2.log which I managed to find.
Reading it, it appears to be saying that the IWAM_machineName account
does "Not exist or [is] not enable[d]". (It also says the VS is not
installed, which is okay, as I don't want to install the designer
components, only the server).
The machine has SQL, IIS, and all the service packs that I think it
requires, and when I check the account IWAM_A-External _does_ exist,
and is _not_ disabled (i.e. it is enabled).
Does anyone know what security settings the account needs, or any
reason why it is telling me the account does not exist?
Also, does it matter what the password for the IWAM_machineName
account is? (Note: the password is the same in the metabase and for
the account).
Can anyone provide more detail on exactly what checks are performed
for the RSACCOUNTS prerequisite?
Thanks in advance.
- Stephen Gryphon
START Corporation
=============================================================== Microsoft SQL Server 2000 Reporting Services Setup beginning at Fri
Jul 23 05:15:24 2004
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
<Func Name='WindowsInstallerComp::IsRequired'>
<Func Name='DotNetFxComp::Init'>
<Func Name='DotNetFxComp::IsRequired'>
<EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV\Setup\bootmsi.dat"
REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033"
/qn
<EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0,
is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup
mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED,
cancel_state=0, is_done=1, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
QuietMode=false
Unattended=false
WorkDir=C:\Temp
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Machine = A-EXTERNAL, Article = IIS, Result = 0 (0x0)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open
key" Expected="No error" Result="Fail" />
Machine = A-EXTERNAL, Article = VSNET, Result = 60351 (0xebbf)
Getting IIS Metabase data /LM/W3SVC/AppIsolated
Machine = A-EXTERNAL, Article = ASPNET, Result = 0 (0x0)
Machine = A-EXTERNAL, Article = MDAC, Result = 0 (0x0)
Machine = A-EXTERNAL, Article = DTC, Result = 0 (0x0)
Machine = A-EXTERNAL, Article = SERVEROS, Result = 0 (0x0)
Machine = A-EXTERNAL, Article = SHAREPOINT, Result = 0 (0x0)
Machine = A-EXTERNAL, Article = AUTHZ, Result = 0 (0x0)
<Prerequisite Name="AreRSAccountsValidInstalled" Checked="User
accounts" Item="IWAM_machineName" Found="Not exist or not enable"
Expected="Exist and enabled" Result="Fail" />
Machine = A-EXTERNAL, Article = RSACCOUNTS, Result = 60357 (0xebc5)
**************
A-EXTERNAL
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup
to install Report Designer. Or, continue Setup to complete the
installation without Report Designer.
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later
is either not installed, or it is configured in a way that is
incompatible with a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager
components, you must first install Internet Information Services 5.0
(IIS) or later, and then verify that the Web server configuration
requirements are compatible with Setup. Check the Setup documentation
for more information about Web server configuration requirements.
Report size = 1050
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS
Setup Bootstrap\LOG\RSStp_.cab"Check your Default web site is Started or not. Since I
got the the same problem and started my default web site
& everything is OK.
>--Original Message--
>G'day,
>I am trying to install reporting services (development
version) on a
>Windows 2000 Server, and the setup will not allow me to
install the
>server components as it says "Internet Information
Services 5.0 (IIS)
>or later is either not installed, or it is configured in
a way that is
>incompatible with a Reporting Services installation."
>Below is the rsstp2.log which I managed to find.
>Reading it, it appears to be saying that the
IWAM_machineName account
>does "Not exist or [is] not enable[d]". (It also says
the VS is not
>installed, which is okay, as I don't want to install the
designer
>components, only the server).
>The machine has SQL, IIS, and all the service packs that
I think it
>requires, and when I check the account IWAM_A-External
_does_ exist,
>and is _not_ disabled (i.e. it is enabled).
>Does anyone know what security settings the account
needs, or any
>reason why it is telling me the account does not exist?
>Also, does it matter what the password for the
IWAM_machineName
>account is? (Note: the password is the same in the
metabase and for
>the account).
>Can anyone provide more detail on exactly what checks
are performed
>for the RSACCOUNTS prerequisite?
>Thanks in advance.
>- Stephen Gryphon
> START Corporation
>
>===============================================================>Microsoft SQL Server 2000 Reporting Services Setup
beginning at Fri
>Jul 23 05:15:24 2004
><Func Name='UpdateComponents'>
>SCU_SetupMgr::InitComponents()
><Func Name='WindowsInstallerComp::Init'>
><Func Name='WindowsInstallerComp::IsRequired'>
><Func Name='DotNetFxComp::Init'>
><Func Name='DotNetFxComp::IsRequired'>
><EndFunc Name='DotNetFxComp::IsRequired' Return='F'
GetLastError='0'>
>SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0,
is_done=0,
>ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:414}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
><Func Name='SqlSetupFilesComp::Install'>
><Func Name='BootstrapPackageLogic'>
><Func Name='InstallBootstrapPackage'>
> /I "E:\ENGLISH\SQL2000
\REPORTING_SERVICES\DEV\Setup\bootmsi.dat"
>REBOOT="ReallySuppress"
>ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFi
les1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFile
s1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3
082,WatsonFiles1033"
>/qn
><EndFunc Name='InstallBootstrapPackage' Return='0'
GetLastError='183'>
><EndFunc Name='BootstrapPackageLogic' Return='0'
GetLastError='183'>
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>SCU_SetupMgr::InstallComponent state=INSTALL,
cancel_state=0,
>is_done=0, ActionRequired=1, NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:292}
>ScuProgressDlg::SetupFinished()
>ScuProgressDlg::DialogProc() installation done...
waiting for setup
>mgr
>SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED,
>cancel_state=0, is_done=1, ActionRequired=1,
NeedReboot=0,
>custom_props={AutoStart=true
>HandleReboots=false
>ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
>QuietMode=false
>Unattended=false
>WorkDir=C:\Temp
>}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
:420}
><EndFunc Name='UpdateComponents' Return='0'
GetLastError='183'>
><Func Name='DwLaunchMsiExec'>
><Func Name='PerformDetections'>
>0
><EndFunc Name='PerformDetections' Return='0'
GetLastError='0'>
>Machine = A-EXTERNAL, Article = IIS, Result = 0 (0x0)
><Prerequisite Name="IsVS71Installed" Checked="Registry"
>Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1"
Found="Can not open
>key" Expected="No error" Result="Fail" />
>Machine = A-EXTERNAL, Article = VSNET, Result = 60351
(0xebbf)
>Getting IIS Metabase data /LM/W3SVC/AppIsolated
>Machine = A-EXTERNAL, Article = ASPNET, Result = 0 (0x0)
>Machine = A-EXTERNAL, Article = MDAC, Result = 0 (0x0)
>Machine = A-EXTERNAL, Article = DTC, Result = 0 (0x0)
>Machine = A-EXTERNAL, Article = SERVEROS, Result = 0
(0x0)
>Machine = A-EXTERNAL, Article = SHAREPOINT, Result = 0
(0x0)
>Machine = A-EXTERNAL, Article = AUTHZ, Result = 0 (0x0)
><Prerequisite Name="AreRSAccountsValidInstalled"
Checked="User
>accounts" Item="IWAM_machineName" Found="Not exist or
not enable"
>Expected="Exist and enabled" Result="Fail" />
>Machine = A-EXTERNAL, Article = RSACCOUNTS, Result =60357 (0xebc5)
>**************
>A-EXTERNAL
>**************
>Report Designer component requirement
><B>Explanation:</B> Visual Studio .NET 2003 is not
installed.
><B>Action:</B> Install Visual Studio .NET 2003, and then
rerun Setup
>to install Report Designer. Or, continue Setup to
complete the
>installation without Report Designer.
>Report Server component requirement
><B>Explanation:</B> Internet Information Services 5.0
(IIS) or later
>is either not installed, or it is configured in a way
that is
>incompatible with a Reporting Services installation.
><B>Action:</B> To install the Report Server and Report
Manager
>components, you must first install Internet Information
Services 5.0
>(IIS) or later, and then verify that the Web server
configuration
>requirements are compatible with Setup. Check the Setup
documentation
>for more information about Web server configuration
requirements.
>Report size = 1050
><Func Name='FSetupLogging'>
><Func Name='CreateSetupLogCabs'>
>Creating Setup Logs Cab "C:\Program Files\Microsoft SQL
Server\80\RS
>Setup Bootstrap\LOG\RSStp_.cab"
>.
>|||I wish it was that simple.
Kavi -- did you just get the same on-screen message, which is rather
generic, or did you actually get the same prerequisite fail in your
log file (i.e. the '<Prerequisite
Name="AreRSAccountsValidInstalled"').
Can anyone provide more detail on what is checked for this
pre-requisite, as the account looks fine.
- Stephen Gryphon
"Kavi" <anonymous@.discussions.microsoft.com> wrote in message news:<282701c47088$d5ebf390$a401280a@.phx.gbl>...
> Check your Default web site is Started or not. Since I
> got the the same problem and started my default web site
> & everything is OK.
> >--Original Message--
> >G'day,
> >
> >I am trying to install reporting services (development
> version) on a
> >Windows 2000 Server, and the setup will not allow me to
> install the
> >server components as it says "Internet Information
> Services 5.0 (IIS)
> >or later is either not installed, or it is configured in
> a way that is
> >incompatible with a Reporting Services installation."
> >
> >Below is the rsstp2.log which I managed to find.
> >
> >Reading it, it appears to be saying that the
> IWAM_machineName account
> >does "Not exist or [is] not enable[d]". (It also says
> the VS is not
> >installed, which is okay, as I don't want to install the
> designer
> >components, only the server).
> >
> >The machine has SQL, IIS, and all the service packs that
> I think it
> >requires, and when I check the account IWAM_A-External
> _does_ exist,
> >and is _not_ disabled (i.e. it is enabled).
> >
> >Does anyone know what security settings the account
> needs, or any
> >reason why it is telling me the account does not exist?
> >
> >Also, does it matter what the password for the
> IWAM_machineName
> >account is? (Note: the password is the same in the
> metabase and for
> >the account).
> >
> >Can anyone provide more detail on exactly what checks
> are performed
> >for the RSACCOUNTS prerequisite?
> >
> >Thanks in advance.
> >
> >- Stephen Gryphon
> > START Corporation
> >
> >
> >=========================================================> ======> >Microsoft SQL Server 2000 Reporting Services Setup
> beginning at Fri
> >Jul 23 05:15:24 2004
> ><Func Name='UpdateComponents'>
> >SCU_SetupMgr::InitComponents()
> ><Func Name='WindowsInstallerComp::Init'>
> ><Func Name='WindowsInstallerComp::IsRequired'>
> ><Func Name='DotNetFxComp::Init'>
> ><Func Name='DotNetFxComp::IsRequired'>
> ><EndFunc Name='DotNetFxComp::IsRequired' Return='F'
> GetLastError='0'>
> >SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0,
> is_done=0,
> >ActionRequired=1, NeedReboot=0, custom_props=> {AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :414}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> ><Func Name='SqlSetupFilesComp::Install'>
> ><Func Name='BootstrapPackageLogic'>
> ><Func Name='InstallBootstrapPackage'>
> > /I "E:\ENGLISH\SQL2000
> \REPORTING_SERVICES\DEV\Setup\bootmsi.dat"
> >REBOOT="ReallySuppress"
> >ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFi
> les1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFile
> s1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3
> 082,WatsonFiles1033"
> >/qn
> ><EndFunc Name='InstallBootstrapPackage' Return='0'
> GetLastError='183'>
> ><EndFunc Name='BootstrapPackageLogic' Return='0'
> GetLastError='183'>
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >SCU_SetupMgr::InstallComponent state=INSTALL,
> cancel_state=0,
> >is_done=0, ActionRequired=1, NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :292}
> >ScuProgressDlg::SetupFinished()
> >ScuProgressDlg::DialogProc() installation done...
> waiting for setup
> >mgr
> >SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED,
> >cancel_state=0, is_done=1, ActionRequired=1,
> NeedReboot=0,
> >custom_props={AutoStart=true
> >HandleReboots=false
> >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> >QuietMode=false
> >Unattended=false
> >WorkDir=C:\Temp
> >}}
> {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> :420}
> ><EndFunc Name='UpdateComponents' Return='0'
> GetLastError='183'>
> ><Func Name='DwLaunchMsiExec'>
> ><Func Name='PerformDetections'>
> >0
> ><EndFunc Name='PerformDetections' Return='0'
> GetLastError='0'>
> >Machine = A-EXTERNAL, Article = IIS, Result = 0 (0x0)
> ><Prerequisite Name="IsVS71Installed" Checked="Registry"
> >Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1"
> Found="Can not open
> >key" Expected="No error" Result="Fail" />
> >Machine = A-EXTERNAL, Article = VSNET, Result = 60351
> (0xebbf)
> >Getting IIS Metabase data /LM/W3SVC/AppIsolated
> >Machine = A-EXTERNAL, Article = ASPNET, Result = 0 (0x0)
> >Machine = A-EXTERNAL, Article = MDAC, Result = 0 (0x0)
> >Machine = A-EXTERNAL, Article = DTC, Result = 0 (0x0)
> >Machine = A-EXTERNAL, Article = SERVEROS, Result = 0
> (0x0)
> >Machine = A-EXTERNAL, Article = SHAREPOINT, Result = 0
> (0x0)
> >Machine = A-EXTERNAL, Article = AUTHZ, Result = 0 (0x0)
> ><Prerequisite Name="AreRSAccountsValidInstalled"
> Checked="User
> >accounts" Item="IWAM_machineName" Found="Not exist or
> not enable"
> >Expected="Exist and enabled" Result="Fail" />
> >Machine = A-EXTERNAL, Article = RSACCOUNTS, Result => 60357 (0xebc5)
> >**************
> >A-EXTERNAL
> >**************
> >Report Designer component requirement
> ><B>Explanation:</B> Visual Studio .NET 2003 is not
> installed.
> ><B>Action:</B> Install Visual Studio .NET 2003, and then
> rerun Setup
> >to install Report Designer. Or, continue Setup to
> complete the
> >installation without Report Designer.
> >Report Server component requirement
> ><B>Explanation:</B> Internet Information Services 5.0
> (IIS) or later
> >is either not installed, or it is configured in a way
> that is
> >incompatible with a Reporting Services installation.
> ><B>Action:</B> To install the Report Server and Report
> Manager
> >components, you must first install Internet Information
> Services 5.0
> >(IIS) or later, and then verify that the Web server
> configuration
> >requirements are compatible with Setup. Check the Setup
> documentation
> >for more information about Web server configuration
> requirements.
> >Report size = 1050
> ><Func Name='FSetupLogging'>
> ><Func Name='CreateSetupLogCabs'>
> >Creating Setup Logs Cab "C:\Program Files\Microsoft SQL
> Server\80\RS
> >Setup Bootstrap\LOG\RSStp_.cab"
> >.
> >|||Stephen:
Have you made any progress? I am having the same issue with IIS and
IUSR/IWAM apparently configured correctly.
I am installing on a cluster and am using domain\IUSR... type accounts,
although the local accounts still exist. I am drawing a blank on all my
sources.
Richard
"Stephen Gryphon" wrote:
> I wish it was that simple.
> Kavi -- did you just get the same on-screen message, which is rather
> generic, or did you actually get the same prerequisite fail in your
> log file (i.e. the '<Prerequisite
> Name="AreRSAccountsValidInstalled"').
> Can anyone provide more detail on what is checked for this
> pre-requisite, as the account looks fine.
> - Stephen Gryphon
>
> "Kavi" <anonymous@.discussions.microsoft.com> wrote in message news:<282701c47088$d5ebf390$a401280a@.phx.gbl>...
> > Check your Default web site is Started or not. Since I
> > got the the same problem and started my default web site
> > & everything is OK.
> > >--Original Message--
> > >G'day,
> > >
> > >I am trying to install reporting services (development
> > version) on a
> > >Windows 2000 Server, and the setup will not allow me to
> > install the
> > >server components as it says "Internet Information
> > Services 5.0 (IIS)
> > >or later is either not installed, or it is configured in
> > a way that is
> > >incompatible with a Reporting Services installation."
> > >
> > >Below is the rsstp2.log which I managed to find.
> > >
> > >Reading it, it appears to be saying that the
> > IWAM_machineName account
> > >does "Not exist or [is] not enable[d]". (It also says
> > the VS is not
> > >installed, which is okay, as I don't want to install the
> > designer
> > >components, only the server).
> > >
> > >The machine has SQL, IIS, and all the service packs that
> > I think it
> > >requires, and when I check the account IWAM_A-External
> > _does_ exist,
> > >and is _not_ disabled (i.e. it is enabled).
> > >
> > >Does anyone know what security settings the account
> > needs, or any
> > >reason why it is telling me the account does not exist?
> > >
> > >Also, does it matter what the password for the
> > IWAM_machineName
> > >account is? (Note: the password is the same in the
> > metabase and for
> > >the account).
> > >
> > >Can anyone provide more detail on exactly what checks
> > are performed
> > >for the RSACCOUNTS prerequisite?
> > >
> > >Thanks in advance.
> > >
> > >- Stephen Gryphon
> > > START Corporation
> > >
> > >
> > >=========================================================> > ======> > >Microsoft SQL Server 2000 Reporting Services Setup
> > beginning at Fri
> > >Jul 23 05:15:24 2004
> > ><Func Name='UpdateComponents'>
> > >SCU_SetupMgr::InitComponents()
> > ><Func Name='WindowsInstallerComp::Init'>
> > ><Func Name='WindowsInstallerComp::IsRequired'>
> > ><Func Name='DotNetFxComp::Init'>
> > ><Func Name='DotNetFxComp::IsRequired'>
> > ><EndFunc Name='DotNetFxComp::IsRequired' Return='F'
> > GetLastError='0'>
> > >SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0,
> > is_done=0,
> > >ActionRequired=1, NeedReboot=0, custom_props=> > {AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :414}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > ><Func Name='SqlSetupFilesComp::Install'>
> > ><Func Name='BootstrapPackageLogic'>
> > ><Func Name='InstallBootstrapPackage'>
> > > /I "E:\ENGLISH\SQL2000
> > \REPORTING_SERVICES\DEV\Setup\bootmsi.dat"
> > >REBOOT="ReallySuppress"
> > >ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFi
> > les1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFile
> > s1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3
> > 082,WatsonFiles1033"
> > >/qn
> > ><EndFunc Name='InstallBootstrapPackage' Return='0'
> > GetLastError='183'>
> > ><EndFunc Name='BootstrapPackageLogic' Return='0'
> > GetLastError='183'>
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >SCU_SetupMgr::InstallComponent state=INSTALL,
> > cancel_state=0,
> > >is_done=0, ActionRequired=1, NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :292}
> > >ScuProgressDlg::SetupFinished()
> > >ScuProgressDlg::DialogProc() installation done...
> > waiting for setup
> > >mgr
> > >SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED,
> > >cancel_state=0, is_done=1, ActionRequired=1,
> > NeedReboot=0,
> > >custom_props={AutoStart=true
> > >HandleReboots=false
> > >ModuleDir=E:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV
> > >QuietMode=false
> > >Unattended=false
> > >WorkDir=C:\Temp
> > >}}
> > {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp
> > :420}
> > ><EndFunc Name='UpdateComponents' Return='0'
> > GetLastError='183'>
> > ><Func Name='DwLaunchMsiExec'>
> > ><Func Name='PerformDetections'>
> > >0
> > ><EndFunc Name='PerformDetections' Return='0'
> > GetLastError='0'>
> > >Machine = A-EXTERNAL, Article = IIS, Result = 0 (0x0)
> > ><Prerequisite Name="IsVS71Installed" Checked="Registry"
> > >Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1"
> > Found="Can not open
> > >key" Expected="No error" Result="Fail" />
> > >Machine = A-EXTERNAL, Article = VSNET, Result = 60351
> > (0xebbf)
> > >Getting IIS Metabase data /LM/W3SVC/AppIsolated
> > >Machine = A-EXTERNAL, Article = ASPNET, Result = 0 (0x0)
> > >Machine = A-EXTERNAL, Article = MDAC, Result = 0 (0x0)
> > >Machine = A-EXTERNAL, Article = DTC, Result = 0 (0x0)
> > >Machine = A-EXTERNAL, Article = SERVEROS, Result = 0
> > (0x0)
> > >Machine = A-EXTERNAL, Article = SHAREPOINT, Result = 0
> > (0x0)
> > >Machine = A-EXTERNAL, Article = AUTHZ, Result = 0 (0x0)
> > ><Prerequisite Name="AreRSAccountsValidInstalled"
> > Checked="User
> > >accounts" Item="IWAM_machineName" Found="Not exist or
> > not enable"
> > >Expected="Exist and enabled" Result="Fail" />
> > >Machine = A-EXTERNAL, Article = RSACCOUNTS, Result => > 60357 (0xebc5)
> > >**************
> > >A-EXTERNAL
> > >**************
> > >Report Designer component requirement
> > ><B>Explanation:</B> Visual Studio .NET 2003 is not
> > installed.
> > ><B>Action:</B> Install Visual Studio .NET 2003, and then
> > rerun Setup
> > >to install Report Designer. Or, continue Setup to
> > complete the
> > >installation without Report Designer.
> > >Report Server component requirement
> > ><B>Explanation:</B> Internet Information Services 5.0
> > (IIS) or later
> > >is either not installed, or it is configured in a way
> > that is
> > >incompatible with a Reporting Services installation.
> > ><B>Action:</B> To install the Report Server and Report
> > Manager
> > >components, you must first install Internet Information
> > Services 5.0
> > >(IIS) or later, and then verify that the Web server
> > configuration
> > >requirements are compatible with Setup. Check the Setup
> > documentation
> > >for more information about Web server configuration
> > requirements.
> > >Report size = 1050
> > ><Func Name='FSetupLogging'>
> > ><Func Name='CreateSetupLogCabs'>
> > >Creating Setup Logs Cab "C:\Program Files\Microsoft SQL
> > Server\80\RS
> > >Setup Bootstrap\LOG\RSStp_.cab"
> > >.
> > >
>

difficulty in getting result.

hi all
i am working on sql reporting 2005.
i have 3 reports say A, B ,C
i want to display sum of values in column of A & sum of values in column of B in report C
How can i do this?
plz help me.
report c would have to have the same data as in reports A and B. Then you can sum them.

Wednesday, March 21, 2012

Difficult question regarding Reporting Services

We are having an issue that 1) I can not find any documentation on how
to setup correclty and 2) have not had any postings from other experts
that have actually worked.
Here's the issue along with our environment:
Server 1 - Windows 2003 SP1 with SQL Server 2005 SP1
Server 2 - Windows 2003 SP! with SQL Server 2005 Analysis Services SP1
Server 3 - Windows 2003 SP1 with SQL Server 2005 Reporting Services
SP1
Server 1 and 2 are both member servers in the same domain. Server 3
is a workgroup server only, not a member of any domain. Due to
security concerns we can not make this server part of the domain.
Objective - to provide external access of reports to outside users.
Server 3 will sit in a DMZ and communicate with the inside data
sources.
Server 1 contains the Report Server Database
Server 2 contains the user databases used by the reports
Server 3 contains the Report Server and Report Manager websites and
Reporting Services engine which points to Server 1 for the report
server database
Every thing works fine with one exception. The website will load
correctly, authenticate the user (we are using a local account on
workgroup Server 3 to control access to the Report Manager websites).
The report data sources are configured to Store Credentials Securely
in the Database. When we store and use a SQL Server Standard Login,
the reports load correctly. We can monitor in Profiler on both Server
1 and Server 2 and see Reporting Services first hit the Report Server
database and then hit the user database defined in the data source.
The problem is that we must use a Windows Account so that our reports
may access Analysis Services (which does not support Standard
Logins). Please do not reply stating to make sure the check box in
the data source is checked as it is and I wish this were that simple.
If I join server 3 to the domain, the report runs perfectly using the
exact same data source definition defined with the domain windows
account and the checkbox selected to used Windows Credentials. But
when I take server 3 back out of the domain and into just a workgroup,
the report fails to run, specifically in the RS logs during the
RendReport process. I'm beginning to think that you simply can not
store and use Windows account information in the data source when the
Report Server is not in the domain, which to me does not make any
sense at all but will all the testing we have gone through, that's the
only conclusion I can see.
Has anyone out there experienced this issue or a similar issue? Or if
any of you MVPs out there want to try this out, use Virtual PC. We
tested it and the behavior is exactly the same as on our physical
servers.
Any assistance anyone can provide is GREATLY appreciated!!
Thanks in advance.
MartinI have not done exactly this but I just read up on Analysis services and
believe I have a solution for you. Create a local windows user on the
Analysis services box. Give it the read only rights you want it to have in
Analysis services. Then use this username and password for your credentials.
Another possibility (in case you didn't alread try this) is try the windows
domain user by putting domainname\username in for the user and then its
password. See if that works as well.
Bruce Loehle-Conger
<martinghale@.gmail.com> wrote in message
news:1172175247.449272.235750@.k78g2000cwa.googlegroups.com...
> We are having an issue that 1) I can not find any documentation on how
> to setup correclty and 2) have not had any postings from other experts
> that have actually worked.
> Here's the issue along with our environment:
> Server 1 - Windows 2003 SP1 with SQL Server 2005 SP1
> Server 2 - Windows 2003 SP! with SQL Server 2005 Analysis Services SP1
> Server 3 - Windows 2003 SP1 with SQL Server 2005 Reporting Services
> SP1
> Server 1 and 2 are both member servers in the same domain. Server 3
> is a workgroup server only, not a member of any domain. Due to
> security concerns we can not make this server part of the domain.
> Objective - to provide external access of reports to outside users.
> Server 3 will sit in a DMZ and communicate with the inside data
> sources.
> Server 1 contains the Report Server Database
> Server 2 contains the user databases used by the reports
> Server 3 contains the Report Server and Report Manager websites and
> Reporting Services engine which points to Server 1 for the report
> server database
> Every thing works fine with one exception. The website will load
> correctly, authenticate the user (we are using a local account on
> workgroup Server 3 to control access to the Report Manager websites).
> The report data sources are configured to Store Credentials Securely
> in the Database. When we store and use a SQL Server Standard Login,
> the reports load correctly. We can monitor in Profiler on both Server
> 1 and Server 2 and see Reporting Services first hit the Report Server
> database and then hit the user database defined in the data source.
> The problem is that we must use a Windows Account so that our reports
> may access Analysis Services (which does not support Standard
> Logins). Please do not reply stating to make sure the check box in
> the data source is checked as it is and I wish this were that simple.
> If I join server 3 to the domain, the report runs perfectly using the
> exact same data source definition defined with the domain windows
> account and the checkbox selected to used Windows Credentials. But
> when I take server 3 back out of the domain and into just a workgroup,
> the report fails to run, specifically in the RS logs during the
> RendReport process. I'm beginning to think that you simply can not
> store and use Windows account information in the data source when the
> Report Server is not in the domain, which to me does not make any
> sense at all but will all the testing we have gone through, that's the
> only conclusion I can see.
> Has anyone out there experienced this issue or a similar issue? Or if
> any of you MVPs out there want to try this out, use Virtual PC. We
> tested it and the behavior is exactly the same as on our physical
> servers.
> Any assistance anyone can provide is GREATLY appreciated!!
> Thanks in advance.
> Martin
>|||Bruce,
Thanks for the advice. That was similar to what I had researched as
well. It didn't work before but thought I would give it another try.
I found something interesting. The local account not only needs to be
on the Analysis Server but also on the external report report server.
Once I created the same account name locally on both servers, RS was
able to make the connection with the Windows credentials stored in the
Data Source.
This is something that obviously is not needed when all machines are
in the same domain or are in trusted domains. I have only found this
issue when the report server is not of the domain or a trusted domain,
but only a workgroup...
Thanks for your input!|||Good to know (about creating both places). Glad to see it works for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<martinghale@.gmail.com> wrote in message
news:1172245522.365928.221680@.p10g2000cwp.googlegroups.com...
> Bruce,
> Thanks for the advice. That was similar to what I had researched as
> well. It didn't work before but thought I would give it another try.
> I found something interesting. The local account not only needs to be
> on the Analysis Server but also on the external report report server.
> Once I created the same account name locally on both servers, RS was
> able to make the connection with the Windows credentials stored in the
> Data Source.
> This is something that obviously is not needed when all machines are
> in the same domain or are in trusted domains. I have only found this
> issue when the report server is not of the domain or a trusted domain,
> but only a workgroup...
> Thanks for your input!
>sql

Friday, February 17, 2012

Differences in SQL server reporting and Crystal reports

What are the differences in SQL server reporting and Crystal Reports?

What are the pros and cons of using one or the other?

I know nothing about SQL server reporting, does anyone have any resources for it.

macca

Hi Macca

Our company specializes in CRM software and database management so we naturally do alot of reporting/business intelligence.

As with all types software purchases decisions are best made based on outcome requirements, ease of accomplishing short and long term objectives and price of course. In addition, its important to select a product based on in-house skill set as lots of software purchases go vastly underutilized because of complexity in reaching objectives.

There is another product though to SQL Reporting and CDecisions which we also utilize. Its a WEB based product called LogiXML which has a highly intuitive development interface and utilizes a really innovative approach over traditional report writing. The price is great, the features solid and the support tremendous. I would definately suggest you take a look at this as an alternative if you dont have alot of experience in the report writing area.

Kerri Groves
President
LookOut Software Inc.

|||You may want to checkout this article to find differences between Crystal and Reporting Services.

http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp

Tuesday, February 14, 2012

Differences between Microsoft Report Services and Crystal Reports

hi,
can any one can send the differences between Microsoft
Reporting Services and Crystal Reports.
regards,
chakriserach in google:
http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=eX6NH0ZAEHA.3248%40TK2MSFTNGP11.phx.gbl&rnum=2&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26q%3Dcomparison%2Bcrystal%2Breport%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs
"chakravarthy" <anonymous@.discussions.microsoft.com> a écrit dans le message
de news:79e201c476ed$26293ce0$a601280a@.phx.gbl...
> hi,
> can any one can send the differences between Microsoft
> Reporting Services and Crystal Reports.
>
>
> regards,
> chakri
>