Solved

SSRS 2005 post installation problems

Posted on 2008-10-30
15
718 Views
Last Modified: 2013-11-29
Hello,

I hope I provided enough info about my problem below...

I installed SSRS2005 on Windows Server 2003 R2 Stabdard x64 Edition with SP2 with IIS 6.0 and SQL Server 9.0.1399

- I can see SSRS working from VS2005 (I can run reports using Preview Tab in VS2005),

- I can see reports folder locally on url http://localhost/Reports/Pages/Folder.aspx

- if setup Authentication Access to Basic Authentication in IIS, I can see reports folder from another machine on our network on url http://dbtest/Reports/Pages/Folder.aspx

- windows service identity set to "local system" in SSRS Configurator (see ssrserr-win-serv-id.jpg on http://clip2net.com/page/m0/390524  )

- web service identity set to "nt authority/network service" (see ssrs-web-serv-id.jpg on http://clip2net.com/page/m0/390522  )

- all accounts, "local service", "network service" and ASPNET have permissions to access both SSRS folders (see ssrs-folder-permissions.jpg on http://clip2net.com/page/m0/390519  )

- I setup Sel/Upd/Ins/Del/Exe permissions for LocalSystem and for NT Authority\System for ReportServer DB and for NT Authority\Network Service and NT Authority\System for ReportServerTempDB

- in SSRS Configuration Mgr all the boxes on the left are ticket (only Encryption Keys has ! which should be OK)

Still I have three problems with security settings:

1) When I try to access Reports Folder from another computer using Windows Authentication I am getting error 401 in browser (see ssrs-401.jpg on http://clip2net.com/page/m0/390517  )

2) When I run report from Reports Folder locally I am getting connect error "unknown user name or bad password" even though  I think I am providing all needed authentication info

"      Logon failed.
"      Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

3) When I try to run my test report from browser even on local machine after setting datasource credentials to no credentials required I am getting ASP error (see ssrs-asp-err.jpg on http://clip2net.com/page/m0/390515   )


Below are all (I think) relevant logs:
ReportServer__10_29_2008_08_10_26.log:
ReportServerWebApp__10_29_2008_08_10_19.log
C:\WINDOWS\system32\LogFiles\W3SVC1\ex081029.log
Attached are
-      ssrs-3083.jpg (from Event viewer) on http://clip2net.com/page/m0/390511   and
-      ssrs-1309.jpg (from Event Viewer) on http://clip2net.com/page/m0/390509

Any idea what to look for or fix will be appreciated.

Thanks!
ReportServer--10-29-2008-08-10-2.doc
ReportServerWebApp--10-29-2008-0.doc
C-WINDOWS-system32-LogFiles-W3SV.doc
0
Comment
Question by:NaumLitvin
  • 7
  • 3
  • 2
15 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 22841385
From your SQL Server version number (9.0.1399) I can tell that you haven't installed any Service Packs.  I recommend to install SP2.  It's available here:http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

It fixes several issues with SSRS, could be that your problems are due to this.

Hope this helps.
0
 

Author Comment

by:NaumLitvin
ID: 22847416
Valentino, could you elaborate a bit, pls.  I downloaded the SP2 for x64, can I just install it or I need to backup all databases first? I do not plan to go back to pre-SP2 SQL Server...

Do I need to uninstall SSRS before applying SP2?

Thanks
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 22848556
Backing up your databases before applying a patch or SP is always my preferred approach.  The installation will do a rollback in case anything goes wrong, but it doesn't hurt to have a backup yourself, right?

There's no need to uninstall anything. SSRS is part of SQL Server so if you install SP2, SSRS will get upgraded as well.

I also recommend to read through the information on the download page, including the Readme (http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm).
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:NaumLitvin
ID: 22858512
I installed SP2, version is now correct (3042).

However, SSRS still does not work. I checked Configuration and now Web Service Identity is not setup. Help says to create Virtual Directory first, but it IS created, checked and kind of working (when Authentication set to Basic)...

see screen shot at http://clip2net.com/page/m0/395532

I restarted SQL Server and IIS,  registered ASP - does not help.

Another problem which I failed to mention before (or did not notice then) is that I do not see DataSources when I setup reports on the server. I do see them when I browse folders on server, but when I try to setup a datasource for a report I see the tree with nodes but not a single datasource (and I uploaded two)...

any ideas what to do or what tests to run?

I was thinking to reinstall SSRS but did not see how to uninstall it...

thanks

If I run a report


0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 22861061
Does the ASPNET user exist on your server?  I haven't seen this issue myself but have been searching the web a bit and in many cases it seems to have something to do with ASP.NET, either the account or some other issue.

If that's not the problem then the explanation through the following link may have a solution for you: http://developmentnow.com/g/115_2007_8_0_0_1008242/Web-Service-Identiy-is-red-in-report-configuration-tool.htm
0
 

Author Comment

by:NaumLitvin
ID: 22892494
Finally got to test the problem and so far no luck.

Yes, user ASPNET exists and has permissions to both Virt Dirs. I went through that exercise with recreating both Virt Dirs and now I have all buttons checked in SSRS Configurator, including Web Identity. Still I am getting Login Failed error on local machine and have to lower Autherntication to from Windows Identity to Basic to be able to access the Reports folder from another computer on the network...

Please, more ideas...

Thanks
Below is fresh snapshot from SSRS log...

w3wp!library!7!11/05/2008-23:58:48:: i INFO: Call to RenderFirst( '/test/Report2' )
w3wp!library!7!11/05/2008-23:58:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---
w3wp!webserver!7!11/05/2008-23:58:48:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext..ctor(CredentialsType credType, Guid dataSourceId, String userName, String password, String domain)
   at Microsoft.ReportingServices.Library.SurrogateContextFactory.CreateContext(ExecutionType& execType)
   at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
   at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
   at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
   at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
   at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
   at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!7!11/05/2008-23:58:52:: i INFO: Call to RenderFirst( '/test/Report2' )
w3wp!library!7!11/05/2008-23:58:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---
w3wp!webserver!7!11/05/2008-23:58:52:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Logon failed. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
   at Microsoft.ReportingServices.Diagnostics.ImpersonationContext.Login(CredentialsType credType, Guid dataSourceId, String userName, String userPwd, String domain)
   --- End of inner exception stack trace ---


0
 
LVL 17

Expert Comment

by:MIKE
ID: 22968508
First question...are you using ACTIVE DIRECTORY to administrate your userID's a nd Passwords...???

I would recommend creating GROUPS for logins,..then you can simply ADD the User's to their designated groups.

....? >>>>>????
0
 

Author Comment

by:NaumLitvin
ID: 22969114
to CRXIuser2005:
No, I am not using AD, should I? Is it a must? Can I create groups using Server Users Management tool?

If YES, could you please elaborate? You suggest to create group, say, ReportUsers and permit it to do what? who should be mebers of that group? ASPNET? Real people who run reports?

thank you

0
 

Author Comment

by:NaumLitvin
ID: 23125228
Well, the asker (me) is still interested bu tif  there are indeed no experts available then we have to close it...
0
 
LVL 17

Expert Comment

by:MIKE
ID: 23125269
I don't know what you mean by Server Users Management Tool.

But the Windows Active Directory works fine. I would recommend using AD.

I've been crazy busy..so ....I'll have to research a little and get back with you...from what I remember it took a while to understand HOW it works..but once you see the concept...its no problem...

M
0
 

Author Comment

by:NaumLitvin
ID: 23126915
Server Users Management Tool is Server component where I create users and assign them to groups. If needed I can provide few screen shots...

looking forward to see your instructions how to do AD... Although I was under impression that it is not needed, to use AD. If ASPNET has enough permissions on the server and remote user has access to IIS to run ASP.NET applications (which SSRS is) - is that not enough?? Can it be that SSRS internal roles and permissions need some configuration?

thanks
Naum
0
 

Accepted Solution

by:
NaumLitvin earned 0 total points
ID: 23697758
1) no one responded since 12.08.2008
2) I moved on to another projects.


0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
An article on effective troubleshooting
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question