I have a parameter that is query based. I have created my own UI to list out
the text boxes per parameter required by the report. Now comes the problem of
a query based parameter. How to I get the queary based valid values to
populate my drop down list boxEddie,
If I understand your correctly I may have some ideas that will help you with
query based Parameters, but first please clarify the reason you built a UI
for users to pass parameters into the report?
thx.
"Eddie" wrote:
> I have a parameter that is query based. I have created my own UI to list out
> the text boxes per parameter required by the report. Now comes the problem of
> a query based parameter. How to I get the queary based valid values to
> populate my drop down list box|||I have several clients that use browsers which the report viewer doesn't
behave well.
I did figure it out. The valid values come back as array when you call the
GetReportParameter method and set the "ForRendering" to TRUE.
So all I did was add the values to ListItems and populated a drop down.
Also, a nifty thing was to find all the Date type parameters and lock the
text box and provide a calendar. This allowed me to use our application's
Localization methods to handle all the different Date formats.
"RS_CZAR" wrote:
> Eddie,
> If I understand your correctly I may have some ideas that will help you with
> query based Parameters, but first please clarify the reason you built a UI
> for users to pass parameters into the report?
> thx.
> "Eddie" wrote:
> > I have a parameter that is query based. I have created my own UI to list out
> > the text boxes per parameter required by the report. Now comes the problem of
> > a query based parameter. How to I get the queary based valid values to
> > populate my drop down list box
Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts
Friday, March 30, 2012
Reporting Services using NTLM Authentication
I need to have MSSRS send emails to external email addresses. Our Exchange
Server requires email to be authenticated. I am using SMTPAuthenticate value
of 2. My MSSRS server is in a different domain than my Exchange Mail server.
Currently I am testing before deployment into the field and my setup is
mirroring what the corporate desired setup is.
I receive the following error when I attempt to send a report to an external
email:
Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x80040217. The server response was not available
When I sniff the traffic during the report serving, my local Admin login
account is being authenticated by the Exchange Server in the mailer domain.
What type of setup or config changes can be made for the proper hand shake to
work? I must send authenticated email externally to our customers, but the
MSSRS Server and Exchange Servers will be in different domains.
Thanks,
RobertGood morning!
Did you ever find the solution to your question below? If so, what did you
do to resolve it?
Thank you.
"gilliatt via SQLMonster.com" wrote:
> I need to have MSSRS send emails to external email addresses. Our Exchange
> Server requires email to be authenticated. I am using SMTPAuthenticate value
> of 2. My MSSRS server is in a different domain than my Exchange Mail server.
> Currently I am testing before deployment into the field and my setup is
> mirroring what the corporate desired setup is.
> I receive the following error when I attempt to send a report to an external
> email:
> Failure sending mail: The message could not be sent to the SMTP server. The
> transport error code was 0x80040217. The server response was not available
> When I sniff the traffic during the report serving, my local Admin login
> account is being authenticated by the Exchange Server in the mailer domain.
> What type of setup or config changes can be made for the proper hand shake to
> work? I must send authenticated email externally to our customers, but the
> MSSRS Server and Exchange Servers will be in different domains.
> Thanks,
> Robert
>sql
Server requires email to be authenticated. I am using SMTPAuthenticate value
of 2. My MSSRS server is in a different domain than my Exchange Mail server.
Currently I am testing before deployment into the field and my setup is
mirroring what the corporate desired setup is.
I receive the following error when I attempt to send a report to an external
email:
Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x80040217. The server response was not available
When I sniff the traffic during the report serving, my local Admin login
account is being authenticated by the Exchange Server in the mailer domain.
What type of setup or config changes can be made for the proper hand shake to
work? I must send authenticated email externally to our customers, but the
MSSRS Server and Exchange Servers will be in different domains.
Thanks,
RobertGood morning!
Did you ever find the solution to your question below? If so, what did you
do to resolve it?
Thank you.
"gilliatt via SQLMonster.com" wrote:
> I need to have MSSRS send emails to external email addresses. Our Exchange
> Server requires email to be authenticated. I am using SMTPAuthenticate value
> of 2. My MSSRS server is in a different domain than my Exchange Mail server.
> Currently I am testing before deployment into the field and my setup is
> mirroring what the corporate desired setup is.
> I receive the following error when I attempt to send a report to an external
> email:
> Failure sending mail: The message could not be sent to the SMTP server. The
> transport error code was 0x80040217. The server response was not available
> When I sniff the traffic during the report serving, my local Admin login
> account is being authenticated by the Exchange Server in the mailer domain.
> What type of setup or config changes can be made for the proper hand shake to
> work? I must send authenticated email externally to our customers, but the
> MSSRS Server and Exchange Servers will be in different domains.
> Thanks,
> Robert
>sql
Reporting Services using IBM DB2 Data Provider for .NET framework 2.0
Hello, I have been testing the IBM DB2 .NET data provider the last couple of months with the intention too use it with Reporting Services. I am using the IBM DB2 Data Provider for .NET framework 2.0. Everything seems too work fine until I started too test the Cashing and Scheduling of reports in Reporting Services.
Too be able too cash or too schedule reports in Reporting Services you have too set the "Credientials stored securely in the report server". The problem is when I do this with the Data Connection using the IBM .Net Provider I get an error Message:
"The data source 'XXXX' uses a managed data provider which does not implement IDbConnectionExtension. Only Windows Integrated Security or No Credentials are supported."
Is it possible too write a wrapper around the IBM dataprovider too implement IdbConnectionExtension and thereby extend the SSRS security model or is this something IBM have too do in the provider.
You can implement the wrapper yourself. Use this documentation to get started: http://msdn2.microsoft.com/en-us/library/ms154655(SQL.90).aspx
-- Robert
|||Ok, thanks. I will look into this in a couple of days. Will this kind of wrapper couse much overhead or lack of performance?
I still wonder why IBM has not implemented this Interface in their release of the dataprovider.
B
|||The purpose of the wrapper is mainly to "link" the defined interfaces, properties and methods to the underlying managed DB2 provider.
Your data extension wrapper should not perform any real data processing - just passing through calls. Hence, there won't be any significant overhead.
-- Robert
|||Were you able to create this provider?Reporting Services using ASP
Is it possible to use SQL Server Repotring Services without using .net
framework? I want to use it using ASP.Depends on how you want to use it... You can call reports and pass
parameters via URL from ASP...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sumanta" <Sumanta@.discussions.microsoft.com> wrote in message
news:C07F6A9A-9C90-4213-AAB3-68E242E4213C@.microsoft.com...
> Is it possible to use SQL Server Repotring Services without using .net
> framework? I want to use it using ASP.
framework? I want to use it using ASP.Depends on how you want to use it... You can call reports and pass
parameters via URL from ASP...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sumanta" <Sumanta@.discussions.microsoft.com> wrote in message
news:C07F6A9A-9C90-4213-AAB3-68E242E4213C@.microsoft.com...
> Is it possible to use SQL Server Repotring Services without using .net
> framework? I want to use it using ASP.
Reporting Services User Problems...
What I learned this week is that Reporting Services security is annoying as
hell. :-)
I'm curious if there is any logical reason that you cannot create a
subscription out of
a report that references the User!UserID? Perhaps I can see why some other
values
in User! may not be available, but the subscription is clearly associated
with the username
that created it, so I cannot even conceieve why there would be a limitation
like that.
Second, I was curious about the context under which a scheduled report is
executed.
The restriction above seems to indicate that it is run under the context of
some unknown
generic user, but my experience below seems to indicate otherwise.
The nuts and bolts of it is that I am receiving the infamous
"ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files,
AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
account doesn't
have rights to check domain user SIDs.". I started with the server running
as NETWORK
SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account that
clearly has access to the domain controller to lookup SIDs.
My confusion here is that if *I* create a subscription (being an
administrator) the
subscription runs fine. If any other user creates the subscription, it will
fail with the error
above. I'd sure like some insight into how this authorization crap works to
help track
down the problem.
Thanks,
Joel
jdk6 at case dot eduJoel,
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID?
There is a good reason and it is that subscriptions are executed in an
unattended mode by the RS Windows service so any user context is irrelevant.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
Under the context of the RS Windows service account.
Every user with Create Subscription rights should be able to create
subscriptions. From there, it is the RS Windows service responsibility to
handle the subscription.
--
Hope this helps.
----
Teo Lachev, 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/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:eaWoPv4mEHA.316@.TK2MSFTNGP10.phx.gbl...
> What I learned this week is that Reporting Services security is annoying
as
> hell. :-)
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID? Perhaps I can see why some
other
> values
> in User! may not be available, but the subscription is clearly associated
> with the username
> that created it, so I cannot even conceieve why there would be a
limitation
> like that.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
> The nuts and bolts of it is that I am receiving the infamous
> "ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
the
> log files,
> AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
> account doesn't
> have rights to check domain user SIDs.". I started with the server
running
> as NETWORK
> SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account
that
> clearly has access to the domain controller to lookup SIDs.
> My confusion here is that if *I* create a subscription (being an
> administrator) the
> subscription runs fine. If any other user creates the subscription, it
will
> fail with the error
> above. I'd sure like some insight into how this authorization crap works
to
> help track
> down the problem.
> Thanks,
> Joel
> jdk6 at case dot edu
>
>|||> Joel,
>> I'm curious if there is any logical reason that you cannot create a
>> subscription out of
>> a report that references the User!UserID?
> There is a good reason and it is that subscriptions are executed in an
> unattended mode by the RS Windows service so any user context is
> irrelevant.
> > Second, I was curious about the context under which a scheduled report
> > is
>> executed.
>> The restriction above seems to indicate that it is run under the context
> of
>> some unknown
>> generic user, but my experience below seems to indicate otherwise.
> Under the context of the RS Windows service account.
> Every user with Create Subscription rights should be able to create
> subscriptions. From there, it is the RS Windows service responsibility to
> handle the subscription.
Well at least your answers are consistent! :-)
Which is what I expected, though I cannot say that I agree.
My problem still remains then, is why when I create a subscription as an
administrator,
my subscription is delivered properly, but a subscription created by a
normal user
gets an AuthzInitializeContextFromSid error. This seems inconsistent with
the report
being solely run from the context of the RS Service account... if it had
permission
to process my subscription correctly, it should be able to do them all!!
This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
functional level. "Authenticated Users" has the rights to read all of the
user and
group objects...
Joel|||Check the following thread:
http://groups.google.com/groups?q=AuthzInitializeContextFromSid&hl=en&lr=&ie=UTF-8&selm=O4qGzyL%24DHA.1700%40TK2MSFTNGP12.phx.gbl&rnum=7
--
Hope this helps.
----
Teo Lachev, 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/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:%23uO7VJ5mEHA.3296@.TK2MSFTNGP10.phx.gbl...
> > Joel,
> >
> >> I'm curious if there is any logical reason that you cannot create a
> >> subscription out of
> >> a report that references the User!UserID?
> >
> > There is a good reason and it is that subscriptions are executed in an
> > unattended mode by the RS Windows service so any user context is
> > irrelevant.
> > > Second, I was curious about the context under which a scheduled report
> > > is
> >> executed.
> >> The restriction above seems to indicate that it is run under the
context
> > of
> >> some unknown
> >> generic user, but my experience below seems to indicate otherwise.
> >
> > Under the context of the RS Windows service account.
> >
> > Every user with Create Subscription rights should be able to create
> > subscriptions. From there, it is the RS Windows service responsibility
to
> > handle the subscription.
> Well at least your answers are consistent! :-)
> Which is what I expected, though I cannot say that I agree.
> My problem still remains then, is why when I create a subscription as an
> administrator,
> my subscription is delivered properly, but a subscription created by a
> normal user
> gets an AuthzInitializeContextFromSid error. This seems inconsistent with
> the report
> being solely run from the context of the RS Service account... if it had
> permission
> to process my subscription correctly, it should be able to do them all!!
> This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
> functional level. "Authenticated Users" has the rights to read all of the
> user and
> group objects...
> Joel
>
hell. :-)
I'm curious if there is any logical reason that you cannot create a
subscription out of
a report that references the User!UserID? Perhaps I can see why some other
values
in User! may not be available, but the subscription is clearly associated
with the username
that created it, so I cannot even conceieve why there would be a limitation
like that.
Second, I was curious about the context under which a scheduled report is
executed.
The restriction above seems to indicate that it is run under the context of
some unknown
generic user, but my experience below seems to indicate otherwise.
The nuts and bolts of it is that I am receiving the infamous
"ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files,
AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
account doesn't
have rights to check domain user SIDs.". I started with the server running
as NETWORK
SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account that
clearly has access to the domain controller to lookup SIDs.
My confusion here is that if *I* create a subscription (being an
administrator) the
subscription runs fine. If any other user creates the subscription, it will
fail with the error
above. I'd sure like some insight into how this authorization crap works to
help track
down the problem.
Thanks,
Joel
jdk6 at case dot eduJoel,
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID?
There is a good reason and it is that subscriptions are executed in an
unattended mode by the RS Windows service so any user context is irrelevant.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
Under the context of the RS Windows service account.
Every user with Create Subscription rights should be able to create
subscriptions. From there, it is the RS Windows service responsibility to
handle the subscription.
--
Hope this helps.
----
Teo Lachev, 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/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:eaWoPv4mEHA.316@.TK2MSFTNGP10.phx.gbl...
> What I learned this week is that Reporting Services security is annoying
as
> hell. :-)
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID? Perhaps I can see why some
other
> values
> in User! may not be available, but the subscription is clearly associated
> with the username
> that created it, so I cannot even conceieve why there would be a
limitation
> like that.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
> The nuts and bolts of it is that I am receiving the infamous
> "ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
the
> log files,
> AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
> account doesn't
> have rights to check domain user SIDs.". I started with the server
running
> as NETWORK
> SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account
that
> clearly has access to the domain controller to lookup SIDs.
> My confusion here is that if *I* create a subscription (being an
> administrator) the
> subscription runs fine. If any other user creates the subscription, it
will
> fail with the error
> above. I'd sure like some insight into how this authorization crap works
to
> help track
> down the problem.
> Thanks,
> Joel
> jdk6 at case dot edu
>
>|||> Joel,
>> I'm curious if there is any logical reason that you cannot create a
>> subscription out of
>> a report that references the User!UserID?
> There is a good reason and it is that subscriptions are executed in an
> unattended mode by the RS Windows service so any user context is
> irrelevant.
> > Second, I was curious about the context under which a scheduled report
> > is
>> executed.
>> The restriction above seems to indicate that it is run under the context
> of
>> some unknown
>> generic user, but my experience below seems to indicate otherwise.
> Under the context of the RS Windows service account.
> Every user with Create Subscription rights should be able to create
> subscriptions. From there, it is the RS Windows service responsibility to
> handle the subscription.
Well at least your answers are consistent! :-)
Which is what I expected, though I cannot say that I agree.
My problem still remains then, is why when I create a subscription as an
administrator,
my subscription is delivered properly, but a subscription created by a
normal user
gets an AuthzInitializeContextFromSid error. This seems inconsistent with
the report
being solely run from the context of the RS Service account... if it had
permission
to process my subscription correctly, it should be able to do them all!!
This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
functional level. "Authenticated Users" has the rights to read all of the
user and
group objects...
Joel|||Check the following thread:
http://groups.google.com/groups?q=AuthzInitializeContextFromSid&hl=en&lr=&ie=UTF-8&selm=O4qGzyL%24DHA.1700%40TK2MSFTNGP12.phx.gbl&rnum=7
--
Hope this helps.
----
Teo Lachev, 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/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:%23uO7VJ5mEHA.3296@.TK2MSFTNGP10.phx.gbl...
> > Joel,
> >
> >> I'm curious if there is any logical reason that you cannot create a
> >> subscription out of
> >> a report that references the User!UserID?
> >
> > There is a good reason and it is that subscriptions are executed in an
> > unattended mode by the RS Windows service so any user context is
> > irrelevant.
> > > Second, I was curious about the context under which a scheduled report
> > > is
> >> executed.
> >> The restriction above seems to indicate that it is run under the
context
> > of
> >> some unknown
> >> generic user, but my experience below seems to indicate otherwise.
> >
> > Under the context of the RS Windows service account.
> >
> > Every user with Create Subscription rights should be able to create
> > subscriptions. From there, it is the RS Windows service responsibility
to
> > handle the subscription.
> Well at least your answers are consistent! :-)
> Which is what I expected, though I cannot say that I agree.
> My problem still remains then, is why when I create a subscription as an
> administrator,
> my subscription is delivered properly, but a subscription created by a
> normal user
> gets an AuthzInitializeContextFromSid error. This seems inconsistent with
> the report
> being solely run from the context of the RS Service account... if it had
> permission
> to process my subscription correctly, it should be able to do them all!!
> This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
> functional level. "Authenticated Users" has the rights to read all of the
> user and
> group objects...
> Joel
>
Reporting Services unstable.
I have been using reporting services for about 1 1/2 months, developing
reports in VS2003.
I have noticed that my changes don't get saved within the IDE (I have to go
out to notepad and edit the XML), as well as locking up when changing the
SQL statement in the report enviroment data window and changing the tab to
design or preview.
I have windows XP SP2 and SQL 2000 SP3a and Reporting Service SP1.
Unfortunately I don't know how long this has been happening.
Also when starting to apply changes to the report , VSS (Visual Source Safe)
doesn't prompt me to check out the report, it only does this when trying to
save it (which is doesn't do anyway).
Regards,
AdrianI too have been having very specific issues with changes to either the SQL
or the report layout format not being saved when integrated with VSS.
Neither the version in my working directory nor the version in VSS gets
updated.
Vivienne|||Sometimes it does not catch SQL changes. I always go to the layout mode
after I have made a change and then save it there. I have never seen a
problem with the report layout not being saved. Note that I do not use VSS
but the issue with changing the SQL is a problem regardless of whether VSS
is involved.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivienne" <Vivienne@.discussions.microsoft.com> wrote in message
news:B57466D2-FFA7-4159-BE0F-4DCF07587C87@.microsoft.com...
> I too have been having very specific issues with changes to either the SQL
> or the report layout format not being saved when integrated with VSS.
> Neither the version in my working directory nor the version in VSS gets
> updated.
> Vivienne
reports in VS2003.
I have noticed that my changes don't get saved within the IDE (I have to go
out to notepad and edit the XML), as well as locking up when changing the
SQL statement in the report enviroment data window and changing the tab to
design or preview.
I have windows XP SP2 and SQL 2000 SP3a and Reporting Service SP1.
Unfortunately I don't know how long this has been happening.
Also when starting to apply changes to the report , VSS (Visual Source Safe)
doesn't prompt me to check out the report, it only does this when trying to
save it (which is doesn't do anyway).
Regards,
AdrianI too have been having very specific issues with changes to either the SQL
or the report layout format not being saved when integrated with VSS.
Neither the version in my working directory nor the version in VSS gets
updated.
Vivienne|||Sometimes it does not catch SQL changes. I always go to the layout mode
after I have made a change and then save it there. I have never seen a
problem with the report layout not being saved. Note that I do not use VSS
but the issue with changing the SQL is a problem regardless of whether VSS
is involved.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vivienne" <Vivienne@.discussions.microsoft.com> wrote in message
news:B57466D2-FFA7-4159-BE0F-4DCF07587C87@.microsoft.com...
> I too have been having very specific issues with changes to either the SQL
> or the report layout format not being saved when integrated with VSS.
> Neither the version in my working directory nor the version in VSS gets
> updated.
> Vivienne
Reporting Services under Windows Vista
Hello,
I tried to install SQL Server 2005 Express with Advanced Services under
Windows Vista RC1 x64. However I allways get the following Warning:
"ASP.Net Version Registration Requirement:
Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS)."
Having this warning it's not possible to install the Reporting Services.
Are there compatibility issues with IIS7 or am I doing sth. wrong?
MartinHello Martin,
Reporting Services won't be correctly supported until SP2 for SQL Server
2005, due to ship about the same time as Vista does. The IIS7 issue has to
due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
see [0])
[0]: http://support.microsoft.com/kb/920201/en-us
I've tried getting working the RCs to not avail.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||I just think that is goddamn ridiculous
a) we can't use _ANY_ database on Vista until SQL 2005 SP2 comes out.
b) we can't get a DOCUMENTED release date on SP2.
c) we don't know what features are in SP2.
It's like-- all of a sudden; a month after vista ships; we're supposed
to flip the switch and have every dev box in the world using MSDE on
Windows XP on day one and SQL 2005 on Vista the next day.
I just dont understand WTF that company is thinking; it's goddamn
ridiculous
If you dont have enough programmers; hire more-- as it is; a company
that has 50,000 people and they're stressed about having 5,000
programmers working on Vista _AND_ Office 2007 combined?
No wonder google can out-develop you even though they only have 8,000
total employees-- I guess at Google; they don't require 45,000
redundant project managers / excel dorks
-Aaron
Kent Tegels wrote:
> Hello Martin,
> Reporting Services won't be correctly supported until SP2 for SQL Server
> 2005, due to ship about the same time as Vista does. The IIS7 issue has to
> due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
> see [0])
> [0]: http://support.microsoft.com/kb/920201/en-us
> I've tried getting working the RCs to not avail.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/|||I installed mine last week but not on x64. You have to go in to the Control
Panel / Programs and check all boxes for IIS. You can't rely on the top
check boxes for each subsection. You have to expand the hierarchy for IIS
and manually check ALL items.
Then it will install
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>sql
I tried to install SQL Server 2005 Express with Advanced Services under
Windows Vista RC1 x64. However I allways get the following Warning:
"ASP.Net Version Registration Requirement:
Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS)."
Having this warning it's not possible to install the Reporting Services.
Are there compatibility issues with IIS7 or am I doing sth. wrong?
MartinHello Martin,
Reporting Services won't be correctly supported until SP2 for SQL Server
2005, due to ship about the same time as Vista does. The IIS7 issue has to
due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
see [0])
[0]: http://support.microsoft.com/kb/920201/en-us
I've tried getting working the RCs to not avail.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||I just think that is goddamn ridiculous
a) we can't use _ANY_ database on Vista until SQL 2005 SP2 comes out.
b) we can't get a DOCUMENTED release date on SP2.
c) we don't know what features are in SP2.
It's like-- all of a sudden; a month after vista ships; we're supposed
to flip the switch and have every dev box in the world using MSDE on
Windows XP on day one and SQL 2005 on Vista the next day.
I just dont understand WTF that company is thinking; it's goddamn
ridiculous
If you dont have enough programmers; hire more-- as it is; a company
that has 50,000 people and they're stressed about having 5,000
programmers working on Vista _AND_ Office 2007 combined?
No wonder google can out-develop you even though they only have 8,000
total employees-- I guess at Google; they don't require 45,000
redundant project managers / excel dorks
-Aaron
Kent Tegels wrote:
> Hello Martin,
> Reporting Services won't be correctly supported until SP2 for SQL Server
> 2005, due to ship about the same time as Vista does. The IIS7 issue has to
> due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
> see [0])
> [0]: http://support.microsoft.com/kb/920201/en-us
> I've tried getting working the RCs to not avail.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/|||I installed mine last week but not on x64. You have to go in to the Control
Panel / Programs and check all boxes for IIS. You can't rely on the top
check boxes for each subsection. You have to expand the hierarchy for IIS
and manually check ALL items.
Then it will install
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>sql
Reporting services unavailable after windows 2003 SP2 installed
I have installed windows server 2003 on one of our test boxes (prior to live) and found that reporting services is now unavailable.
The event log reports several times
When I browse to the report server I get
Service Unavailable
The event log reports several times
"A process serving application pool 'reportserver' terminated unexpectedly. The process id was '3500'. The process exit code was '0xffffffff'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
before the worker process is disabled:
"Application pool 'reportserver' is being automatically disabled due to a series of failures in the process(es) serving that application pool.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
Has anyone seen similar behavior?
Stuart
"
A second reboot seems to have fixed this and (mysteriously enough) fixed terminal services too!
Reporting Services Tutorials Problem
Hi, I'm having a problem with the 6th tutorial of the Reporting Services: Using XML Data in a Report. Im using SQL Server Standard Edition on Windows server 2003.
In 'Lesson 1: Defining a Data Source and Dataset for XML Data' (http://msdn2.microsoft.com/en-us/library/ms345338.aspx), I can't seem to get steps 10 to 15 right.
In Step 10, it says you must type :
"<Query> <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren</SoapAction> </Query>"
But in the diagram it has .../reporting/reportingservices/ListChildren...
Well I tried both(The namespace info from "http://localhost/reportserver/reportservice2005.asmx?wsdl" uses the latter.) but I get the error:
An error occurred while executing the query.
Failed to execute web request for the specified URL.
What am I doing wrong?
The schema information is wrong in the tutorial. We've fixed it for the next release. The following schema namespace should work for you:
Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>
After typing the query as stated in the last post being:
<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>
I still get the same error. What is the correct syntax in order to get this to work?
Thanks
Reporting Services Tutorials Problem
Hi, I'm having a problem with the 6th tutorial of the Reporting Services: Using XML Data in a Report. Im using SQL Server Standard Edition on Windows server 2003.
In 'Lesson 1: Defining a Data Source and Dataset for XML Data' (http://msdn2.microsoft.com/en-us/library/ms345338.aspx), I can't seem to get steps 10 to 15 right.
In Step 10, it says you must type :
"<Query> <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren</SoapAction> </Query>"
But in the diagram it has .../reporting/reportingservices/ListChildren...
Well I tried both(The namespace info from "http://localhost/reportserver/reportservice2005.asmx?wsdl" uses the latter.) but I get the error:
An error occurred while executing the query.
Failed to execute web request for the specified URL.
What am I doing wrong?
The schema information is wrong in the tutorial. We've fixed it for the next release. The following schema namespace should work for you:
Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>
After typing the query as stated in the last post being:
<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>
I still get the same error. What is the correct syntax in order to get this to work?
Thanks
Reporting Services tutorial
Hi,
I am trying to step thru the June SQL 2005 CTP Book on Line Tutorial on Reporting Services (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/95c9c883-12e5-47af-8da1-b77c6ef7484c.htm)
However the steps don't seem to match what is in the GUI. Is there an updated version of this tutorial?
Thanks in advance.
Ned
Never mind, I selected REPORT MODEL instead of REPORT PROJECT.
Thanks,
Ned
Reporting Services Tuning
A couple of questions related to Reported Services tuning that I hope
someone might be able to give me a clue about....
1) In the Reporting Services Books Online, I have found a lot of
information on performance monitoring, but very little on performance
tuning. Is any additional information available, perhaps a whitepaper? Or
perhaps I am just missing something that is in the BOL?
2) An immediate question we have that perhaps someone can answer is, is
there any way to give On Demand reports a higher execution priority than
Scheduled reports? A particular concern is that a shared schedule, say "End
of month" processing, might become very popular and have a large number of
reports subscribed to it. These reports might then overload the server,
adversely effecting the execution time of On Demand reports.
Any enlightenment would be greatly appreciated.
Thanks,
BobOne thing to keep in mind. A snapshot of the report/data can be saved. So,
you can schedule to run at night every night and then save x days of
reports. Or you can run weekly and save 10 weeks of data (you specify how
many snapshots to save). This report or a link to it can be emailed out. To
me that is what makes the most sense, run the scheduled reports in off time
and then you will have no concern about the On Demand reports.
Bruce L-C
"Bob Hug" <rhug@.brassring.com> wrote in message
news:O6LK84QZEHA.3944@.tk2msftngp13.phx.gbl...
> A couple of questions related to Reported Services tuning that I hope
> someone might be able to give me a clue about....
> 1) In the Reporting Services Books Online, I have found a lot of
> information on performance monitoring, but very little on performance
> tuning. Is any additional information available, perhaps a whitepaper? Or
> perhaps I am just missing something that is in the BOL?
> 2) An immediate question we have that perhaps someone can answer is,
is
> there any way to give On Demand reports a higher execution priority than
> Scheduled reports? A particular concern is that a shared schedule, say
"End
> of month" processing, might become very popular and have a large number of
> reports subscribed to it. These reports might then overload the server,
> adversely effecting the execution time of On Demand reports.
> Any enlightenment would be greatly appreciated.
> Thanks,
> Bob
>sql
someone might be able to give me a clue about....
1) In the Reporting Services Books Online, I have found a lot of
information on performance monitoring, but very little on performance
tuning. Is any additional information available, perhaps a whitepaper? Or
perhaps I am just missing something that is in the BOL?
2) An immediate question we have that perhaps someone can answer is, is
there any way to give On Demand reports a higher execution priority than
Scheduled reports? A particular concern is that a shared schedule, say "End
of month" processing, might become very popular and have a large number of
reports subscribed to it. These reports might then overload the server,
adversely effecting the execution time of On Demand reports.
Any enlightenment would be greatly appreciated.
Thanks,
BobOne thing to keep in mind. A snapshot of the report/data can be saved. So,
you can schedule to run at night every night and then save x days of
reports. Or you can run weekly and save 10 weeks of data (you specify how
many snapshots to save). This report or a link to it can be emailed out. To
me that is what makes the most sense, run the scheduled reports in off time
and then you will have no concern about the On Demand reports.
Bruce L-C
"Bob Hug" <rhug@.brassring.com> wrote in message
news:O6LK84QZEHA.3944@.tk2msftngp13.phx.gbl...
> A couple of questions related to Reported Services tuning that I hope
> someone might be able to give me a clue about....
> 1) In the Reporting Services Books Online, I have found a lot of
> information on performance monitoring, but very little on performance
> tuning. Is any additional information available, perhaps a whitepaper? Or
> perhaps I am just missing something that is in the BOL?
> 2) An immediate question we have that perhaps someone can answer is,
is
> there any way to give On Demand reports a higher execution priority than
> Scheduled reports? A particular concern is that a shared schedule, say
"End
> of month" processing, might become very popular and have a large number of
> reports subscribed to it. These reports might then overload the server,
> adversely effecting the execution time of On Demand reports.
> Any enlightenment would be greatly appreciated.
> Thanks,
> Bob
>sql
Reporting Services trendline
Good day,
Can anyone help please?
I need to add a linear trendline to a chart in SSRS 2000 and it appears there is no option for this. If that is the case could someone help me in possibly manually working out the values for a linear trendline.
I know in Excel and so on it is done automatically but that does nit help and I am battling to find an equation to manually calculate the values.
Best regardsI am looking for the same answer. Were you able to resolve your issue?
Thank you,
Karen
Can anyone help please?
I need to add a linear trendline to a chart in SSRS 2000 and it appears there is no option for this. If that is the case could someone help me in possibly manually working out the values for a linear trendline.
I know in Excel and so on it is done automatically but that does nit help and I am battling to find an equation to manually calculate the values.
Best regardsI am looking for the same answer. Were you able to resolve your issue?
Thank you,
Karen
Reporting Services Toolbar & version
Hi All,
1. Whether I'm working on in Layout, Data or Preview (Reporting Services 2005) for any report
the toolbars I select disappear when I click on close. In Tools, Customize, I have check marks by: Formatting, Query designer, Layou,Build and Standard among a few others. I tried the reset button but no help as well.
What am I missing? Should they be visible and not grayed out?
2. Also, Is there an easy way to tell what verion/service pack level SQl server 2005 and of MSSRS 2005 I am running?
Thanks in Advance !
>Scott
http://i55.photobucket.com/albums/g121/Farsight38/toolbars.jpg
These should be all of your toolbars.
To get the versin of SQL server 2005, execute the following query:
select @.@.version
Reporting Services too slow.
Every time I log in for the first time in my Reporting Services by IIS it′s take forever.
Can I do something for increase the speed of this first connection to Reporting Services? After the first one the Reporting Services is much more faster.
Hello,
I believe the problem is your application pool is set to recycle too often. Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619105&SiteID=1
Hope this helps.
Jarret
|||Thanks... helped!Reporting Services too slow.
Every time I log in for the first time in my Reporting Services by IIS it′s take forever.
Can I do something for increase the speed of this first connection to Reporting Services? After the first one the Reporting Services is much more faster.
Hello,
I believe the problem is your application pool is set to recycle too often. Take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619105&SiteID=1
Hope this helps.
Jarret
|||Thanks... helped!reporting services TOC
We need a way add a WORD style TOC to a report, an ideas out there...?Try a document map.
--
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/
---
"mike" <michael.w.i@.gmail.com> wrote in message
news:dbd5909c.0411121733.623da7b3@.posting.google.com...
> We need a way add a WORD style TOC to a report, an ideas out there...?sql
--
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/
---
"mike" <michael.w.i@.gmail.com> wrote in message
news:dbd5909c.0411121733.623da7b3@.posting.google.com...
> We need a way add a WORD style TOC to a report, an ideas out there...?sql
Reporting Services to MS Word Questions
Hello
I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.
The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.
Is there a way to fix this formatting issues in Word?
Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||
We have the same dillemma...
We are currently evaluating another reporting tool due to couple of reasons:
1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.
2) No support for export of nested data regions to Excel?
Any idea when these features will be available?
Thanks a lot,
Panna Balaji
|||We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.
Reporting Services to MS Word Questions
Hello
I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.
The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.
Is there a way to fix this formatting issues in Word?
Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||
We have the same dillemma...
We are currently evaluating another reporting tool due to couple of reasons:
1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.
2) No support for export of nested data regions to Excel?
Any idea when these features will be available?
Thanks a lot,
Panna Balaji
|||We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.
Reporting Services to MS Word Questions
Hello
I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.
The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.
Is there a way to fix this formatting issues in Word?
Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||
We have the same dillemma...
We are currently evaluating another reporting tool due to couple of reasons:
1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.
2) No support for export of nested data regions to Excel?
Any idea when these features will be available?
Thanks a lot,
Panna Balaji
|||We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.
Subscribe to:
Posts (Atom)