Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 22nd, 2004, 01:02 PM
Authorized User
 
Join Date: Jun 2004
Location: Peterborough, Ontario, Canada.
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default Reporting Service Install Issues

I have installed reporting services successfully on my desktop computer (XP with Visual Studio et al).

Now that I am into Chapter 8 and we are going to get into scripting to move files to remote servers etc. I decided it was time to install on our Development server:

Windows 2000 Server, SP4
SQL Server Developer Edition (SP3)
IIS 5

The install had an error: Setup could not initialize error, which said to
manually initialize according to the BOL.

I went to BOL to find out how to do this and found only one article:
Troubleshooting an Installation of Reporting Services relating to the issue.

I have stepped through this:

1) The service is running
2) ASP.NET 1.1.4322 is registered with IIS
3) It passes all of the tests in the document.

When I go to http://127.0.0.1/reports/ I get a windows password box (as I
should) and log in as the Administrator. I get this message:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError)

So I go to the log:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

(Note the entire log is below)

These lines seem to indicate the error:
aspnet_wp!crypto!880!06/22/2004-11:20:25:: i INFO: Exporting public key
aspnet_wp!library!880!06/22/2004-11:20:23:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
 Info:
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. ---> System.IO.FileNotFoundException: The system cannot find the
file specified.


I have NO IDEA what the file specified is, since it does not seem to be
specified. Further more, I am in the error log, why am I being told to see
the error log for more details?

I have checked the event viewer system, Application and Security Logs and
there are no entries pertaining to the ASP.Net user, the application, the
IUSR_Machine user or anything that points to this application (in fact the
only real errors are from Norton Anti-virus trying to scan backup files).

Does anyone have any idea how to diagnose this???

<Header>
  <Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Eastern Daylight Time</TimeZone>
  <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__06_22_2004_11_20_2 1.log</Path>
  <SystemName>SMART2</SystemName>
  <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
  <OSVersion>5.0.2195.0</OSVersion>
</Header>
aspnet_wp!webserver!880!6/22/2004-11:20:21:: i INFO: Reporting Web Server
started
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing MemoryLimit
to '60' percent as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing RecycleTime
to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing InstanceName
to 'MSSQLSERVER' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!880!6/22/2004-11:20:21:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!resourceutilities!880!6/22/2004-11:20:21:: i INFO: Running on 1
physical processors, 1 logical processors
aspnet_wp!resourceutilities!880!6/22/2004-11:20:21:: i INFO: Reporting
Services starting SKU: Evaluation
aspnet_wp!resourceutilities!880!6/22/2004-11:20:21:: i INFO: Eval SKU: 120
days left
aspnet_wp!runningjobs!880!6/22/2004-11:20:21:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
aspnet_wp!runningjobs!880!6/22/2004-11:20:21:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!880!6/22/2004-11:20:21:: i INFO: Running Requests DB
timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!880!6/22/2004-11:20:21:: i INFO: Memory stats update
timer enabled: Cycle: 60 seconds
aspnet_wp!library!880!06/22/2004-11:20:23:: i INFO: Call to GetPermissions:/
aspnet_wp!crypto!880!06/22/2004-11:20:23:: i INFO: Initializing crypto as
user: SMART2\ASPNET
aspnet_wp!crypto!880!06/22/2004-11:20:23:: i INFO: Exporting public key
aspnet_wp!library!880!06/22/2004-11:20:23:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
 Info:
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. ---> System.IO.FileNotFoundException: The system cannot find the
file specified.
   at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
   at RSManagedCrypto.RSCrypto.ExportPublicKey()
   at
Microsoft.ReportingServices.Library.ConnectionMana ger.GetEncryptionKey()
   at Microsoft.ReportingServices.Library.ConnectionMana ger.ConnectStorage()
   at
Microsoft.ReportingServices.Library.ConnectionMana ger.VerifyConnection()
   at Microsoft.ReportingServices.Library.ConnectionMana ger.get_Connection()
   at Microsoft.ReportingServices.Library.Storage.get_Co nnection()
   at
Microsoft.ReportingServices.Library.Storage.NewSta ndardSqlCommand(String
storedProcedureName)
   at
Microsoft.ReportingServices.Library.DBInterface.Ge tOneConfigurationInfo(Stri
ng key)
   at
Microsoft.ReportingServices.Library.CachedSystemPr operties.GetSystemProperty
(String name)
   at Microsoft.ReportingServices.Library.CachedSystemPr operties.Get(String
name)
   at
Microsoft.ReportingServices.Library.CachedSystemPr operties.GetParameter(Stri
ng name)
   at Microsoft.ReportingServices.Library.RSService.get_ MyReportsEnabled()
   at Microsoft.ReportingServices.Library.RSService.Path ToInternal(String
source)
   at
Microsoft.ReportingServices.Diagnostics.CatalogIte mContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
   at
Microsoft.ReportingServices.Diagnostics.CatalogIte mContext.SetPath(String
path)
   at
Microsoft.ReportingServices.Diagnostics.CatalogIte mContext..ctor(IPathTransl
ator pathTranslator, String userSuppliedPath, String parameterName)
   at Microsoft.ReportingServices.Library.RSService.GetP ermissions(String
item, StringCollection& Operations)
   --- End of inner exception stack trace ---
aspnet_wp!library!880!06/22/2004-11:20:25:: i INFO: Call to
GetSystemPermissions
aspnet_wp!crypto!880!06/22/2004-11:20:25:: i INFO: Initializing crypto as
user: SMART2\ASPNET
aspnet_wp!crypto!880!06/22/2004-11:20:25:: i INFO: Exporting public key
aspnet_wp!library!880!06/22/2004-11:20:25:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
 Info:
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. ---> System.IO.FileNotFoundException: The system cannot find the
file specified.
   at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
   at RSManagedCrypto.RSCrypto.ExportPublicKey()
   at
Microsoft.ReportingServices.Library.ConnectionMana ger.GetEncryptionKey()
   at Microsoft.ReportingServices.Library.ConnectionMana ger.ConnectStorage()
   at
Microsoft.ReportingServices.Library.ConnectionMana ger.VerifyConnection()
   at Microsoft.ReportingServices.Library.ConnectionMana ger.get_Connection()
   at Microsoft.ReportingServices.Library.Storage.get_Co nnection()
   at
Microsoft.ReportingServices.Library.Storage.NewSta ndardSqlCommand(String
storedProcedureName)
   at Microsoft.ReportingServices.Library.Security.GetSy stemPermissions()
   at Microsoft.ReportingServices.Library.RSService.GetS ystemPermissions()
   --- End of inner exception stack trace ---
aspnet_wp!crypto!8a8!6/22/2004-11:21:21:: i INFO: Initializing crypto as
user: SMART2\ASPNET
aspnet_wp!crypto!8a8!6/22/2004-11:21:21:: i INFO: Exporting public key
aspnet_wp!library!8a8!6/22/2004-11:21:21:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error getting running jobs;
 Info:
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. ---> System.IO.FileNotFoundException: The system cannot find the
file specified.
   at System.Runtime.InteropServices.Marshal.ThrowExcept ionForHR(Int32
errorCode, IntPtr errorInfo)
   at RSManagedCrypto.RSCrypto.ExportPublicKey()
   at
Microsoft.ReportingServices.Library.ConnectionMana ger.GetEncryptionKey()
   at Microsoft.ReportingServices.Library.ConnectionMana ger.ConnectStorage()
   at
Microsoft.ReportingServices.Library.ConnectionMana ger.VerifyConnection()
   at Microsoft.ReportingServices.Library.ConnectionMana ger.get_Connection()
   ---- I cut it here because it is quite long ---

Sandy Murdock MCP
__________________
Sandy Murdock MCP
  #2 (permalink)  
Old June 22nd, 2004, 11:37 PM
Authorized User
 
Join Date: May 2004
Location: , , .
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This could actually be several things.

1) The default setup for XP doesn't allow users to authenticate as anything but guest. This can cause problems when working against a domain. If your machine is a domain member, you can forget this. If not, you may need to go to the local security policy console| Security Options | and change "Sharing and security model" to "classic". In any event, your credentials are not being passed as the logs indicate that it is trying to authenticate "SMART2\ASPNET".

2) Reporting server creates a cryptographic key that it uses to encrypt cached credentials that it uses for scheduling and such. If this got corrupted some how, you may have to create a new one and reconfigure the server. There is a great explantion of how to do this in BOL.

Hope this helps,

Todd Bryant

  #3 (permalink)  
Old June 22nd, 2004, 11:39 PM
Authorized User
 
Join Date: May 2004
Location: , , .
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This could actually be several things.

1) The default setup for XP doesn't allow users to authenticate as anything but guest. This can cause problems when working against a domain. If your machine is a domain member, you can forget this. If not, you may need to go to the local security policy console| Security Options | and change "Sharing and security model" to "classic". In any event, your credentials are not being passed as the logs indicate that it is trying to authenticate "SMART2\ASPNET".

2) Reporting server creates a cryptographic key that it uses to encrypt cached credentials that it uses for scheduling and such. If this got corrupted some how, you may have to create a new one and reconfigure the server. There is a great explanation of how to do this in BOL.

Hope this helps,

Todd Bryant

  #4 (permalink)  
Old June 23rd, 2004, 09:02 AM
Authorized User
 
Join Date: Jun 2004
Location: Peterborough, Ontario, Canada.
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think the issue is the encryption key. I tried a few things with no success so I have un-installed (again) and I am removing the database etc. and will try re-installing (again).

FYI: The XP install is the one that works, it is the Win2K Server that won't seem to work.

Sandy Murdock MCP
  #5 (permalink)  
Old June 23rd, 2004, 10:17 AM
Authorized User
 
Join Date: Jun 2004
Location: Peterborough, Ontario, Canada.
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have now successfully installed Reporting services on our Development SQL server.

I found that in trying to RUN reporting services there were no permissions errors, but in trying to install there were. I started out by adding permissions to directories as I found them in the logs but after successive install attempts this became a very frustrating game of chase the error.

In order to get around this I had to assign the ASPNet User account Administrator priviledges. After successfully installing I removed the ASPNet user from Administrator group and I can at least log into the report site. It tells me there are no reports (there aren't at this time) so it seems okay so far.

This machine has been locked down by using NTFS permissions as outlined by Microsoft:

For the web components:
http://support.microsoft.com/default...;en-us;Q271071
(Minimum NTFS Permissions Required for IIS 5.0 to work)

For .Net:
http://support.microsoft.com/default...Ben-us%3B11320
(Aspnet_wp.exe Could Not Be Started)

These two documents outline the permissions needed for IIS and ASP.net respectively. The purpose is to keep the machines as locked down as possible.

The production machines have the further issue (perhaps) of having only needed ports open on a per machine basis.

Since we cannot run the .Net user as an administrator, and it is obvious that to install SQL Reporting Services the account needs permissions beyond those needed to run asp.net pages, the question comes up: What parts of Reporting Services are not going to work with the documented permissions? (Now that I have reduced the ASPnet account again)

Is anyone aware of a similar document which outlines the permissions needed for SQL Server reporting services to work? The ASPNet account is NOT allowed to impersonate or have Admin rights so what permissions do I need to assign on what directories?

I have not succeeded in finding a document on Microsoft's site (using google, MS search is very poor) but that does not mean it isn't there.



Sandy Murdock MCP
  #6 (permalink)  
Old June 23rd, 2004, 10:43 AM
Authorized User
 
Join Date: May 2004
Location: , , .
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The XP install works when you view it on your local machine. Try to view the XP reporting site from another XP box, and You may see your problem duplicated.

If that works, you might look at the post

http://p2p.wrox.com/topic.asp?TOPIC_ID=13331

The last post has a good link to install issues with RS.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Service Issues Artfuldodger C++ Programming 1 July 19th, 2008 09:19 PM
Reporting Service gunjan.sh C# 2005 1 February 29th, 2008 12:09 PM
VS2008 (Formerly "Orcas") Install Issues robzyc C# 0 August 8th, 2007 05:33 AM
superscript in reporting service yaseen Crystal Reports 0 March 29th, 2007 02:12 AM
Reporting Services Install Issue bph Reporting Services 0 August 8th, 2006 01:44 PM



All times are GMT -4. The time now is 02:43 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.