Wednesday, March 28, 2012
Report vs software
I'm new in this issue of reporting.
Can some one tell me if is it necessary the installation of Visual Studio
.NET in the PC of a end user so he can exctract dinamic reports?
Besta Regars
ThanksA web navigator would be enough !
"Zurga" <Zurga@.discussions.microsoft.com> a écrit dans le message de news:
F36D4C94-FD59-4B25-B29A-9637B89DB1AA@.microsoft.com...
> Hello,
> I'm new in this issue of reporting.
> Can some one tell me if is it necessary the installation of Visual Studio
> .NET in the PC of a end user so he can exctract dinamic reports?
> Besta Regars
> Thanks
>|||You need to install Visual Studio to perform report design but an end user
would normally only need a web browser (internet explorer) to view, print
and export report data.
Good luck!
Dan
"Zurga" <Zurga@.discussions.microsoft.com> wrote in message
news:F36D4C94-FD59-4B25-B29A-9637B89DB1AA@.microsoft.com...
> Hello,
> I'm new in this issue of reporting.
> Can some one tell me if is it necessary the installation of Visual Studio
> .NET in the PC of a end user so he can exctract dinamic reports?
> Besta Regars
> Thanks
>
Monday, March 12, 2012
Report Services installation problem
I apologize - I didn't offer full details. I was frustrated!
Clicking "Apply" on the "Web Service Identity" dialogue results in an error. Clicking the link for details reveals this:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The ASPNET user does exist however! I don't understand what's wrong. Thanks for your help.
|||Not sure what's going on. It's seeme like there is something wrong with the ASPNET account. Is ReportServer vroot in IIS running under asp.net 2.0. Are any other web applications on that machine working OK?
|||That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb. This machine is dedicated to running SQL Server Express, so no other applications are running that I can test for web connectivity. Any direction you can point me in is greatly appreciated! Thanks again for your help.|||1. Open up Internet Information Services applet in the Administrators group.
2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's the ASP.NET version?
|||The ASP.NET version is 2.0.50727. Thanks for helping me through this!report services installation problem
Hello, i am having a installation problem that is giving this error:
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
the sql server 2005 only installed after i disabled report services from setup.
any ideas about solving this problem?
Hi,
When installing Reporting Services 2005, you can do an "install only" (not configure). Doing so, the installation process will just copy the needed files but not trying to configure accounts and the rest of stuff. Once the installation is done, you may revert to the Reporting Services Configuration Tool to configure items one at a time, and trying to understand or debug what is going on...
Hope this helps
Jordi Rambla
MVP SQL Server
SolidQualityLearning
Hi ,
I am Also getting same problem while installing SQLServer 2005 on my machine.
I came to notice that SQLServer 2005 will install .Net Framework2.0 will automatically and we need to uninstall Framework 2.0 manually if We have already.So,I have already Net Framework2.0 on my machine.But i am using Framework in my WPF application and project is in ending position.So now i can't uninstall ramework2.0.What i have to do.
Please Help me...
Thanks,
B.Krishna chaitanya.
Report Services installation problem
I apologize - I didn't offer full details. I was frustrated!
Clicking "Apply" on the "Web Service Identity" dialogue results in an error. Clicking the link for details reveals this:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The ASPNET user does exist however! I don't understand what's wrong. Thanks for your help.
|||Not sure what's going on. It's seeme like there is something wrong with the ASPNET account. Is ReportServer vroot in IIS running under asp.net 2.0. Are any other web applications on that machine working OK?
|||That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb. This machine is dedicated to running SQL Server Express, so no other applications are running that I can test for web connectivity. Any direction you can point me in is greatly appreciated! Thanks again for your help.|||1. Open up Internet Information Services applet in the Administrators group.
2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's the ASP.NET version?
|||The ASP.NET version is 2.0.50727. Thanks for helping me through this!Wednesday, March 7, 2012
Report server not inizialized after installation
I have an install script that installs all of the services and features with the exception of management studio express. My install script is very basic, the only addition was to have RSSQLOCAL=1, and I set RSCONFIGURATION=Default.
After the installation, when I navigate to localhost\Reports$SQLEXPRESS or localhost\ReportServer$SQLEXPRESS, I get an authentication error. When I go into the reporting services configuration manager, everything looks OK, but the 'Initialized' status is 'NO' under status. If I go to 'Database Setup', choose Connect, and then 'Apply', the reporting services now becomes initialized, and everything seems to be OK.
What is the reason for this manual step in the reporting configuration manager? Any ideas?
I don't know why that happens either. A bit of a mystery...but trust me, if that is the only problem you had installing....... You're Lucky.|||Hmmm,
Thanks for the reply.
Sounds like installation can be a huge headache for SSRS. Has anyone compiled a page with install issues and resolutions for SSRS?
|||According to this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838483&SiteID=1
You simply have to restart the PC for it to be initialized.
|||
ajhuddy wrote:
Hmmm,
Has anyone compiled a page with install issues and resolutions for SSRS?
Yes, a good portion of these forums.
Report Server Installation Issue
I followed the article, here is the error I am still recieving:
Server Error in '/REPORTSERVER' Application.
----
Security Exception
Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Web.AspNetHostingPermission, System,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
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.
Stack Trace:
[SecurityException: Request for the permission of type
System.Web.AspNetHostingPermission, System, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.]
System.Type.GetType(String typeName, Boolean throwOnError) +0
System.Web.Configuration.HandlerBase.GetAndRemoveTypeAttributeInternal(XmlNode node, String attrib, Boolean fRequired, Type& val) +52
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Thanks
Eric
"Cooper" wrote:
> Try this for your error
> http://support.microsoft.com/kb/887787
>
>
>
> "ejswanson" wrote:
>
> > I need to install the sql server report service on 2 web sites on the same
> > server. The urls are www.xxxx.us and test.xxxx.us. How do I go about doing
> > this?
> >
> > I successfully installed the report service on the default web site of this
> > server, but normally it is not started. I copied the virtual directories
> > from the default site to my other sites, but I am now getting the following
> > error message:
> >
> > Security Exception
> > Description: The application attempted to perform an operation not allowed
> > by the security policy. To grant this application the required permission
> > please contact your system administrator or change the application's trust
> > level in the configuration file.
> >
> > Exception Details: System.Security.SecurityException: Request for the
> > permission of type System.Web.AspNetHostingPermission, System,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> >
> > 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.
> >
> > Stack Trace:
> >
> >
> > [SecurityException: Request for the permission of type
> > System.Web.AspNetHostingPermission, System, Version=1.0.5000.0,
> > Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.]
> > System.Type.GetType(String typeName, Boolean throwOnError) +0
> >
> > System.Web.Configuration.HandlerBase.GetAndRemoveTypeAttributeInternal(XmlNode node, String attrib, Boolean fRequired, Type& val) +52
> >
> >
> >
> > Both of these web sites already are running asp.net applications. How do I
> > resolve this issue on the websites that are not the default web site?
> >
> > If I have a test site and a production site, how do I move the reports
> > between the sites? Is the database connection site specfic?
> >
> > Thanks
> >
> > Eric
> >
> >
> >
Expand AllCollapse AllHi ejswanson,
From your descriptions, I understood that you followed KB article Q887787
but it still report the error message "The application attempted to perform
an operation not allowed by the security policy." If I have misunderstood
your concern, please feel free to point it out.
First of all, I would like to double confirm that you have download .config
files from KB article Q887787
http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
01CE0/887787.exe
and you have replaced your current .config files with the .config files
from the package as KB described and restart machine finally.
Secondly, are you logon the system with the privilege as local
administrator? More detailed information, I beileve, will make us closer to
the resolution.
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I did download the patch and installed it on the machine. I also rebooted
the machine a number of times.
Yes, I am logged on as local administrator.
Do I need to make sure that the reporting service is logged on as a local
administrator?
The particular web site that I am attempting to get reporting services
running also has another asp.net web application running in it. Would this
cause this issue? Please send me any other questions or other files that you
need in order to determine the resolution.
Thanks
Eric
"Michael Cheng [MSFT]" wrote:
> Hi ejswanson,
> From your descriptions, I understood that you followed KB article Q887787
> but it still report the error message "The application attempted to perform
> an operation not allowed by the security policy." If I have misunderstood
> your concern, please feel free to point it out.
> First of all, I would like to double confirm that you have download .config
> files from KB article Q887787
> http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
> 01CE0/887787.exe
> and you have replaced your current .config files with the .config files
> from the package as KB described and restart machine finally.
> Secondly, are you logon the system with the privilege as local
> administrator? More detailed information, I beileve, will make us closer to
> the resolution.
> If you have any questions or concerns, don't hesitate to let me know. We
> are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Eric,
A long shot. The other ASP.NET application isn't running on ASP.NET
2.0 is it?
I had a similar problem when trying (in a test situation) to run an
ASP.NET 2.0 app (RS2005) alongside an ASP.NET 1.1 app.
Andrew Watt
MVP - InfoPath
On Thu, 7 Apr 2005 04:23:02 -0700, ejswanson
<ejswanson1@.community.nospam> wrote:
>Hi Michael,
>I did download the patch and installed it on the machine. I also rebooted
>the machine a number of times.
>Yes, I am logged on as local administrator.
>Do I need to make sure that the reporting service is logged on as a local
>administrator?
>The particular web site that I am attempting to get reporting services
>running also has another asp.net web application running in it. Would this
>cause this issue? Please send me any other questions or other files that you
>need in order to determine the resolution.
>Thanks
>Eric
>"Michael Cheng [MSFT]" wrote:
>> Hi ejswanson,
>> From your descriptions, I understood that you followed KB article Q887787
>> but it still report the error message "The application attempted to perform
>> an operation not allowed by the security policy." If I have misunderstood
>> your concern, please feel free to point it out.
>> First of all, I would like to double confirm that you have download .config
>> files from KB article Q887787
>> http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
>> 01CE0/887787.exe
>> and you have replaced your current .config files with the .config files
>> from the package as KB described and restart machine finally.
>> Secondly, are you logon the system with the privilege as local
>> administrator? More detailed information, I beileve, will make us closer to
>> the resolution.
>> If you have any questions or concerns, don't hesitate to let me know. We
>> are always here to be of assistance!
>>
>> Sincerely yours,
>> Michael Cheng
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no rights.
>>|||Unfortunately not. Both sites are asp.net 1.1.
Thanks
Eric
"Andrew Watt [MVP - InfoPath]" wrote:
> Eric,
> A long shot. The other ASP.NET application isn't running on ASP.NET
> 2.0 is it?
> I had a similar problem when trying (in a test situation) to run an
> ASP.NET 2.0 app (RS2005) alongside an ASP.NET 1.1 app.
> Andrew Watt
> MVP - InfoPath
> On Thu, 7 Apr 2005 04:23:02 -0700, ejswanson
> <ejswanson1@.community.nospam> wrote:
> >Hi Michael,
> >
> >I did download the patch and installed it on the machine. I also rebooted
> >the machine a number of times.
> >
> >Yes, I am logged on as local administrator.
> >
> >Do I need to make sure that the reporting service is logged on as a local
> >administrator?
> >
> >The particular web site that I am attempting to get reporting services
> >running also has another asp.net web application running in it. Would this
> >cause this issue? Please send me any other questions or other files that you
> >need in order to determine the resolution.
> >
> >Thanks
> >
> >Eric
> >
> >"Michael Cheng [MSFT]" wrote:
> >
> >> Hi ejswanson,
> >>
> >> From your descriptions, I understood that you followed KB article Q887787
> >> but it still report the error message "The application attempted to perform
> >> an operation not allowed by the security policy." If I have misunderstood
> >> your concern, please feel free to point it out.
> >>
> >> First of all, I would like to double confirm that you have download .config
> >> files from KB article Q887787
> >> http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
> >> 01CE0/887787.exe
> >>
> >> and you have replaced your current .config files with the .config files
> >> from the package as KB described and restart machine finally.
> >>
> >> Secondly, are you logon the system with the privilege as local
> >> administrator? More detailed information, I beileve, will make us closer to
> >> the resolution.
> >>
> >> If you have any questions or concerns, don't hesitate to let me know. We
> >> are always here to be of assistance!
> >>
> >>
> >> Sincerely yours,
> >>
> >> Michael Cheng
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >> =====================================================> >>
> >> This posting is provided "AS IS" with no warranties, and confers no rights.
> >>
> >>
>|||Hi Eric,
It seems strange so that please collect the following information in a
zipped file and send to me direcly v-mingqc@.online.microsoft.com (please
remove 'online' as it is only for SPAM)
1. Send me these two configuration files
%ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rssrvpolicy.config
%ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\rsmgrpolicy.config
2. Send me Reporting Services Error Logs
Additionally, please let me know whether Reporting Services works fine
before or it fails with this error message right after the installation?
Last but not the least, please understand that this issue might tend to be
very complex and hard to troubleshoot in newsgroups. If you need further
assistance, I recommend that you open a Support incident with Microsoft
Customer Service and Support (CSS) so that a dedicated Support Professional
can work with you in a more timely and efficient manner. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks, I will call ms support.
"Michael Cheng [MSFT]" wrote:
> Hi Eric,
> It seems strange so that please collect the following information in a
> zipped file and send to me direcly v-mingqc@.online.microsoft.com (please
> remove 'online' as it is only for SPAM)
> 1. Send me these two configuration files
> %ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\rssrvpolicy.config
> %ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\rsmgrpolicy.config
> 2. Send me Reporting Services Error Logs
> Additionally, please let me know whether Reporting Services works fine
> before or it fails with this error message right after the installation?
> Last but not the least, please understand that this issue might tend to be
> very complex and hard to troubleshoot in newsgroups. If you need further
> assistance, I recommend that you open a Support incident with Microsoft
> Customer Service and Support (CSS) so that a dedicated Support Professional
> can work with you in a more timely and efficient manner. If you need any
> help in this regard, please let me know.
> For a complete list of Microsoft Customer Service and Support phone
> numbers, please go to the following address on the World Wide Web:
> <http://support.microsoft.com/directory/overview.asp>
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Eric,
Thanks for your understanding and cooperation, If you have any questions or
concerns on SQL Server next time, don't hesitate to let me know. We are
always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Report Server installation is not initialized / Can not activate
After the installation of Reporting Services i received the following error:
The report server installation is not initialized.
First i just continued with the installation of the Service Packs and after
that I tried to activate it with rsactivate, but this didn't work because of
an other error.
rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t
Result:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
--> System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
System:
Win2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
I'd appreciate help from Microsoft staff on this topic!
I did everything that came to my mind to fix this:
- reg_iis -i
- MDAC reinstalled
- rskeymgmt -d:
--> Result: Unexpected database error (-2147159548) 0x80040154
- deletet encryption keys manually (in the ReportServer database)
ReportServerLog:
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Initializing crypto as
user: CUSER\reportuser
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Exporting public key
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: w WARN: Web Service not activated
aspnet_wp!crypto!c2c!11/23/2005-10:11:06:: i INFO: Client is a local admin.
Activating web service via RPC.
aspnet_wp!library!c2c!11/23/2005-10:11:06:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159548 --> System.Exception: 0x80040154
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
aspnet_wp!webserver!c2c!11/23/2005-10:11:08:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159548 --> System.Exception: 0x80040154
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Initializing crypto as
user: CUSER\reportuser
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Exporting public key
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: w WARN: Web Service not activated
aspnet_wp!crypto!c8c!11/23/2005-10:12:06:: i INFO: Client is not a local
admin. Not attempting activation.
This user is a local admin, so why do I get these errors?
What can i do to activate Reporting Services? Are there some things a can
change manually in the database?
Thx for any help
YaraIt was the MDAC.
The automatic installation of MDAC failed all the time without
prompting an error message, that's why I didn't notice it.
I had to manually check every dll and overwrite older versions. Then
reregister it.
Hope this will help other users.