Query -- 11 seconds in SSMS but times out after 30 minutes in

We're having a weird problem -- a particular report will time out
after 30 minutes running in Reporting Services. However, if we grab
the query from Profiler and run it in SSMS, it runs in about 11
seconds. The profiler trace shows an error of 2 - Abort.
The query itself is found below -- I won't include DDL because each of
the items in the FROM clause is a view that is very long.
Any explanation as to why the query would take so long when running
from reporting services?
Our environment -- SQL 2005 Standard x64, SP2 (9.00.3054.00 / Build
3790). Running on Windows Server 2003 Enterprise x64 SP2.
There are some things I'd like to clean up after seeing it, but
nonetheless it still runs pretty quick in SSMS.
SELECT
e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2
WHEN 3 THEN b.desc_3
WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN
b.desc_6
WHEN 7 THEN b.desc_7 ELSE b.desc_8 END AS Plan_Option
, e.SHORT_NAME, e.SSN
, SUM(bck.COST)
, e.STATUS
,case when e.terminated ='1753-01-01 00:00:00.000' then ' '
else LEFT( CONVERT(varchar,e.terminated, 120), 10) end as term_date
FROM
ahr_custom.sls.nocorp_ckreg ck
inner join ahr_custom.sls.nocorp_prckreg p ON p.ck_no = ck.ck_no AND p.ck_style = ck.ck_style AND p.company = ck.company
inner join ahr_custom.sls.nocorp_beckreg bck ON p.ck_no = bck.ck_no AND p.ck_style = bck.ck_style AND p.company = bck.company
inner join ahr_custom.sls.nocorp_beneplan b on b.company = bck.company and b.plan_no = bck.plan_no
inner join ahr_custom.sls.nocorp_employee e on e.company = ck.company and e.emp_no = p.emp_no
inner join ahr_custom.sls.nocorp_empbene eb on bck.company = eb.company and e.emp_no = eb.emp_no and eb.plan_no = bck.plan_no
inner join ahr_custom.sls.nocorp_clients c on ck.company = c.company and c.client_no = e.client_no1
WHERE
bck.PLAN_NO IN (20676)
AND p.COMPANY IN ('OK','CA','C2','CO','TX')
and Left(CONVERT(varchar,ck.ck_date,120),10)
between cast(year(getdate()-20) as varchar(4)) +'-'+ (right( '0'
+cast(month(getdate()-20) as varchar(2)),2))+ '-01'
and LEFT( CONVERT(varchar,
ahr_custom.dbo.lastdayofmonth(getdate()-20) , 120), 10)
GROUP BY
e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2 WHEN 3
THEN b.desc_3
WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN b.desc_6
WHEN 7 THEN b.desc_7 ELSE b.desc_8 END
, e.SHORT_NAME, e.SSN
,e.STATUS
,case when e.terminated ='1753-01-01 00:00:00.000' then ' ' else
LEFT( CONVERT(varchar,e.terminated, 120), 10) endHow many rows of data is returned?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<stephen.lee.moore@.gmail.com> wrote in message
news:ac49df7d-bd90-4f6d-b7c8-44012e8e9bb3@.w56g2000hsf.googlegroups.com...
> We're having a weird problem -- a particular report will time out
> after 30 minutes running in Reporting Services. However, if we grab
> the query from Profiler and run it in SSMS, it runs in about 11
> seconds. The profiler trace shows an error of 2 - Abort.
> The query itself is found below -- I won't include DDL because each of
> the items in the FROM clause is a view that is very long.
> Any explanation as to why the query would take so long when running
> from reporting services?
> Our environment -- SQL 2005 Standard x64, SP2 (9.00.3054.00 / Build
> 3790). Running on Windows Server 2003 Enterprise x64 SP2.
> There are some things I'd like to clean up after seeing it, but
> nonetheless it still runs pretty quick in SSMS.
> SELECT
> e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
> ,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2
> WHEN 3 THEN b.desc_3
> WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN
> b.desc_6
> WHEN 7 THEN b.desc_7 ELSE b.desc_8 END AS Plan_Option
> , e.SHORT_NAME, e.SSN
> , SUM(bck.COST)
> , e.STATUS
> ,case when e.terminated ='1753-01-01 00:00:00.000' then ' '
> else LEFT( CONVERT(varchar,e.terminated, 120), 10) end as term_date
> FROM
> ahr_custom.sls.nocorp_ckreg ck
> inner join ahr_custom.sls.nocorp_prckreg p ON p.ck_no => ck.ck_no AND p.ck_style = ck.ck_style AND p.company = ck.company
> inner join ahr_custom.sls.nocorp_beckreg bck ON p.ck_no => bck.ck_no AND p.ck_style = bck.ck_style AND p.company = bck.company
> inner join ahr_custom.sls.nocorp_beneplan b on b.company => bck.company and b.plan_no = bck.plan_no
> inner join ahr_custom.sls.nocorp_employee e on e.company => ck.company and e.emp_no = p.emp_no
> inner join ahr_custom.sls.nocorp_empbene eb on bck.company => eb.company and e.emp_no = eb.emp_no and eb.plan_no = bck.plan_no
> inner join ahr_custom.sls.nocorp_clients c on ck.company => c.company and c.client_no = e.client_no1
> WHERE
> bck.PLAN_NO IN (20676)
> AND p.COMPANY IN ('OK','CA','C2','CO','TX')
> and Left(CONVERT(varchar,ck.ck_date,120),10)
> between cast(year(getdate()-20) as varchar(4)) +'-'+ (right( '0'
> +cast(month(getdate()-20) as varchar(2)),2))+ '-01'
> and LEFT( CONVERT(varchar,
> ahr_custom.dbo.lastdayofmonth(getdate()-20) , 120), 10)
> GROUP BY
> e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
> ,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2 WHEN 3
> THEN b.desc_3
> WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN b.desc_6
> WHEN 7 THEN b.desc_7 ELSE b.desc_8 END
> , e.SHORT_NAME, e.SSN
> ,e.STATUS
> ,case when e.terminated ='1753-01-01 00:00:00.000' then ' ' else
> LEFT( CONVERT(varchar,e.terminated, 120), 10) end|||On Dec 4, 11:07 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> How many rows of data is returned?
502 rows|||OK, number of rows is not a problem. My guess is that you are having an
issue with the query plan being different.
First, can you put this in a stored procedure and then call that from both
places and see if that makes a difference?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<stephen.lee.moore@.gmail.com> wrote in message
news:90230c5c-f7c7-4592-8b44-83ce3a381729@.s12g2000prg.googlegroups.com...
> On Dec 4, 11:07 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> How many rows of data is returned?
> 502 rows|||> First, can you put this in a stored procedure and then call that from both
> places and see if that makes a difference?
Wow -- good suggestion! That seemed to fix it.
Any ideas why in the world would a different query plan be generated
from Reporting Services than from SSMS? It seems like either A)
Profiler isn't giving me the right query that's being executed via
Reporting Services or B) different query plans are being generated for
the same SQL statement depending on the calling application. Neither
of those make any sense to me.
Thanks again for your help.|||I have seen this with other people but with stored procedures not SQL. If a
stored procedure acts differently then you can add a With Recompile to fix
the problem. I really don't understand how the same SQL can act different
but that is what I thought was happening to you.
Bruce
<stephen.lee.moore@.gmail.com> wrote in message
news:2cd5adad-6a86-414b-9840-2b3b05e58c31@.j44g2000hsj.googlegroups.com...
>> First, can you put this in a stored procedure and then call that from
>> both
>> places and see if that makes a difference?
> Wow -- good suggestion! That seemed to fix it.
> Any ideas why in the world would a different query plan be generated
> from Reporting Services than from SSMS? It seems like either A)
> Profiler isn't giving me the right query that's being executed via
> Reporting Services or B) different query plans are being generated for
> the same SQL statement depending on the calling application. Neither
> of those make any sense to me.
> Thanks again for your help.

query

Is it possible to design a reporting services report so that you can choose
the parameters that you are after (i.e. selecting from drop downs, etc... to
pass parameters to the underlying sql query)?
ThanksYes it is.
Behold:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_interactive_v1_50fn.asp
"farshad" wrote:
> Is it possible to design a reporting services report so that you can choose
> the parameters that you are after (i.e. selecting from drop downs, etc... to
> pass parameters to the underlying sql query)?
> Thankssql

Quering tables in replication

Hi I have an inventory Table that is updated every 1 hr on our stage
database. This then replicates down to our reporting server using
tranactional replication . We have web pages that access the inventory table
on our reporting server and when reporting from this, this is sometimes blank
due to the transactional updates going on. The transactional updates takes 10
to 20 minutes. Does any one have any suggestions where I can keep a table for
reporting services but not in a state when it is not available for longer
then 5 mins or so.
thanks
Sammy
Sammy,
you could issue NOLOCK hints in the reporting query, or force the
distribution agent to work out of hours.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Queries used in V?deo for Beginners

Hi,

I just installed reporting services and now starting with the video tutorial for reporting services(http://msdn2.microsoft.com/en-us/express/aa718391.aspx)

In Video 10 and 11 some queries are used to demonstrate building reports. I would like to repeat the steps in the video but I need the SQL Queries used in those videos.

Does anyone have any idea where I can download those SQL queries in order to programm the same reports as shown in the videos?

Many thanks for your replies and best regards from Switzerland

Chris

The samples have moved to Codeplex download and install the samples and databases, attach the database and go to the SQL Server folder to subfolder 90 and you will see the samples open the Reporting samples AdventureWorks Samples double click the solution file and if you have SSRS installed VS2005 will open the Reports solution you can look at the code. Hope this helps.

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

sql

queries filling up logfile

There is a file in my c:\winnt\system32 by the name sysfile.log, and it
contains what seem to be the queries a reporting tool uses, and its filling
up on disk space real fast,
is anyone aware of this problem
please help..asapHi
You don't say what the report tool is! You may want to contact the
manufacturer. Also check that you don't have ODBC tracing turned on if you
are using a DNS, usually the default file is different to your filename but
it can be changed.
John
"Santu" <Santu@.discussions.microsoft.com> wrote in message
news:8D4006B0-3CAB-44DE-9014-C9D22C4BF7B9@.microsoft.com...
> There is a file in my c:\winnt\system32 by the name sysfile.log, and it
> contains what seem to be the queries a reporting tool uses, and its
> filling
> up on disk space real fast,
> is anyone aware of this problem
> please help..asap
>|||That was exactly the problem,
thank you so much,
you're our hero|||Hi
I am glad it is fixed despite my dyslexic DSN!!
You should see an improvement when you use other tools as well.
John
"Santu" wrote:

> That was exactly the problem,
> thank you so much,
> you're our hero

queries and reporting from corporative database non IT staff

Hi! we have no Business Intelligence solution in my job and the general manager asked for a query and reports system where he (and other section managers and non IT staff) could query the corporative database (we work in healthcare, so it's mostly about patients, clinic histories, treatments) so I will propose them SQL SERVER 2005. I'll tell you my general idea and maybe you could tell me if I'm right: Through Integration Services we will load our data from the corporative database (it's Borland's InterBase) and generate a datawarehouse (now we don't have a datawarehouse) then through Reporting Services we can query this datawarehouse to generate different reports (this reports can be generated for non-technical staff, but staff who knows quite a lot about for example the different treatments that different groups of patients follow, so this staff may want to query about which patients followed which treatment in a period of time and generate by himself a report about that). And through Analysis Services we could (in a future) generate some OLAP solutions, Data Mining etc

But for the query and report system it could be enough to start with Integration Services and Reporting Services? it's very important for this system to work efficiently in terms of time: the non-technical staff generates the query and in seconds receives the report result... some of this non IT staff who will use the system knows exactly which information we house in each InterBase table, so through this system they would like to generate their own queries and reports (this is a different level of non-IT staff who is in between a Medical doctor and a Software engineer, this staff does have some technical background specially in SQL.

So my idea is to have an SQL SERVER 2005 to which this staff gets connected via LAN (all this system runs locally in one corporative place, will not run through Internet) feeded by the InterBase corporative database and delivering efficiently queries and reports... is this possible? could I test this using the trial free 6 months version? and after that if everything's working fine how much will I have to pay for 15 persons to access the SQL SERVER 2005 for keeping using the system?

This sounds like a good solution. I believe there are three stages of data presentation at a company: Data storage and retrieval, a good reporting strategy, and then Business Intelligence. SQL Server 2005 contains all the tools you need to do all three. The engine (and good application programming) handles number one, SSIS and Reporting Services handles number two, and the new Analysis Services handles number three.

You can read more about what I think on this here:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=159&rl=1

If this answers your question, make sure to mark it "answered" so that others can quickly locate it.

Buck Woody
http://www.buckwoody.com

|||

Thanks!! just one question to get the general idea: in the Data storage and retrieval part is when you create the datawarehouse? so the original data is somehow "rearranged" for the Reporting Services to query the data more efficiently..

I don't understand how the data is queried efficiently

|||

Good question - if you'll check out my series of articles I referenced in the last post, you'll see that the data warehouse is a different structure than your data store. I think you can get the reports you're looking for out of the ODS layer I talk about. Check out those articles and I think you'll find what you're looking for.

Buck

Queries against Analysis Server executed several times in SSRS

Using Reporting Services 2005 with SSAS 2005 I have a report working with
some parameters. In queries for the parameters some default values were
calculated. E.g. the current date. Then these values were used as input to
create mdx statements. Parameters!kdjfaj.value
When watching what is happening on the SSAS Server with SQL Profiler I
watched the queries executing SEVERAL times ("query begin" as event class).
Is this a normal behaviour of Reporting Services?
Or is it just a gag of the Profiler Tool to repeat the queries in time?
Or is this depending on the order of the datasets for the report? If this
would be the case - how could I change the order of execution of the dataset
queries?
Best regards,
StefoonI have a similar problem. I have a report created in Visual Studio
based on a querry that retrieves data.
Today however we found a need to count how many times rhis report was
printed. Piece of cake I thought just put an UPDATE query at the botom
of the querry that retrieves data.
tested my simple UPDATE Invoice.ReminderNo = Invoice.ReminderNo + 1 in
managment studio and it worked as i shoud.
But when i tried running the report it suddenly added 10. so I put in
another UPDATE that added one letter/execution to a text field. sure
anough 10 pretty A:s.
The query contains 5 separate datasets and is run 10 times when i
render my report. I find that to striking to be a coincidence. I
believe that the querry is run twice/dataset.
How many datasets do you have, how many times is the querry run?
On 1 Mar, 14:25, Stefoon23 <Stefoo...@.discussions.microsoft.com>
wrote:
> Using Reporting Services 2005 with SSAS 2005 I have a report working with
> some parameters. In queries for the parameters some default values were
> calculated. E.g. the current date. Then these values were used as input to
> create mdx statements. Parameters!kdjfaj.value
> When watching what is happening on the SSAS Server with SQL Profiler I
> watched the queries executingSEVERALtimes("querybegin" as event class).
> Is this a normal behaviour of Reporting Services?
> Or is it just a gag of the Profiler Tool to repeat the queries in time?
> Or is this depending on the order of the datasets for the report? If this
> would be the case - how could I change the order of execution of the dataset
> queries?
> Best regards,
> Stefoon|||Hi Markus,
the proportion is about the same. It seems that any query is executed 2
times.
I understand, that the parameter queries could run several times if you have
cascading picklists or something, but the query for the report's data?
Very mysterious.
Stefoon
"markus.rohsto@.gmail.com" wrote:
> I have a similar problem. I have a report created in Visual Studio
> based on a querry that retrieves data.
> Today however we found a need to count how many times rhis report was
> printed. Piece of cake I thought just put an UPDATE query at the botom
> of the querry that retrieves data.
> tested my simple UPDATE Invoice.ReminderNo = Invoice.ReminderNo + 1 in
> managment studio and it worked as i shoud.
> But when i tried running the report it suddenly added 10. so I put in
> another UPDATE that added one letter/execution to a text field. sure
> anough 10 pretty A:s.
> The query contains 5 separate datasets and is run 10 times when i
> render my report. I find that to striking to be a coincidence. I
> believe that the querry is run twice/dataset.
> How many datasets do you have, how many times is the querry run?
> On 1 Mar, 14:25, Stefoon23 <Stefoo...@.discussions.microsoft.com>
> wrote:
> > Using Reporting Services 2005 with SSAS 2005 I have a report working with
> > some parameters. In queries for the parameters some default values were
> > calculated. E.g. the current date. Then these values were used as input to
> > create mdx statements. Parameters!kdjfaj.value
> > When watching what is happening on the SSAS Server with SQL Profiler I
> > watched the queries executingSEVERALtimes("querybegin" as event class).
> > Is this a normal behaviour of Reporting Services?
> > Or is it just a gag of the Profiler Tool to repeat the queries in time?
> >
> > Or is this depending on the order of the datasets for the report? If this
> > would be the case - how could I change the order of execution of the dataset
> > queries?
> >
> > Best regards,
> > Stefoon
>
>

Queried default values

Hello!
Iâ'm using reporting services in a web application. I have made my own user
interface (asp.net / c#) it works rather well except handling queried default
values.
Iâ'm using Stored Procedures to get the default values (non-queried default
values are no problem). The available values are selected the same way
without problems. The SP to get the default and valid values are using one of
the report parameters as a parameter and it works fine using the report
manager.
ReportParams = rs.GetReportParameters(ReportPath,null,true,ParamValues,null);
Above returns NULL or empty default values.
Can anyone help me how to handle queried default values?
If anyone is familiar with my problem, please reply with a solution.
Best Regards,
daniel_bI've done this in vb.net, and it works without problems. Are you sure
you are using the web service correctly?
I set the ParamValues parameter to be Nothing (null) if I have no known
parameter values yet, or to be an array of ParameterValues (with
prompt, name and value set) if I already know the value of some of the
parameters. I sometimes know the value of some parameters when I am
dealing with dependant parameters where the list of values for one
parameter is not known until another parameter has its value set.
ParameterList = service.GetReportParameters(ReportName, Nothing,
True, values, Nothing)
Does this help?
Kulgan.

Quarterly trending

I have a reporting query that I need to do a quarterly trending on. A
user enters a begining date and end date, and from there, I have to
determine the closest quarter to it.

Also, the actual Quarter starts on Sept 4th, then add 13 weeks to that,
will be the second quarter.

I was able to do the trending for week/month/year, but I'm stuck on
this quarterly trending.

Any help would be greatly appreciated.

Example of the monthly trending that I have written:

SELECT [VALUE],DATEPART(MONTH,DATESAMPLE) AS[MONTH]
FROM #TABLE
GROUP BY [VALUE], DATEPART(MONTH,DATESAMPLE)
ORDER BY EDIT_SP, DATEPART(MONTH,DATESAMPLE)This would be easy if your business used calendar quarters instead;
can't you make them change? <G> You could then group by
DATEPART(Quarter, DateSample)

Since that's not likely, a solution might be to use a calendar table
that takes a key Date and maps it to the appropriate quarter, eg:

CREATE TABLE Calendar (DateKey smalldatetime, PeriodQuarter int...
(other columns))

INSERT INTO Calendar (DateKey, PeriodQuarter)
SELECT '9/1/2005', 2
UNION ALL
SELECT '9/4/2005', 3

etc

You could then join and group on the PeriodQuarter value.

Just an idea.
Stu|||create a table of the quarters:

CREATE TABLE Quarters
(quarter_name CHAR(20) NOT NULL PRIMARY KEY,
start_date DATETIME NOT NULL,
end_date DATETIME NOT NULL,
CHECK (start_date < end_date ));

>> .. determine the closest quarter to it. <<

Whatr does thst mean? give me an algorithm.

QFE 859

We are attempting to install SQL Reporting Services using a network service
account for the ReportServer service. This configuration will fail without
installing QFE 859. There is allegedly a hotfix installer which will apply
the necessary hotfix, but the Microsoft KB articles go in circles without
ever offering a download.
Does anyone know where to download this hotfix and/or why Microsoft has
chosen to hide it so carefully?
The links I'm directed to are: http://support.microsoft.com/?id=821334 and
http://support.microsoft.com/kb/330391/I noticed this myself awhile back. I think what has happened is that they
pulled it because SP4 was out. SP4 is cumulative so it should work for you
(of course SP4 has a problem that requires a hotfix if you have more than 2
Gig of RAM and AWE enabled).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lowell Williams" <Lowell Williams@.discussions.microsoft.com> wrote in
message news:2DC69A07-1D0F-48D6-BE42-773B8029219B@.microsoft.com...
> We are attempting to install SQL Reporting Services using a network
> service
> account for the ReportServer service. This configuration will fail
> without
> installing QFE 859. There is allegedly a hotfix installer which will
> apply
> the necessary hotfix, but the Microsoft KB articles go in circles without
> ever offering a download.
> Does anyone know where to download this hotfix and/or why Microsoft has
> chosen to hide it so carefully?
> The links I'm directed to are: http://support.microsoft.com/?id=821334
> and
> http://support.microsoft.com/kb/330391/|||Thanks for the reply, Bruce.
Unfortunately, we're not ready to go down the SP4 road yet. It boggles the
mind that a hotfix would be pulled when there are so many different
configurations out there.
I suppose we'll have to use a domain account if the original hotfix file
really is unavailable.
Any other suggestions are appreciated.
"Bruce L-C [MVP]" wrote:
> I noticed this myself awhile back. I think what has happened is that they
> pulled it because SP4 was out. SP4 is cumulative so it should work for you
> (of course SP4 has a problem that requires a hotfix if you have more than 2
> Gig of RAM and AWE enabled).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Lowell Williams" <Lowell Williams@.discussions.microsoft.com> wrote in
> message news:2DC69A07-1D0F-48D6-BE42-773B8029219B@.microsoft.com...
> > We are attempting to install SQL Reporting Services using a network
> > service
> > account for the ReportServer service. This configuration will fail
> > without
> > installing QFE 859. There is allegedly a hotfix installer which will
> > apply
> > the necessary hotfix, but the Microsoft KB articles go in circles without
> > ever offering a download.
> >
> > Does anyone know where to download this hotfix and/or why Microsoft has
> > chosen to hide it so carefully?
> >
> > The links I'm directed to are: http://support.microsoft.com/?id=821334
> > and
> > http://support.microsoft.com/kb/330391/
>
>|||You could also call support. It should be a free call.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lowell Williams" <LowellWilliams@.discussions.microsoft.com> wrote in
message news:33ECDA63-BCB5-4469-9E81-9EEBAAB6E22C@.microsoft.com...
> Thanks for the reply, Bruce.
> Unfortunately, we're not ready to go down the SP4 road yet. It boggles
> the
> mind that a hotfix would be pulled when there are so many different
> configurations out there.
> I suppose we'll have to use a domain account if the original hotfix file
> really is unavailable.
> Any other suggestions are appreciated.
> "Bruce L-C [MVP]" wrote:
>> I noticed this myself awhile back. I think what has happened is that they
>> pulled it because SP4 was out. SP4 is cumulative so it should work for
>> you
>> (of course SP4 has a problem that requires a hotfix if you have more than
>> 2
>> Gig of RAM and AWE enabled).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Lowell Williams" <Lowell Williams@.discussions.microsoft.com> wrote in
>> message news:2DC69A07-1D0F-48D6-BE42-773B8029219B@.microsoft.com...
>> > We are attempting to install SQL Reporting Services using a network
>> > service
>> > account for the ReportServer service. This configuration will fail
>> > without
>> > installing QFE 859. There is allegedly a hotfix installer which will
>> > apply
>> > the necessary hotfix, but the Microsoft KB articles go in circles
>> > without
>> > ever offering a download.
>> >
>> > Does anyone know where to download this hotfix and/or why Microsoft has
>> > chosen to hide it so carefully?
>> >
>> > The links I'm directed to are: http://support.microsoft.com/?id=821334
>> > and
>> > http://support.microsoft.com/kb/330391/
>>|||Did you get it resolved? Did you have to call? We have the identical
problem here.
"Lowell Williams" wrote:
> We are attempting to install SQL Reporting Services using a network service
> account for the ReportServer service. This configuration will fail without
> installing QFE 859. There is allegedly a hotfix installer which will apply
> the necessary hotfix, but the Microsoft KB articles go in circles without
> ever offering a download.
> Does anyone know where to download this hotfix and/or why Microsoft has
> chosen to hide it so carefully?
> The links I'm directed to are: http://support.microsoft.com/?id=821334 and
> http://support.microsoft.com/kb/330391/|||My guess is that this is part of Windows 2003 SP1. If you install SP1 you
should not need the hotfix. If you do not want to install SP1 then I would
think you need to contact support to get the hotfix.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:95CA7B1D-AAC1-45E4-9E8C-6687586B1BDC@.microsoft.com...
> Did you get it resolved? Did you have to call? We have the identical
> problem here.
>
> "Lowell Williams" wrote:
>> We are attempting to install SQL Reporting Services using a network
>> service
>> account for the ReportServer service. This configuration will fail
>> without
>> installing QFE 859. There is allegedly a hotfix installer which will
>> apply
>> the necessary hotfix, but the Microsoft KB articles go in circles without
>> ever offering a download.
>> Does anyone know where to download this hotfix and/or why Microsoft has
>> chosen to hide it so carefully?
>> The links I'm directed to are: http://support.microsoft.com/?id=821334
>> and
>> http://support.microsoft.com/kb/330391/|||We got it resolved by installing the patch, but to get it we did an end run
by having a Microsoft Partner call in to get it. I believe it took him about
five phone calls.
We started with the 800 number for partner support and went from there.
Make sure you have details available when you call in. I assume the regular
support number should get you there, and since a hotfix will solve your
problem, there should be no charge for the call (I think). Have KB article#
references from my original post, your SQL license and patch level, your
Server versions, etc. all at your fingertips when you call.
I've pasted part of the link they sent us for the patch below which might
help MS support figure out what you want. It has an expiring password on
it, so it won't help you to d/l it now... They also hinted that the patch
was customized to particular environments, and that they had to "configure"
it for us.
It was a little difficult to get them to realize what patch we wanted until
they finally transferred us to the SQL group.
"Bug470536/873/free/150452_ENU_i386_zip.exe"
Hope this helps, and good luck!
Lowell
"Rob" wrote:
> Did you get it resolved? Did you have to call? We have the identical
> problem here.
>
> "Lowell Williams" wrote:
> > We are attempting to install SQL Reporting Services using a network service
> > account for the ReportServer service. This configuration will fail without
> > installing QFE 859. There is allegedly a hotfix installer which will apply
> > the necessary hotfix, but the Microsoft KB articles go in circles without
> > ever offering a download.
> >
> > Does anyone know where to download this hotfix and/or why Microsoft has
> > chosen to hide it so carefully?
> >
> > The links I'm directed to are: http://support.microsoft.com/?id=821334 and
> > http://support.microsoft.com/kb/330391/|||I forgot to mention that there are two versions of this hotfix. You'll want
to verify with Microsoft which version you need.
The two files are called:
SQL2000-KB810185-8.00.0873-ENU.exe
SQL2000-KB884856-v8.00.0977-x86-ENU.exe
Those embedded KB articles should be of help when calling, too.
"Rob" wrote:
> Did you get it resolved? Did you have to call? We have the identical
> problem here.
>
> "Lowell Williams" wrote:
> > We are attempting to install SQL Reporting Services using a network service
> > account for the ReportServer service. This configuration will fail without
> > installing QFE 859. There is allegedly a hotfix installer which will apply
> > the necessary hotfix, but the Microsoft KB articles go in circles without
> > ever offering a download.
> >
> > Does anyone know where to download this hotfix and/or why Microsoft has
> > chosen to hide it so carefully?
> >
> > The links I'm directed to are: http://support.microsoft.com/?id=821334 and
> > http://support.microsoft.com/kb/330391/|||Thanks for all your help. I ended up installing SP4 and that also resolved
the issue.
"Lowell Williams" wrote:
> I forgot to mention that there are two versions of this hotfix. You'll want
> to verify with Microsoft which version you need.
>
> The two files are called:
> SQL2000-KB810185-8.00.0873-ENU.exe
> SQL2000-KB884856-v8.00.0977-x86-ENU.exe
> Those embedded KB articles should be of help when calling, too.
> "Rob" wrote:
> > Did you get it resolved? Did you have to call? We have the identical
> > problem here.
> >
> >
> > "Lowell Williams" wrote:
> >
> > > We are attempting to install SQL Reporting Services using a network service
> > > account for the ReportServer service. This configuration will fail without
> > > installing QFE 859. There is allegedly a hotfix installer which will apply
> > > the necessary hotfix, but the Microsoft KB articles go in circles without
> > > ever offering a download.
> > >
> > > Does anyone know where to download this hotfix and/or why Microsoft has
> > > chosen to hide it so carefully?
> > >
> > > The links I'm directed to are: http://support.microsoft.com/?id=821334 and
> > > http://support.microsoft.com/kb/330391/

Q: Standard or Enterprise

Hello,
Can I use my Standard SQL Server and Reporting services and run report
though our companyâ's internet site for everyone? Or does it have to be an
Enterprise version of SQL Server?
Thanks,
Jim.Are you talking internet or intranet. The licensing as far as RS is the same
as SQL Server. I.e. if everyone in your company can access your SQL Server
then they can access your RS. If you have RS on another machine you need an
additional license. There is no difference between Standard Edition and
Enterprise as far as how many can access RS. There is a difference in
functionality and if you don't need the additional functionality then
Standard Edition will work. Enterprise Edition adds web farm capability,
data driven subscriptions, etc. See this link for the differences in the
versions:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
Here is a licensing FAQ:
http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> Hello,
> Can I use my Standard SQL Server and Reporting services and run report
> though our company's internet site for everyone? Or does it have to be an
> Enterprise version of SQL Server?
> Thanks,
> Jim.
>|||Hello Bruce,
Thanks you very much for all your help. You helped me a lot now and in the
past.
I am using RS on top of Standard SQL Server in the intranet. We have enough
SQL Server licenses for this. Now I need to deploy some reports to internet
for our partners:
1. Can I do this if I meet licensing requirement for SQL Server without any
technical problem? (I assume I need to buy more licenses, correct?, before
doing that I want to make sure I can use Standard SQL Server and RS for our
Internet, please advice.)
2. We already have our web site accessing to our Standard SQL Server to
fetch data (there is no RS functionality on there at this point). Now; here
is more detail: our Standard SQL Server is in our domain, but Web Server is
actually is not in the domain but it is in its own workgroup. Our current
html internet application accesses this Standard SQL Server through ODBC.
Now, in our local network, my asp.net and RS applications work fine, if I put
my asp.net and RS application to this web sever, will it still access
Standard SQL Server without problem? I am suing standard SqlDataAdapter to
connect to database.
Please advice.
Thanks,
Jim.
"Bruce L-C [MVP]" wrote:
> Are you talking internet or intranet. The licensing as far as RS is the same
> as SQL Server. I.e. if everyone in your company can access your SQL Server
> then they can access your RS. If you have RS on another machine you need an
> additional license. There is no difference between Standard Edition and
> Enterprise as far as how many can access RS. There is a difference in
> functionality and if you don't need the additional functionality then
> Standard Edition will work. Enterprise Edition adds web farm capability,
> data driven subscriptions, etc. See this link for the differences in the
> versions:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
> Here is a licensing FAQ:
> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> > Hello,
> > Can I use my Standard SQL Server and Reporting services and run report
> > though our company's internet site for everyone? Or does it have to be an
> > Enterprise version of SQL Server?
> > Thanks,
> > Jim.
> >
>
>|||Let me just clarify a few things. Are you using your own front end or are
you using Report Manager? I.e. do you have your own web front end and then
are using either URL integration or web services to integrate with RS? Also,
what type of security are you using?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
> Hello Bruce,
> Thanks you very much for all your help. You helped me a lot now and in the
> past.
> I am using RS on top of Standard SQL Server in the intranet. We have
> enough
> SQL Server licenses for this. Now I need to deploy some reports to
> internet
> for our partners:
> 1. Can I do this if I meet licensing requirement for SQL Server without
> any
> technical problem? (I assume I need to buy more licenses, correct?, before
> doing that I want to make sure I can use Standard SQL Server and RS for
> our
> Internet, please advice.)
> 2. We already have our web site accessing to our Standard SQL Server to
> fetch data (there is no RS functionality on there at this point). Now;
> here
> is more detail: our Standard SQL Server is in our domain, but Web Server
> is
> actually is not in the domain but it is in its own workgroup. Our current
> html internet application accesses this Standard SQL Server through ODBC.
> Now, in our local network, my asp.net and RS applications work fine, if I
> put
> my asp.net and RS application to this web sever, will it still access
> Standard SQL Server without problem? I am suing standard SqlDataAdapter to
> connect to database.
> Please advice.
> Thanks,
> Jim.
>
> "Bruce L-C [MVP]" wrote:
>> Are you talking internet or intranet. The licensing as far as RS is the
>> same
>> as SQL Server. I.e. if everyone in your company can access your SQL
>> Server
>> then they can access your RS. If you have RS on another machine you need
>> an
>> additional license. There is no difference between Standard Edition and
>> Enterprise as far as how many can access RS. There is a difference in
>> functionality and if you don't need the additional functionality then
>> Standard Edition will work. Enterprise Edition adds web farm capability,
>> data driven subscriptions, etc. See this link for the differences in the
>> versions:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
>> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
>> Here is a licensing FAQ:
>> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
>> > Hello,
>> > Can I use my Standard SQL Server and Reporting services and run report
>> > though our company's internet site for everyone? Or does it have to be
>> > an
>> > Enterprise version of SQL Server?
>> > Thanks,
>> > Jim.
>> >
>>|||Hello Bruce,
I embedded ReportViewer into my ASP.Net application and using it as a
component. I am guessing it calls report manager, fetch data and show it
through the viewer. It works in our intranet. I am using integrated windows
authentication in our intranet. Does this answer your question? Please let me
know.
Thanks,
"Bruce L-C [MVP]" wrote:
> Let me just clarify a few things. Are you using your own front end or are
> you using Report Manager? I.e. do you have your own web front end and then
> are using either URL integration or web services to integrate with RS? Also,
> what type of security are you using?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
> > Hello Bruce,
> >
> > Thanks you very much for all your help. You helped me a lot now and in the
> > past.
> >
> > I am using RS on top of Standard SQL Server in the intranet. We have
> > enough
> > SQL Server licenses for this. Now I need to deploy some reports to
> > internet
> > for our partners:
> >
> > 1. Can I do this if I meet licensing requirement for SQL Server without
> > any
> > technical problem? (I assume I need to buy more licenses, correct?, before
> > doing that I want to make sure I can use Standard SQL Server and RS for
> > our
> > Internet, please advice.)
> >
> > 2. We already have our web site accessing to our Standard SQL Server to
> > fetch data (there is no RS functionality on there at this point). Now;
> > here
> > is more detail: our Standard SQL Server is in our domain, but Web Server
> > is
> > actually is not in the domain but it is in its own workgroup. Our current
> > html internet application accesses this Standard SQL Server through ODBC.
> > Now, in our local network, my asp.net and RS applications work fine, if I
> > put
> > my asp.net and RS application to this web sever, will it still access
> > Standard SQL Server without problem? I am suing standard SqlDataAdapter to
> > connect to database.
> > Please advice.
> > Thanks,
> > Jim.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Are you talking internet or intranet. The licensing as far as RS is the
> >> same
> >> as SQL Server. I.e. if everyone in your company can access your SQL
> >> Server
> >> then they can access your RS. If you have RS on another machine you need
> >> an
> >> additional license. There is no difference between Standard Edition and
> >> Enterprise as far as how many can access RS. There is a difference in
> >> functionality and if you don't need the additional functionality then
> >> Standard Edition will work. Enterprise Edition adds web farm capability,
> >> data driven subscriptions, etc. See this link for the differences in the
> >> versions:
> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> >>
> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
> >>
> >> Here is a licensing FAQ:
> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> >> > Hello,
> >> > Can I use my Standard SQL Server and Reporting services and run report
> >> > though our company's internet site for everyone? Or does it have to be
> >> > an
> >> > Enterprise version of SQL Server?
> >> > Thanks,
> >> > Jim.
> >> >
> >>
> >>
> >>
>
>|||The ReportViewer control uses URL integration. So, whether this is an issue
depends on how your internet access is setup. If you have a DMZ it could be
a problem. URL integration with the report control is really no different
than typing in the URL from the PC over on the internet. What I mean is that
the user has to have access to the RS machine. If your web server is on one
side of the DMZ and the RS is on the other, the user on the Internet will
not have access to it.
Another issue is security. How is the user on the internet going to be
validated. This is from Books On Line:
>>>>>>>>
Securing Reports for Global Access
Report Manager and HTML Viewer are not intended for extranet or Internet
deployment scenarios. To support external users of a report server
effectively, consider building a custom Web application. The application you
provide should be installed on the same computer as report server. You
should also implement Secure Sockets Layer (SSL) to encrypt transmitted
data.
Although custom authentication models are not currently supported, you can
use Windows authentication to support report server access to users that are
external to your organization. The following list provides guidelines about
supporting this scenario:
a.. Create a low-privileged domain user account with read-only
permissions. The account must have access to the computer hosting the report
server.
b.. Create role assignments that map the user account to specific items in
the report server folder hierarchy. You can limit access to read-only
operations by choosing the Browser predefined role for the role assignment.
c.. Configure data source connections to use Windows NT Integrated
Security if you want to access a data source using the security context of
the user. Alternatively, you can use stored credentials that specify a
different account. This approach is useful if you want to query the external
data source using an account that is different from the account that allows
access to the report server. For more information about these options, see
Specifying Credential and Connection Information.
If you have a small number of external users to support, you can consider
using Microsoft Passport. Passport accounts can be mapped to Windows
accounts. Mapping accounts is a manual process that must be performed by a
system administrator, so this approach is not practical if you want to
provide access to a large number of users.
>>>>>>>>>>
The other option (which I have never implemented so I am not an expert on
it) is to provide your own authentication instead of using Windows accounts.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:A832A82A-F212-4696-95F3-7A460C1CF618@.microsoft.com...
> Hello Bruce,
> I embedded ReportViewer into my ASP.Net application and using it as a
> component. I am guessing it calls report manager, fetch data and show it
> through the viewer. It works in our intranet. I am using integrated
> windows
> authentication in our intranet. Does this answer your question? Please let
> me
> know.
> Thanks,
> "Bruce L-C [MVP]" wrote:
>> Let me just clarify a few things. Are you using your own front end or are
>> you using Report Manager? I.e. do you have your own web front end and
>> then
>> are using either URL integration or web services to integrate with RS?
>> Also,
>> what type of security are you using?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
>> > Hello Bruce,
>> >
>> > Thanks you very much for all your help. You helped me a lot now and in
>> > the
>> > past.
>> >
>> > I am using RS on top of Standard SQL Server in the intranet. We have
>> > enough
>> > SQL Server licenses for this. Now I need to deploy some reports to
>> > internet
>> > for our partners:
>> >
>> > 1. Can I do this if I meet licensing requirement for SQL Server without
>> > any
>> > technical problem? (I assume I need to buy more licenses, correct?,
>> > before
>> > doing that I want to make sure I can use Standard SQL Server and RS for
>> > our
>> > Internet, please advice.)
>> >
>> > 2. We already have our web site accessing to our Standard SQL Server to
>> > fetch data (there is no RS functionality on there at this point). Now;
>> > here
>> > is more detail: our Standard SQL Server is in our domain, but Web
>> > Server
>> > is
>> > actually is not in the domain but it is in its own workgroup. Our
>> > current
>> > html internet application accesses this Standard SQL Server through
>> > ODBC.
>> > Now, in our local network, my asp.net and RS applications work fine, if
>> > I
>> > put
>> > my asp.net and RS application to this web sever, will it still access
>> > Standard SQL Server without problem? I am suing standard SqlDataAdapter
>> > to
>> > connect to database.
>> > Please advice.
>> > Thanks,
>> > Jim.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Are you talking internet or intranet. The licensing as far as RS is
>> >> the
>> >> same
>> >> as SQL Server. I.e. if everyone in your company can access your SQL
>> >> Server
>> >> then they can access your RS. If you have RS on another machine you
>> >> need
>> >> an
>> >> additional license. There is no difference between Standard Edition
>> >> and
>> >> Enterprise as far as how many can access RS. There is a difference in
>> >> functionality and if you don't need the additional functionality then
>> >> Standard Edition will work. Enterprise Edition adds web farm
>> >> capability,
>> >> data driven subscriptions, etc. See this link for the differences in
>> >> the
>> >> versions:
>> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
>> >>
>> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
>> >>
>> >> Here is a licensing FAQ:
>> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
>> >> > Hello,
>> >> > Can I use my Standard SQL Server and Reporting services and run
>> >> > report
>> >> > though our company's internet site for everyone? Or does it have to
>> >> > be
>> >> > an
>> >> > Enterprise version of SQL Server?
>> >> > Thanks,
>> >> > Jim.
>> >> >
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thanks for your responses. I will be implementing your security steps, if I
install RS to DMZ machine, and point it to the database in our domain (so DB
is in the network and application and RS is in the DMZ), will that work?
Thanks,
"Bruce L-C [MVP]" wrote:
> The ReportViewer control uses URL integration. So, whether this is an issue
> depends on how your internet access is setup. If you have a DMZ it could be
> a problem. URL integration with the report control is really no different
> than typing in the URL from the PC over on the internet. What I mean is that
> the user has to have access to the RS machine. If your web server is on one
> side of the DMZ and the RS is on the other, the user on the Internet will
> not have access to it.
> Another issue is security. How is the user on the internet going to be
> validated. This is from Books On Line:
> >>>>>>>>
> Securing Reports for Global Access
> Report Manager and HTML Viewer are not intended for extranet or Internet
> deployment scenarios. To support external users of a report server
> effectively, consider building a custom Web application. The application you
> provide should be installed on the same computer as report server. You
> should also implement Secure Sockets Layer (SSL) to encrypt transmitted
> data.
> Although custom authentication models are not currently supported, you can
> use Windows authentication to support report server access to users that are
> external to your organization. The following list provides guidelines about
> supporting this scenario:
> a.. Create a low-privileged domain user account with read-only
> permissions. The account must have access to the computer hosting the report
> server.
> b.. Create role assignments that map the user account to specific items in
> the report server folder hierarchy. You can limit access to read-only
> operations by choosing the Browser predefined role for the role assignment.
> c.. Configure data source connections to use Windows NT Integrated
> Security if you want to access a data source using the security context of
> the user. Alternatively, you can use stored credentials that specify a
> different account. This approach is useful if you want to query the external
> data source using an account that is different from the account that allows
> access to the report server. For more information about these options, see
> Specifying Credential and Connection Information.
> If you have a small number of external users to support, you can consider
> using Microsoft Passport. Passport accounts can be mapped to Windows
> accounts. Mapping accounts is a manual process that must be performed by a
> system administrator, so this approach is not practical if you want to
> provide access to a large number of users.
> >>>>>>>>>>
> The other option (which I have never implemented so I am not an expert on
> it) is to provide your own authentication instead of using Windows accounts.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:A832A82A-F212-4696-95F3-7A460C1CF618@.microsoft.com...
> > Hello Bruce,
> > I embedded ReportViewer into my ASP.Net application and using it as a
> > component. I am guessing it calls report manager, fetch data and show it
> > through the viewer. It works in our intranet. I am using integrated
> > windows
> > authentication in our intranet. Does this answer your question? Please let
> > me
> > know.
> > Thanks,
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Let me just clarify a few things. Are you using your own front end or are
> >> you using Report Manager? I.e. do you have your own web front end and
> >> then
> >> are using either URL integration or web services to integrate with RS?
> >> Also,
> >> what type of security are you using?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
> >> > Hello Bruce,
> >> >
> >> > Thanks you very much for all your help. You helped me a lot now and in
> >> > the
> >> > past.
> >> >
> >> > I am using RS on top of Standard SQL Server in the intranet. We have
> >> > enough
> >> > SQL Server licenses for this. Now I need to deploy some reports to
> >> > internet
> >> > for our partners:
> >> >
> >> > 1. Can I do this if I meet licensing requirement for SQL Server without
> >> > any
> >> > technical problem? (I assume I need to buy more licenses, correct?,
> >> > before
> >> > doing that I want to make sure I can use Standard SQL Server and RS for
> >> > our
> >> > Internet, please advice.)
> >> >
> >> > 2. We already have our web site accessing to our Standard SQL Server to
> >> > fetch data (there is no RS functionality on there at this point). Now;
> >> > here
> >> > is more detail: our Standard SQL Server is in our domain, but Web
> >> > Server
> >> > is
> >> > actually is not in the domain but it is in its own workgroup. Our
> >> > current
> >> > html internet application accesses this Standard SQL Server through
> >> > ODBC.
> >> > Now, in our local network, my asp.net and RS applications work fine, if
> >> > I
> >> > put
> >> > my asp.net and RS application to this web sever, will it still access
> >> > Standard SQL Server without problem? I am suing standard SqlDataAdapter
> >> > to
> >> > connect to database.
> >> > Please advice.
> >> > Thanks,
> >> > Jim.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Are you talking internet or intranet. The licensing as far as RS is
> >> >> the
> >> >> same
> >> >> as SQL Server. I.e. if everyone in your company can access your SQL
> >> >> Server
> >> >> then they can access your RS. If you have RS on another machine you
> >> >> need
> >> >> an
> >> >> additional license. There is no difference between Standard Edition
> >> >> and
> >> >> Enterprise as far as how many can access RS. There is a difference in
> >> >> functionality and if you don't need the additional functionality then
> >> >> Standard Edition will work. Enterprise Edition adds web farm
> >> >> capability,
> >> >> data driven subscriptions, etc. See this link for the differences in
> >> >> the
> >> >> versions:
> >> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> >> >>
> >> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
> >> >>
> >> >> Here is a licensing FAQ:
> >> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> >> >> > Hello,
> >> >> > Can I use my Standard SQL Server and Reporting services and run
> >> >> > report
> >> >> > though our company's internet site for everyone? Or does it have to
> >> >> > be
> >> >> > an
> >> >> > Enterprise version of SQL Server?
> >> >> > Thanks,
> >> >> > Jim.
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||That will take care of the issue with URL integration. It does not deal with
the issue of accounts. If you can give your business users a domain account
then you will be in good shape. I do not operate this way so take it with a
grain of salt. What I have done is log into the intranet via VPN. When this
occurs and you connect to RS it does not know who you are (with my VPN
connection from home, I am not logged onto a domain). When I do this I then
get prompted for a username and password. I haven't done this for awhile so
I don't know if it prompts for the domain or if I have to put in the
username like this: MyDomainName\MyUsername
Note that putting your RS in the DMZ (which means you have split RS and the
Database) requires another license. Plus, when SQL Server is being used on
the internet that affects licensing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:D961D195-A824-44C8-9BC7-88126739FFCF@.microsoft.com...
> Hi Bruce,
> Thanks for your responses. I will be implementing your security steps, if
> I
> install RS to DMZ machine, and point it to the database in our domain (so
> DB
> is in the network and application and RS is in the DMZ), will that work?
> Thanks,
>
> "Bruce L-C [MVP]" wrote:
>> The ReportViewer control uses URL integration. So, whether this is an
>> issue
>> depends on how your internet access is setup. If you have a DMZ it could
>> be
>> a problem. URL integration with the report control is really no different
>> than typing in the URL from the PC over on the internet. What I mean is
>> that
>> the user has to have access to the RS machine. If your web server is on
>> one
>> side of the DMZ and the RS is on the other, the user on the Internet will
>> not have access to it.
>> Another issue is security. How is the user on the internet going to be
>> validated. This is from Books On Line:
>> >>>>>>>>
>> Securing Reports for Global Access
>> Report Manager and HTML Viewer are not intended for extranet or Internet
>> deployment scenarios. To support external users of a report server
>> effectively, consider building a custom Web application. The application
>> you
>> provide should be installed on the same computer as report server. You
>> should also implement Secure Sockets Layer (SSL) to encrypt transmitted
>> data.
>> Although custom authentication models are not currently supported, you
>> can
>> use Windows authentication to support report server access to users that
>> are
>> external to your organization. The following list provides guidelines
>> about
>> supporting this scenario:
>> a.. Create a low-privileged domain user account with read-only
>> permissions. The account must have access to the computer hosting the
>> report
>> server.
>> b.. Create role assignments that map the user account to specific items
>> in
>> the report server folder hierarchy. You can limit access to read-only
>> operations by choosing the Browser predefined role for the role
>> assignment.
>> c.. Configure data source connections to use Windows NT Integrated
>> Security if you want to access a data source using the security context
>> of
>> the user. Alternatively, you can use stored credentials that specify a
>> different account. This approach is useful if you want to query the
>> external
>> data source using an account that is different from the account that
>> allows
>> access to the report server. For more information about these options,
>> see
>> Specifying Credential and Connection Information.
>> If you have a small number of external users to support, you can consider
>> using Microsoft Passport. Passport accounts can be mapped to Windows
>> accounts. Mapping accounts is a manual process that must be performed by
>> a
>> system administrator, so this approach is not practical if you want to
>> provide access to a large number of users.
>> >>>>>>>>>>
>> The other option (which I have never implemented so I am not an expert on
>> it) is to provide your own authentication instead of using Windows
>> accounts.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:A832A82A-F212-4696-95F3-7A460C1CF618@.microsoft.com...
>> > Hello Bruce,
>> > I embedded ReportViewer into my ASP.Net application and using it as a
>> > component. I am guessing it calls report manager, fetch data and show
>> > it
>> > through the viewer. It works in our intranet. I am using integrated
>> > windows
>> > authentication in our intranet. Does this answer your question? Please
>> > let
>> > me
>> > know.
>> > Thanks,
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Let me just clarify a few things. Are you using your own front end or
>> >> are
>> >> you using Report Manager? I.e. do you have your own web front end and
>> >> then
>> >> are using either URL integration or web services to integrate with RS?
>> >> Also,
>> >> what type of security are you using?
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> >> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
>> >> > Hello Bruce,
>> >> >
>> >> > Thanks you very much for all your help. You helped me a lot now and
>> >> > in
>> >> > the
>> >> > past.
>> >> >
>> >> > I am using RS on top of Standard SQL Server in the intranet. We have
>> >> > enough
>> >> > SQL Server licenses for this. Now I need to deploy some reports to
>> >> > internet
>> >> > for our partners:
>> >> >
>> >> > 1. Can I do this if I meet licensing requirement for SQL Server
>> >> > without
>> >> > any
>> >> > technical problem? (I assume I need to buy more licenses, correct?,
>> >> > before
>> >> > doing that I want to make sure I can use Standard SQL Server and RS
>> >> > for
>> >> > our
>> >> > Internet, please advice.)
>> >> >
>> >> > 2. We already have our web site accessing to our Standard SQL Server
>> >> > to
>> >> > fetch data (there is no RS functionality on there at this point).
>> >> > Now;
>> >> > here
>> >> > is more detail: our Standard SQL Server is in our domain, but Web
>> >> > Server
>> >> > is
>> >> > actually is not in the domain but it is in its own workgroup. Our
>> >> > current
>> >> > html internet application accesses this Standard SQL Server through
>> >> > ODBC.
>> >> > Now, in our local network, my asp.net and RS applications work fine,
>> >> > if
>> >> > I
>> >> > put
>> >> > my asp.net and RS application to this web sever, will it still
>> >> > access
>> >> > Standard SQL Server without problem? I am suing standard
>> >> > SqlDataAdapter
>> >> > to
>> >> > connect to database.
>> >> > Please advice.
>> >> > Thanks,
>> >> > Jim.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Are you talking internet or intranet. The licensing as far as RS is
>> >> >> the
>> >> >> same
>> >> >> as SQL Server. I.e. if everyone in your company can access your SQL
>> >> >> Server
>> >> >> then they can access your RS. If you have RS on another machine you
>> >> >> need
>> >> >> an
>> >> >> additional license. There is no difference between Standard Edition
>> >> >> and
>> >> >> Enterprise as far as how many can access RS. There is a difference
>> >> >> in
>> >> >> functionality and if you don't need the additional functionality
>> >> >> then
>> >> >> Standard Edition will work. Enterprise Edition adds web farm
>> >> >> capability,
>> >> >> data driven subscriptions, etc. See this link for the differences
>> >> >> in
>> >> >> the
>> >> >> versions:
>> >> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
>> >> >>
>> >> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
>> >> >>
>> >> >> Here is a licensing FAQ:
>> >> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> >> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
>> >> >> > Hello,
>> >> >> > Can I use my Standard SQL Server and Reporting services and run
>> >> >> > report
>> >> >> > though our company's internet site for everyone? Or does it have
>> >> >> > to
>> >> >> > be
>> >> >> > an
>> >> >> > Enterprise version of SQL Server?
>> >> >> > Thanks,
>> >> >> > Jim.
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Q: sample reports

Hello,
I am trying to learn and understand what can be done in reporting services,
is there any site I can download sample professional reports with reporting
services?
Thanks,Jim,
Take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_9pmb.asp.
Andrew Watt
MVP - InfoPath
On Thu, 13 Oct 2005 21:21:28 -0700, JIM.H.
<JIMH@.discussions.microsoft.com> wrote:
>Hello,
>I am trying to learn and understand what can be done in reporting services,
>is there any site I can download sample professional reports with reporting
>services?
>Thanks,

Q: RS2000 what OS?

Hello,
Can I install reporting services in a XP Pro, or windows 2000. We have SQL
Server 2000 installed on XP Pro, I was trying to install RS2000 and I got a
message it sais OS should be a server. Does that mean RS2000 can only be
installed on a server? Can I install RS2000 on a windows 2000 machine?PiBDYW4gSSBpbnN0YWxsIHJlcG9ydGluZyBzZXJ2aWNlcyBpbiBhIFhQIFBybywgb3Igd2luZG93
cyAyMDAwLiBXZSBoYXZlIFNRTCANCj4gU2VydmVyIDIwMDAgaW5zdGFsbGVkIG9uIFhQIFBybywg
SSB3YXMgdHJ5aW5nIHRvIGluc3RhbGwgUlMyMDAwIGFuZCBJIGdvdCBhIA0KPiBtZXNzYWdlIGl0
IHNhaXMgT1Mgc2hvdWxkIGJlIGEgc2VydmVyLiBEb2VzIHRoYXQgbWVhbiBSUzIwMDAgY2FuIG9u
bHkgYmUgDQo+IGluc3RhbGxlZCBvbiBhIHNlcnZlcj8gQ2FuIEkgaW5zdGFsbCBSUzIwMDAgb24g
YSB3aW5kb3dzIDIwMDAgbWFjaGluZT8NCg0KaHR0cDovL21zZG4ubWljcm9zb2Z0LmNvbS9saWJy
YXJ5L2VuLXVzL1JTaW5zdGFsbC9odG0vZ3NfaW5zdGFsbGluZ3JzX3YxXzhqb20uYXNw

Q: RS on XP

Hello,

I have SQL Server 2000 installed on my Windows XP, can I install Reporting Services to this machine? If yes, where can I get it?

Thanks,

No you can't install SRS Server on an XP machine. You could fiind more info onhttp://www.microsoft.com/sql/reporting/default.mspx
|||

Thank you for the reply. I could not really locate it, can you tell me the exact URL that tells we can not install it to XP. I need to send it to my manager.

Thanks,

|||http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
The above url won't show you how to install SRS it will just show your manager that you can't install the server componets on an XP box. You can only install the development edition as per the URL above.|||

Is there anyway I can download the developer edition on the internet? I think the trial RS version is Enterprise, I have SQL Server license what should I do to get RS Developer if it is not in the internet?
Thanks for your help.

|||

Unfortuneatly I don't know of any site where you can download developer edition of RS. You should be able to install the development part of Enterprise SRS on your XP machine. However you won't be able to host SRS reports, for this you'll need a server OS.

q: reporting service in SQL 2005

Hello,
I installed SQL Server 2005 into a Windows 2005 Pro machine, will I be able
to use Reporting service to deploy the reports here? Is there any web site
that show step by step how I can do that?
Thanks,On Sun, 21 May 2006 04:59:02 -0700, JIM.H.
<JIMH@.discussions.microsoft.com> wrote:

>Hello,
>I installed SQL Server 2005 into a Windows 2005 Pro machine, will I be able
>to use Reporting service to deploy the reports here? Is there any web site
>that show step by step how I can do that?
>Thanks,
Jim,
There is no Windows 2005. I guess you mean Windows XP Pro.
XP Pro is really appropriate only for a development machine for SQL
Server 2005.There are technical and potential licensing issues.
Questions on Reporting Services are better directed to the
microsoft.public.sqlserver.reportingsvcs newsgroup.
There is series of webcasts under way on Reporting Services 2005 at
http://www.microsoft.com/events.
Andrew Watt MVP

q: reporting service in SQL 2005

Hello,
I installed SQL Server 2005 into a Windows 2005 Pro machine, will I be able
to use Reporting service to deploy the reports here? Is there any web site
that show step by step how I can do that?
Thanks,On Sun, 21 May 2006 04:59:02 -0700, JIM.H.
<JIMH@.discussions.microsoft.com> wrote:
>Hello,
>I installed SQL Server 2005 into a Windows 2005 Pro machine, will I be able
>to use Reporting service to deploy the reports here? Is there any web site
>that show step by step how I can do that?
>Thanks,
Jim,
There is no Windows 2005. I guess you mean Windows XP Pro.
XP Pro is really appropriate only for a development machine for SQL
Server 2005.There are technical and potential licensing issues.
Questions on Reporting Services are better directed to the
microsoft.public.sqlserver.reportingsvcs newsgroup.
There is series of webcasts under way on Reporting Services 2005 at
http://www.microsoft.com/events.
Andrew Watt MVP

q: reporting service 2005

Hello,
I installed SQL Server 2005 into a Windows 2000 Pro machine, I have
following question:
1. will I be able to use Reporting services to deploy the reports to the
same machine as a report server?
2. Can I modify and deploy mo old reports written in RS2000
3. Is there any web site that show step by step how I can work with RS2005?
Thanks,On Sun, 21 May 2006 09:36:01 -0700, JIM.H.
<JIMH@.discussions.microsoft.com> wrote:
>Hello,
>I installed SQL Server 2005 into a Windows 2000 Pro machine, I have
>following question:
>1. will I be able to use Reporting services to deploy the reports to the
>same machine as a report server?
Yes, you should be able to do that. Consider performance implications
if the server is anything but lightly loaded.
>2. Can I modify and deploy mo old reports written in RS2000
Yes, but it's a one way process (for most practical purposes). Once
you have opened an RS2000 report in BIDS and deployed it on RS2005 you
won't be able (without some hand editing) to deploy the report at a
future date on an RS2000 server.
If you have a possible need to return/use RS2000 make a backup in the
old format before deploying on RS2005.
>3. Is there any web site that show step by step how I can work with RS2005?
Books Online has a lot of useful information.
Also take a look at http://www.microsoft.com/events. There is a series
of RS2005 webcasts underway.
Andrew Watt MVP
>Thanks,

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?
select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:

> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:

> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:
> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>