 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / September 2005Subscription HELP PLEASE
I keep getting a "Logon Failed" beside my subscription in the GUI when it Runs. SQL Server Agent is running. SMTP is setup right in the RSServer config file. My DataSource is setup to use "Credentials stored securely in the report server" And this is a user we created to access both the database we are querying from and as a user in the Report Server database. CAN ANYONE HELP Me???? The Error I got in the log is as Follows: ReportingServicesService!dbpolling!cf0!9/21/2005-14:39:09:: EventPolling processing 1 more items. 1 Total items in internal queue. ReportingServicesService!dbpolling!d84!9/21/2005-14:39:09:: EventPolling processing item c0c211ca-42aa-42b8-ab46-79ccdef98753 ReportingServicesService!library!d84!9/21/2005-14:39:09:: Schedule 8734d39f-9f54-4767-ad0b-1174869206e1 executed at 9/21/2005 2:39:09 PM. ReportingServicesService!schedule!d84!9/21/2005-14:39:09:: Creating Time based subscription notification for subscription: b248a802-15ce-4ed9-a019-3ebfd43bd8e9 ReportingServicesService!library!d84!9/21/2005-14:39:09:: Schedule 8734d39f-9f54-4767-ad0b-1174869206e1 execution completed at 9/21/2005 2:39:09 PM. ReportingServicesService!dbpolling!d84!9/21/2005-14:39:09:: EventPolling finished processing item c0c211ca-42aa-42b8-ab46-79ccdef98753 ReportingServicesService!dbpolling!cf0!9/21/2005-14:39:09:: NotificationPolling processing 1 more items. 1 Total items in internal queue. ReportingServicesService!dbpolling!d84!9/21/2005-14:39:09:: NotificationPolling processing item 4105c963-0eb9-4f69-bbbc-81ab27964a43 ReportingServicesService!library!d84!09/21/2005-14:39:10:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties. ReportingServicesService!library!d84!09/21/2005-14:39:10:: 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. at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo) at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName, String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken) at Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain) --- End of inner exception stack trace --- ReportingServicesService!notification!d84!09/21/2005-14:39:10:: e ERROR: Error occured processing notification. Logon failed. ReportingServicesService!notification!d84!09/21/2005-14:39:10:: Notification 4105c963-0eb9-4f69-bbbc-81ab27964a43 completed. Success: False, Status: Logon failed., DeliveryExtension: Report Server Email, Report: Incomplete Loan Applications, Attempt 0 ReportingServicesService!dbpolling!d84!09/21/2005-14:39:10:: NotificationPolling finished processing item 4105c963-0eb9-4f69-bbbc-81ab27964a43 ReportingServ The failure is the login to your remote data source. See if you can create a snapshot of that report. You might need to set the Use as Windows credentials to the remote data source as well. There could be a double hop issue with the credentials going from Client -> RS -> Data Source if they are all on different machines. -------------------- | Thread-Topic: Subscription HELP PLEASE | thread-index: AcXFCCS4k5I1UO7dQg2y5k4F8n32eQ== [quoted text clipped - 65 lines] | String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken) | at Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserTok en(String userName, String userPwd, String domain) | --- End of inner exception stack trace --- | ReportingServicesService!notification!d84!09/21/2005-14:39:10:: e ERROR: | Error occured processing notification. Logon failed. | ReportingServicesService!notification!d84!09/21/2005-14:39:10:: Notification | 4105c963-0eb9-4f69-bbbc-81ab27964a43 completed. Success: False, Status: | Logon failed., DeliveryExtension: Report Server Email, Report: Incomplete [quoted text clipped - 3 lines] | 4105c963-0eb9-4f69-bbbc-81ab27964a43 | ReportingServ The error you are getting is: Logon failure: unknown user name or bad password. This could be for either the datasource for the report of for the unattended execution account. To set the execution account you can use rsconfig.exe with the -e option.  Signature-Daniel This posting is provided "AS IS" with no warranties, and confers no rights. >I keep getting a "Logon Failed" beside my subscription in the GUI when it > Runs. SQL Server Agent is running. SMTP is setup right in the RSServer [quoted text clipped - 61 lines] > 4105c963-0eb9-4f69-bbbc-81ab27964a43 > ReportingServ In Response to Brad and Daniel. Both the ReportServer DataSource and the DataSource for my Report are on the same machine. I Created a user "MYUSER" and gave access for this user to the Datasource for my report(this is my user i use with stored credentials on my shared datasource). I added this user to the Report Server Database as well. I am able to render the report but not execute a subscription. I don't understand what you mean by unattended execution. Can you clarify what this is? Also, what is the syntax for setting the execution account in the rsconfig.exe? > The error you are getting is: Logon failure: unknown user name or bad > password. [quoted text clipped - 68 lines] > > 4105c963-0eb9-4f69-bbbc-81ab27964a43 > > ReportingServ The unattended account is used by background threads to run as a specific user when no credentials are specified. It should not be used in this situation, but I would verify it anyway. The syntax is rsconfig.exe -e -u <username> -p <password> Signature-Daniel This posting is provided "AS IS" with no warranties, and confers no rights. > In Response to Brad and Daniel. Both the ReportServer DataSource and the > DataSource for my Report are on the same machine. I Created a user [quoted text clipped - 95 lines] >> > 4105c963-0eb9-4f69-bbbc-81ab27964a43 >> > ReportingServ I gave my user RSEXECRole permissions, but I still get logon failed Any thing else I can look at? > The unattended account is used by background threads to run as a specific > user when no credentials are specified. It should not be used in this [quoted text clipped - 101 lines] > >> > 4105c963-0eb9-4f69-bbbc-81ab27964a43 > >> > ReportingServ The RSExecRole is a database role. Did you run the rsconfig.exe command? This command will set a user for RS to use. The error your seeing is an error when RS attempts to impersonate some windows user. It can only be one of two users, the DataSource user or the Unattended Account user. You should verify that both are correct. Signature-Daniel This posting is provided "AS IS" with no warranties, and confers no rights. >I gave my user RSEXECRole permissions, but I still get logon failed > Any thing else I can look at? [quoted text clipped - 119 lines] >> >> > 4105c963-0eb9-4f69-bbbc-81ab27964a43 >> >> > ReportingServ I ran the rsconfig command. The syntax I used was rsconfig -e -u reportuser -p reportP@sswrd. I use the same user on my shared datasource. I am still getting a login failed. Here is the log: ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!588!9/30/2005-08:31:24:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file. ReportingServicesService!resourceutilities!588!9/30/2005-08:31:24:: i INFO: Running on 1 physical processors, 1 logical processors ReportingServicesService!resourceutilities!588!9/30/2005-08:31:24:: i INFO: Reporting Services starting SKU: Enterprise ReportingServicesService!runningjobs!588!9/30/2005-08:31:24:: i INFO: Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds ReportingServicesService!runningjobs!588!9/30/2005-08:31:24:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds ReportingServicesService!runningjobs!588!9/30/2005-08:31:24:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds ReportingServicesService!runningjobs!588!9/30/2005-08:31:24:: i INFO: Execution Log Entry Expiration timer enabled: Cycle: 62915 seconds ReportingServicesService!runningjobs!588!9/30/2005-08:31:24:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds ReportingServicesService!crypto!bc4!9/30/2005-08:31:24:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM ReportingServicesService!crypto!bc4!9/30/2005-08:31:24:: i INFO: Exporting public key ReportingServicesService!crypto!bc4!9/30/2005-08:31:25:: i INFO: Performing sku validation ReportingServicesService!crypto!bc4!9/30/2005-08:31:25:: i INFO: Importing existing encryption key ReportingServicesService!dbpolling!bc4!09/30/2005-08:31:25:: EventPolling polling service started ReportingServicesService!dbpolling!bc4!09/30/2005-08:31:25:: NotificationPolling polling service started ReportingServicesService!dbpolling!bc4!09/30/2005-08:31:25:: SchedulePolling polling service started ReportingServicesService!dbpolling!cb0!9/30/2005-08:31:25:: EventPolling heartbeat thread started. ReportingServicesService!dbpolling!270!9/30/2005-08:31:25:: NotificationPolling heartbeat thread started. ReportingServicesService!dbpolling!c4c!9/30/2005-08:31:25:: Polling started ReportingServicesService!dbpolling!c4c!9/30/2005-08:35:07:: EventPolling processing 1 more items. 1 Total items in internal queue. ReportingServicesService!dbpolling!978!09/30/2005-08:35:07:: EventPolling processing item 405c0d0c-7f46-4921-9f1a-f0befd455f80 ReportingServicesService!library!978!09/30/2005-08:35:07:: Schedule 2f0a6d2d-c1d3-4995-876e-d244b0c2cc60 executed at 09/30/2005 08:35:07. ReportingServicesService!schedule!978!09/30/2005-08:35:07:: Creating Time based subscription notification for subscription: 2ff31f97-3425-4930-b736-18a28d0f7cbb ReportingServicesService!library!978!09/30/2005-08:35:07:: Schedule 2f0a6d2d-c1d3-4995-876e-d244b0c2cc60 execution completed at 09/30/2005 08:35:07. ReportingServicesService!dbpolling!978!09/30/2005-08:35:07:: EventPolling finished processing item 405c0d0c-7f46-4921-9f1a-f0befd455f80 ReportingServicesService!dbpolling!c4c!9/30/2005-08:35:07:: NotificationPolling processing 1 more items. 1 Total items in internal queue. ReportingServicesService!dbpolling!978!09/30/2005-08:35:07:: NotificationPolling processing item 62eb3af5-d208-4a44-9038-80eb72c190d3 ReportingServicesService!library!978!09/30/2005-08:35:08:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties. ReportingServicesService!library!978!09/30/2005-08:35:08:: 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. at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo) at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName, String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken) at Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain) --- End of inner exception stack trace --- ReportingServicesService!notification!978!09/30/2005-08:35:08:: e ERROR: Error occured processing notification. Logon failed. ReportingServicesService!notification!978!09/30/2005-08:35:09:: Notification 62eb3af5-d208-4a44-9038-80eb72c190d3 completed. Success: False, Status: Logon failed., DeliveryExtension: Report Server Email, Report: Incomplete Loan Applications, Attempt 0 ReportingServicesService!dbpolling!978!09/30/2005-08:35:09:: NotificationPolling finished processing item 62eb3af5-d208-4a44-9038-80eb72c190d3 ReportingServicesService!dbpolling!588!9/30/2005-08:39:19:: EventPolling polling service stopped ReportingServicesService!dbpolling!cb0!9/30/2005-08:39:19:: EventPolling heartbeat thread exiting for stop. ReportingServicesService!dbpolling!588!9/30/2005-08:39:19:: NotificationPolling polling service stopped ReportingServicesService!dbpolling!270!9/30/2005-08:39:19:: NotificationPolling heartbeat thread exiting for stop. ReportingServicesService!dbpolling!588!9/30/2005-08:39:19:: SchedulePolling polling service stopped ReportingServicesService!servicecontroller!588!9/30/2005-08:39:22:: Service controller exiting. > The RSExecRole is a database role. Did you run the rsconfig.exe command? > This command will set a user for RS to use. The error your seeing is an [quoted text clipped - 125 lines] > >> >> > 4105c963-0eb9-4f69-bbbc-81ab27964a43 > >> >> > ReportingServ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.