Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts

Sunday, March 25, 2012

Download Reporting Services for SQL 2000?

We have license for SQL 2000 but all I can find on the Microsoft download
page was the 120-days trial for Reporting Service and SP1, SP2.
http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
Is there a place to download the release version instead of the 120 days
trial?
Thanks!
AlbertAlbert,
See
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx#XSLTsection132121120120
for the information you need.
As far as I am aware there is no download option for a non-time
limited version of RS2000.
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 09:35:07 -0700, Albert
<Albert@.discussions.microsoft.com> wrote:
>We have license for SQL 2000 but all I can find on the Microsoft download
>page was the 120-days trial for Reporting Service and SP1, SP2.
>http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
>Is there a place to download the release version instead of the 120 days
>trial?
>Thanks!
>Albert|||Thanks a lot!
Albert
"Andrew Watt [MVP - InfoPath]" wrote:
> Albert,
> See
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx#XSLTsection132121120120
> for the information you need.
> As far as I am aware there is no download option for a non-time
> limited version of RS2000.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 09:35:07 -0700, Albert
> <Albert@.discussions.microsoft.com> wrote:
> >We have license for SQL 2000 but all I can find on the Microsoft download
> >page was the 120-days trial for Reporting Service and SP1, SP2.
> >
> >http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
> >
> >Is there a place to download the release version instead of the 120 days
> >trial?
> >
> >Thanks!
> >
> >Albert
>|||If you are an MSDN Subscriber, you should be able to download it through the
MSDN Subscriber downloads. It's stored under Server -> SQL Server -> SQL
Server 2000 -> SQL Server 2000 Reporting Services. You can also download SP
1 and 2 from the same place.
It might depend on what subscription level you are on, but if your company
is a subscriber, check it out.
Kaisa M. Lindahl
"Albert" <Albert@.discussions.microsoft.com> wrote in message
news:7509ED44-FE5C-4BBA-B22E-7143B9EAE224@.microsoft.com...
> We have license for SQL 2000 but all I can find on the Microsoft download
> page was the 120-days trial for Reporting Service and SP1, SP2.
> http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
> Is there a place to download the release version instead of the 120 days
> trial?
> Thanks!
> Albert

Friday, March 9, 2012

double authentication to get to a report? 2nd auth fails?

I recently implemented Reporting Services (w/ SP1) on a 2003 Server w/ SQL
Srvr 2000(SP3). On the server is a group of ID's from my company's domain.
This group is given the Browser role which works to a point of navigating
folders.
When the user chooses a report they are re-authenticated and the
authentication fails. In looking at the URL I notice everything is fine with
https://{server}/Reports/Pages/Folder.aspx but when you click on a report
https://{server}/Reports/Pages/Report.aspx is called and the authentication
pops up and declines the user (even though it's a valid login using
domain\user).
Other issues:
I received an error during set up which I found the work around for in an
MSDN KB. The reason why I mention it is that is has you create the virutal
directories manually after the fact so perhaps a permissions was missed?I have also started to have this problem. Although it is only on a large
dataset. Smaller reports seem to work fine.
Please post a solution if you get one.
-- Jesse
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:EC3D5EA2-DFD8-4554-89A1-EEC4B2BC3A2D@.microsoft.com...
>I recently implemented Reporting Services (w/ SP1) on a 2003 Server w/ SQL
> Srvr 2000(SP3). On the server is a group of ID's from my company's domain.
> This group is given the Browser role which works to a point of navigating
> folders.
> When the user chooses a report they are re-authenticated and the
> authentication fails. In looking at the URL I notice everything is fine
> with
> https://{server}/Reports/Pages/Folder.aspx but when you click on a report
> https://{server}/Reports/Pages/Report.aspx is called and the
> authentication
> pops up and declines the user (even though it's a valid login using
> domain\user).
> Other issues:
> I received an error during set up which I found the work around for in an
> MSDN KB. The reason why I mention it is that is has you create the virutal
> directories manually after the fact so perhaps a permissions was missed?|||I continued to work on this and found a solution... I gave the group
permission to ReportServer by right clicking in IIS Mgr and using permissions
there.
** I gave Read, Execute, and List Folders permissions. Is that too much? **
Jesse:
I would think if one user ID can access one report then that means all of
the permissions are set up to generate a report. I would look in the security
tab under properties and ensure the role that's attached to the group (or
user id) is there.
Also, do the reports use embedded ID's for pulling queries? Check that the
user ID in the Data Source has the proper permissions to the table... just
log into SQL Anlalyzer with the ID and execute the query there.
That's my 2 cents...
"Jesse Beveridge" wrote:
> I have also started to have this problem. Although it is only on a large
> dataset. Smaller reports seem to work fine.
> Please post a solution if you get one.
> -- Jesse
> "Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
> news:EC3D5EA2-DFD8-4554-89A1-EEC4B2BC3A2D@.microsoft.com...
> >I recently implemented Reporting Services (w/ SP1) on a 2003 Server w/ SQL
> > Srvr 2000(SP3). On the server is a group of ID's from my company's domain.
> > This group is given the Browser role which works to a point of navigating
> > folders.
> >
> > When the user chooses a report they are re-authenticated and the
> > authentication fails. In looking at the URL I notice everything is fine
> > with
> > https://{server}/Reports/Pages/Folder.aspx but when you click on a report
> > https://{server}/Reports/Pages/Report.aspx is called and the
> > authentication
> > pops up and declines the user (even though it's a valid login using
> > domain\user).
> >
> > Other issues:
> > I received an error during set up which I found the work around for in an
> > MSDN KB. The reason why I mention it is that is has you create the virutal
> > directories manually after the fact so perhaps a permissions was missed?
>
>