Reporting Services site asks for credentials

Here's a summary of my problem before I get into the details:
the reporting services site that runs reports is asking for credentials,
which I give, but then brings me to a page that says "You are not authorized
to view this page." When I browse to the admin page for reporting services,
it gives me this info:
Server Error in '/ReportAdmin' Application
----
Attempted to load a 64-bit assembly on a 32-bit platform. Use
ReflectionOnlyLoad() instead if trying to load for reflection purposes.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.BadImageFormatException: Attempted to load a
64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if
trying to load for reflection purposes.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Here's the details:
Reporting Services is running on the same server as SQL is, which has
Windows 2003 Server Enterprise 64 bit. We're running SQL2005 Enterprise
Edition 64 bit on this server. There were no problems when IIS was running
on 64 bit, however, I had to change to allow 32 bit because of a legacy site
that we have running on the server that needs to run ASP.NET v1.1.
So I installed the .net framework 1.1, installed front page server
extensions for 64 bit, enabled 32 bit on 64 using adsutil, and then I ran
aspnet_regiis -s from the c:\windows\microsoft.net\framework\v2.0.xxxx. I
then changed the legacy site to run v1.1.4322, but even still the reporting
services sites are not working. One other site that runs under v2.0 is
working.
I'm guessing that this has something to do with security that has to be
setup to allow credentials to be passed to the DC from this server, but I'm
not sure where to start looking. Thanks for any help/suggestions.Did you ever have it working?
Check out the two reporting services websites and make sure both are using
the 2.0 framework.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message
news:95ED2E52-C7A6-4C5B-ABF6-977B80875898@.microsoft.com...
> Here's a summary of my problem before I get into the details:
> the reporting services site that runs reports is asking for credentials,
> which I give, but then brings me to a page that says "You are not
> authorized
> to view this page." When I browse to the admin page for reporting
> services,
> it gives me this info:
> Server Error in '/ReportAdmin' Application.
> ----
> Attempted to load a 64-bit assembly on a 32-bit platform. Use
> ReflectionOnlyLoad() instead if trying to load for reflection purposes.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.BadImageFormatException: Attempted to load a
> 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if
> trying to load for reflection purposes.
> Source Error:
> An unhandled exception was generated during the execution of the current
> web
> request. Information regarding the origin and location of the exception
> can
> be identified using the exception stack trace below.
> Here's the details:
> Reporting Services is running on the same server as SQL is, which has
> Windows 2003 Server Enterprise 64 bit. We're running SQL2005 Enterprise
> Edition 64 bit on this server. There were no problems when IIS was
> running
> on 64 bit, however, I had to change to allow 32 bit because of a legacy
> site
> that we have running on the server that needs to run ASP.NET v1.1.
> So I installed the .net framework 1.1, installed front page server
> extensions for 64 bit, enabled 32 bit on 64 using adsutil, and then I ran
> aspnet_regiis -s from the c:\windows\microsoft.net\framework\v2.0.xxxx. I
> then changed the legacy site to run v1.1.4322, but even still the
> reporting
> services sites are not working. One other site that runs under v2.0 is
> working.
> I'm guessing that this has something to do with security that has to be
> setup to allow credentials to be passed to the DC from this server, but
> I'm
> not sure where to start looking. Thanks for any help/suggestions.|||They were working when the 64 bit version of ASP.NET v2.0 was running. It
was when I enabled 32 bit on 64 bit for IIS that it gave me the error
messages.
When I run aspnet_regiis -lk, I get this for the reporting services websites:
W3SVC/1/ROOT/ReportAdmin/ 2.0.50727.1433
W3SVC/1/ROOT/Reports/ 2.0.50727.1433
"Bruce L-C [MVP]" wrote:
> Did you ever have it working?
> Check out the two reporting services websites and make sure both are using
> the 2.0 framework.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message
> news:95ED2E52-C7A6-4C5B-ABF6-977B80875898@.microsoft.com...
> > Here's a summary of my problem before I get into the details:
> > the reporting services site that runs reports is asking for credentials,
> > which I give, but then brings me to a page that says "You are not
> > authorized
> > to view this page." When I browse to the admin page for reporting
> > services,
> > it gives me this info:
> >
> > Server Error in '/ReportAdmin' Application.
> > ----
> > Attempted to load a 64-bit assembly on a 32-bit platform. Use
> > ReflectionOnlyLoad() instead if trying to load for reflection purposes.
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information
> > about
> > the error and where it originated in the code.
> >
> > Exception Details: System.BadImageFormatException: Attempted to load a
> > 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if
> > trying to load for reflection purposes.
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current
> > web
> > request. Information regarding the origin and location of the exception
> > can
> > be identified using the exception stack trace below.
> >
> > Here's the details:
> > Reporting Services is running on the same server as SQL is, which has
> > Windows 2003 Server Enterprise 64 bit. We're running SQL2005 Enterprise
> > Edition 64 bit on this server. There were no problems when IIS was
> > running
> > on 64 bit, however, I had to change to allow 32 bit because of a legacy
> > site
> > that we have running on the server that needs to run ASP.NET v1.1.
> > So I installed the .net framework 1.1, installed front page server
> > extensions for 64 bit, enabled 32 bit on 64 using adsutil, and then I ran
> > aspnet_regiis -s from the c:\windows\microsoft.net\framework\v2.0.xxxx. I
> > then changed the legacy site to run v1.1.4322, but even still the
> > reporting
> > services sites are not working. One other site that runs under v2.0 is
> > working.
> >
> > I'm guessing that this has something to do with security that has to be
> > setup to allow credentials to be passed to the DC from this server, but
> > I'm
> > not sure where to start looking. Thanks for any help/suggestions.
>
>|||I know you can have both 1.1 and 2.0 framework running at the same time.
However, what is happening now is all of IIS is running in 32 bit mode and
yet you are trying to run 64 bit RS (RS is just an asp.net application). My
guess is that you have to uninstall RS and then install it as a 32 bit
program.
In RS 2008 it will no longer be dependent on IIS so this sort of issue will
go away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message
news:A9472B8E-20D5-4808-A196-71B94A7A784C@.microsoft.com...
> They were working when the 64 bit version of ASP.NET v2.0 was running. It
> was when I enabled 32 bit on 64 bit for IIS that it gave me the error
> messages.
> When I run aspnet_regiis -lk, I get this for the reporting services
> websites:
> W3SVC/1/ROOT/ReportAdmin/ 2.0.50727.1433
> W3SVC/1/ROOT/Reports/ 2.0.50727.1433
>
> "Bruce L-C [MVP]" wrote:
>> Did you ever have it working?
>> Check out the two reporting services websites and make sure both are
>> using
>> the 2.0 framework.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message
>> news:95ED2E52-C7A6-4C5B-ABF6-977B80875898@.microsoft.com...
>> > Here's a summary of my problem before I get into the details:
>> > the reporting services site that runs reports is asking for
>> > credentials,
>> > which I give, but then brings me to a page that says "You are not
>> > authorized
>> > to view this page." When I browse to the admin page for reporting
>> > services,
>> > it gives me this info:
>> >
>> > Server Error in '/ReportAdmin' Application.
>> > ----
>> > Attempted to load a 64-bit assembly on a 32-bit platform. Use
>> > ReflectionOnlyLoad() instead if trying to load for reflection purposes.
>> > Description: An unhandled exception occurred during the execution of
>> > the
>> > current web request. Please review the stack trace for more information
>> > about
>> > the error and where it originated in the code.
>> >
>> > Exception Details: System.BadImageFormatException: Attempted to load a
>> > 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead
>> > if
>> > trying to load for reflection purposes.
>> >
>> > Source Error:
>> > An unhandled exception was generated during the execution of the
>> > current
>> > web
>> > request. Information regarding the origin and location of the exception
>> > can
>> > be identified using the exception stack trace below.
>> >
>> > Here's the details:
>> > Reporting Services is running on the same server as SQL is, which has
>> > Windows 2003 Server Enterprise 64 bit. We're running SQL2005
>> > Enterprise
>> > Edition 64 bit on this server. There were no problems when IIS was
>> > running
>> > on 64 bit, however, I had to change to allow 32 bit because of a legacy
>> > site
>> > that we have running on the server that needs to run ASP.NET v1.1.
>> > So I installed the .net framework 1.1, installed front page server
>> > extensions for 64 bit, enabled 32 bit on 64 using adsutil, and then I
>> > ran
>> > aspnet_regiis -s from the c:\windows\microsoft.net\framework\v2.0.xxxx.
>> > I
>> > then changed the legacy site to run v1.1.4322, but even still the
>> > reporting
>> > services sites are not working. One other site that runs under v2.0 is
>> > working.
>> >
>> > I'm guessing that this has something to do with security that has to be
>> > setup to allow credentials to be passed to the DC from this server, but
>> > I'm
>> > not sure where to start looking. Thanks for any help/suggestions.
>>|||Well that's too bad. Oh well-I'll reinstall RS then.
Thanks for your help.
"Bruce L-C [MVP]" wrote:
> I know you can have both 1.1 and 2.0 framework running at the same time.
> However, what is happening now is all of IIS is running in 32 bit mode and
> yet you are trying to run 64 bit RS (RS is just an asp.net application). My
> guess is that you have to uninstall RS and then install it as a 32 bit
> program.
> In RS 2008 it will no longer be dependent on IIS so this sort of issue will
> go away.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message
> news:A9472B8E-20D5-4808-A196-71B94A7A784C@.microsoft.com...
> > They were working when the 64 bit version of ASP.NET v2.0 was running. It
> > was when I enabled 32 bit on 64 bit for IIS that it gave me the error
> > messages.
> >
> > When I run aspnet_regiis -lk, I get this for the reporting services
> > websites:
> >
> > W3SVC/1/ROOT/ReportAdmin/ 2.0.50727.1433
> > W3SVC/1/ROOT/Reports/ 2.0.50727.1433
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Did you ever have it working?
> >>
> >> Check out the two reporting services websites and make sure both are
> >> using
> >> the 2.0 framework.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message
> >> news:95ED2E52-C7A6-4C5B-ABF6-977B80875898@.microsoft.com...
> >> > Here's a summary of my problem before I get into the details:
> >> > the reporting services site that runs reports is asking for
> >> > credentials,
> >> > which I give, but then brings me to a page that says "You are not
> >> > authorized
> >> > to view this page." When I browse to the admin page for reporting
> >> > services,
> >> > it gives me this info:
> >> >
> >> > Server Error in '/ReportAdmin' Application.
> >> > ----
> >> > Attempted to load a 64-bit assembly on a 32-bit platform. Use
> >> > ReflectionOnlyLoad() instead if trying to load for reflection purposes.
> >> > Description: An unhandled exception occurred during the execution of
> >> > the
> >> > current web request. Please review the stack trace for more information
> >> > about
> >> > the error and where it originated in the code.
> >> >
> >> > Exception Details: System.BadImageFormatException: Attempted to load a
> >> > 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead
> >> > if
> >> > trying to load for reflection purposes.
> >> >
> >> > Source Error:
> >> > An unhandled exception was generated during the execution of the
> >> > current
> >> > web
> >> > request. Information regarding the origin and location of the exception
> >> > can
> >> > be identified using the exception stack trace below.
> >> >
> >> > Here's the details:
> >> > Reporting Services is running on the same server as SQL is, which has
> >> > Windows 2003 Server Enterprise 64 bit. We're running SQL2005
> >> > Enterprise
> >> > Edition 64 bit on this server. There were no problems when IIS was
> >> > running
> >> > on 64 bit, however, I had to change to allow 32 bit because of a legacy
> >> > site
> >> > that we have running on the server that needs to run ASP.NET v1.1.
> >> > So I installed the .net framework 1.1, installed front page server
> >> > extensions for 64 bit, enabled 32 bit on 64 using adsutil, and then I
> >> > ran
> >> > aspnet_regiis -s from the c:\windows\microsoft.net\framework\v2.0.xxxx.
> >> > I
> >> > then changed the legacy site to run v1.1.4322, but even still the
> >> > reporting
> >> > services sites are not working. One other site that runs under v2.0 is
> >> > working.
> >> >
> >> > I'm guessing that this has something to do with security that has to be
> >> > setup to allow credentials to be passed to the DC from this server, but
> >> > I'm
> >> > not sure where to start looking. Thanks for any help/suggestions.
> >>
> >>
> >>
>
>

Reporting Services Setup Issue

Hi All,

I am running setup.exe (RS 2000 Enterprise), and ra issue during the following step -

"specify credentials that are used at run time by ReportServer service to connect ot SQL Server Instance..."

My local SQL Server is running under "Local System" account, and I have SQL Server 2000 SP4 installed on Windows Server 2003.

Any help to resolve this setup issue is much appreciated!

-Lawrence

you trying setup RS 2000 Developer

because you using Server Operation System

end which page erroring

|||You need to provide credentials that Report Server services will use in order to access the catalog at run-time. You can choose to have the services impersonate their associated accounts, or you can specify separate Windows or SQL credentials. If you specify separate credentials, these credentials will be stored (encrypted) on the server config file.|||

I specified Windows & SQL credentials, but they both failed with the error message I mentioned. I am able to login to SQL Server with those account, so I am not sure why RS installation is rejecting them. Any ideas why?

-Lawrence

|||

Hello All,

I'm still encountering errors during install of RS 2000 on Windows Server 2003. Error message is in regards to operating system not match up with RS 2000 requirement. I thought RS 2000 can be installed on Windows Server 2003, but MS could be wrong. Let me know if any of you have a workaround.

Thanks,

-Lawrence

Reporting Services Setup Issue

Hi All,

I am running setup.exe (RS 2000 Enterprise), and ra issue during the following step -

"specify credentials that are used at run time by ReportServer service to connect ot SQL Server Instance..."

My local SQL Server is running under "Local System" account, and I have SQL Server 2000 SP4 installed on Windows Server 2003.

Any help to resolve this setup issue is much appreciated!

-Lawrence

you trying setup RS 2000 Developer

because you using Server Operation System

end which page erroring

|||You need to provide credentials that Report Server services will use in order to access the catalog at run-time. You can choose to have the services impersonate their associated accounts, or you can specify separate Windows or SQL credentials. If you specify separate credentials, these credentials will be stored (encrypted) on the server config file.|||

I specified Windows & SQL credentials, but they both failed with the error message I mentioned. I am able to login to SQL Server with those account, so I am not sure why RS installation is rejecting them. Any ideas why?

-Lawrence

|||

Hello All,

I'm still encountering errors during install of RS 2000 on Windows Server 2003. Error message is in regards to operating system not match up with RS 2000 requirement. I thought RS 2000 can be installed on Windows Server 2003, but MS could be wrong. Let me know if any of you have a workaround.

Thanks,

-Lawrence

sql

Reporting Services is loosing stores credentials during connecting to Analysis Services

Hi, experts.
I have another strange problem with Reporting Services.
There are two machines:
-machine A with ReportingServices +IIS but without SQL SERVER nor
Analysis Services
-machine B with SQL Server and Reporting Services.
There is a web application in the machine A that collects data that
the web user
sends to the web server in order to pass it as parameters to Reporting
Services using a POST method. This POST method is sent from the
browsers (the web server
generates a form with hidden fields that are automatically sent to
Reporting Services by means of JavaScript).
Stored credentials are used in the datasource configuration and I've
put
all Services Packs that are available.
When the user wants to see the report for the first time, everything
works smoothly. Once it returns to the main page in order to visualize
other report or the same report once again, it is not possible to
connect to Reporting Services due to the security issues (dimension
not found error is obtained).
If I close the web browser and open it again, I can seee one report
and then
I obtain the same error.
I think that stored credentials are lost, but I have no idea how I can
fix it.
Thank you in advance for any ideas
Maciej Kiewrahmm...Are both your RS servers set up for Win Auth?
Depending on how your domain is configured, Windows credentials can be
passed across one computer connection before they expire. A user connection
to a report server counts as the first connection. If the user opens a
report that retrieves data from a remote server, that login counts as a
second connection and will fail if you are using Windows Authentication and
Kerberos is not enabled.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
--
Adrian M.
MCP
"Maciej Kiewra" <mkiewra@.mail.fujitsu.es> wrote in message
news:bc86bf57.0502221051.459d8e69@.posting.google.com...
> Hi, experts.
> I have another strange problem with Reporting Services.
> There are two machines:
> -machine A with ReportingServices +IIS but without SQL SERVER nor
> Analysis Services
> -machine B with SQL Server and Reporting Services.
>
> There is a web application in the machine A that collects data that
> the web user
> sends to the web server in order to pass it as parameters to Reporting
> Services using a POST method. This POST method is sent from the
> browsers (the web server
> generates a form with hidden fields that are automatically sent to
> Reporting Services by means of JavaScript).
> Stored credentials are used in the datasource configuration and I've
> put
> all Services Packs that are available.
> When the user wants to see the report for the first time, everything
> works smoothly. Once it returns to the main page in order to visualize
> other report or the same report once again, it is not possible to
> connect to Reporting Services due to the security issues (dimension
> not found error is obtained).
> If I close the web browser and open it again, I can seee one report
> and then
> I obtain the same error.
>
> I think that stored credentials are lost, but I have no idea how I can
> fix it.
> Thank you in advance for any ideas
> Maciej Kiewra|||Hi, experts
I´ve solved it. The problem was related with the user that
executed the web application ReportServer (IWAM anonymous access).
I´ve put a user that has access to Analysis Services in the anonymous
access option and now
everything works fine.
Regards
Maciej Kiewra
mkiewra@.mail.fujitsu.es (Maciej Kiewra) wrote in message news:<bc86bf57.0502221051.459d8e69@.posting.google.com>...
> Hi, experts.
> I have another strange problem with Reporting Services.
> There are two machines:
> -machine A with ReportingServices +IIS but without SQL SERVER nor
> Analysis Services
> -machine B with SQL Server and Reporting Services.
>
> There is a web application in the machine A that collects data that
> the web user
> sends to the web server in order to pass it as parameters to Reporting
> Services using a POST method. This POST method is sent from the
> browsers (the web server
> generates a form with hidden fields that are automatically sent to
> Reporting Services by means of JavaScript).
> Stored credentials are used in the datasource configuration and I've
> put
> all Services Packs that are available.
> When the user wants to see the report for the first time, everything
> works smoothly. Once it returns to the main page in order to visualize
> other report or the same report once again, it is not possible to
> connect to Reporting Services due to the security issues (dimension
> not found error is obtained).
> If I close the web browser and open it again, I can seee one report
> and then
> I obtain the same error.
>
> I think that stored credentials are lost, but I have no idea how I can
> fix it.
> Thank you in advance for any ideas
> Maciej Kiewra

Reporting Services Errors

One or more datasource credentials required to run the report have not been
specified. (rsCredentialsNotSpecified)
When I run a report through our Report Server I npw get the above error. I
cannot find any help files on this error through MSDN or Microsoft.
I ran RSKeyMgmt trying to resolve another issue, any help would be greatly
appreciated.If you ran RSKeyMgmt and deleted encrypted content, you may have deleted
the stored credentials for your report.
Check the report data source properties and make sure they are set
appropriately.
--
| Thread-Topic: Reporting Services Errors
| thread-index: AcVwK9IkFDn5aIhfTdivKQFhEtVjvw==| X-WBNR-Posting-Host: 204.87.106.66
| From: "=?Utf-8?B?V2lsZGxpZmU=?=" <Wildlife@.discussions.microsoft.com>
| Subject: Reporting Services Errors
| Date: Mon, 13 Jun 2005 08:23:16 -0700
| Lines: 8
| Message-ID: <CB0471BF-57FE-481D-A917-B265A4ADB010@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45817
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| One or more datasource credentials required to run the report have not
been
| specified. (rsCredentialsNotSpecified)
|
| When I run a report through our Report Server I npw get the above error.
I
| cannot find any help files on this error through MSDN or Microsoft.
|
| I ran RSKeyMgmt trying to resolve another issue, any help would be
greatly
| appreciated.
|