Finally success!
What I found was that I couldn't pull a database from another install of
Reporting Services. Since I had already installed it in our lab environment
on a 32-bit server, I first tried to attach that database. But when I did
that, Reporting Services thought I wanted to join a web farm. Then when I
tried to install it with the .ini file with SQL authentication to create the
database (RSSETUPACCOUNT/RSSETUPPASSWORD), it was not creating the database
(even though the SQL user I was using had SysAdmin permissions). I finally
gave my NT account SysAdmin rights and then it would create the database
(using the default install without an .ini file). Once that was complete,
sure enough, I could just move it to the 64-bit server (using standard
detach/attach). One final step was to give the SQL (or NT) user permissions
in the database (I started with datareader and datawriter).
[quoted text, click to view] "Daniel Reib [MSFT]" wrote:
> Setup will not allow you to install using a 64 bit version of SQL. There
> are manual steps you can perform to get this to work, but it would require a
> 32 bit version of SQL.
>
> 1) Install RS pointing to the 32 bit version of SQL.
> 2) move both the ReportServer DB and the ReportServerTemp DB to the 64 bit
> version (I don't know what the exact steps are to move a database from a 32
> bit to a 64 bit sql, you would have to investigate this)
> 3) use rsconfig.exe to point RS to the 64 bit version of the catalog
>
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Malinda Jepsen" <Malinda Jepsen@discussions.microsoft.com> wrote in message
> news:E3DE691A-4A16-46CD-BE89-9964EE0FDCBA@microsoft.com...
> > I am attempting to install Reporting Services on a 32-bit application
> server
> > with the database on another box running SQL Server 2000 "Enterprise
> Edition
> > (64-bit)" . I am receiving the following error:
> > "This edition of the Report Server Database is not supported on the
> edition
> > of SQL Server 2000 you have chosen. Please choose ..."
> >
> > The version I am attempting to install is "Reporting Services Enterprise
> > Edition". I've verified in the install window that it is the Enterprise
> > Edition of Reporting Services that I am trying to install. I have
> verified
> > that I can connect to the 64-bit server from my application server and my
> SQL
> > Login Account has SysAdmin permissions. I ran the SELECT
> > SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
> > SERVERPROPERTY ('edition') command that I read in another thread and it
> > returned the following information:
> > 8.00.760 SP3 Enterprise Edition (64-bit)
> >
> > I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
> > anyone installed Reporting Services using 64-bit SQL Server 2000 for the
> > database repository?
> >
> > Thanks in advance...
>
>
