SSRS 2005 post installation problems

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
NaumLitvinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
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
NaumLitvinAuthor Commented:
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
ValentinoVBI ConsultantCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

NaumLitvinAuthor Commented:
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
ValentinoVBI ConsultantCommented:
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
NaumLitvinAuthor Commented:
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
MIKESoftware Solutions ConsultantCommented:
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
NaumLitvinAuthor Commented:
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
NaumLitvinAuthor Commented:
Well, the asker (me) is still interested bu tif  there are indeed no experts available then we have to close it...
0
MIKESoftware Solutions ConsultantCommented:
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
NaumLitvinAuthor Commented:
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
NaumLitvinAuthor Commented:
1) no one responded since 12.08.2008
2) I moved on to another projects.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.