To test SQL2000 replication, I enabled replications for NorthWind between
ServerA and ServerB. ServerA was the publisher and distributor, ServerB was
the subscriber.
After test, I deleted everything about replication on ServerA, at last, I
disabled replication. However, when I ckeck ServerB, in the
Replication\Subscriptions container, There is a "ServerA:NorthWind:" object.
I cannot remove it. If I right click this item, it only has a "set update
method..." menu which is grayed out, and another "help" menu. It looks like
a phantom object.
I then re-configure the server as a subscriber again (subscribe test DB and
set ServerA as a publisher), the Replication\Subscriptions container now has
another object "ServerA:test:test", and the content menu looks normal, which
includes "New pull subscription...", "Reinitialize", "delete"...etc. menu.
How can I delete the "ServerA:NorthWind:" object?
OK, it looks like you have lingering metadata. If you can, can you disable
replication one more time.
then run the following script
create table whack_me ([database] sysname, [table] sysname, constraint
Whack_me_pk primary key([database], [table]))
GO
insert into whack_me([database],[table])
exec sp_msforeachdb 'select [database]=''?'',[table]=''
MSreplication_subscriptions'' from ?.dbo.MSreplication_subscriptions where
publisher=@.@.servername'
insert into whack_me([database],[table])
exec sp_msforeachdb 'select [database]=''?'',[table]=''
MSsubscription_agents'' from ?.dbo.MSsubscription_agents where
publisher=@.@.servername'
whack_me will have a list of the lingering subscriptions and the databases
they are in. Delete the contents of these tables where the publisher
=@.@.servername
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MLi" <lige888@.gmail.com> wrote in message
news:uxGiwzXEGHA.3004@.TK2MSFTNGP15.phx.gbl...
> To test SQL2000 replication, I enabled replications for NorthWind between
> ServerA and ServerB. ServerA was the publisher and distributor, ServerB
> was the subscriber.
> After test, I deleted everything about replication on ServerA, at last, I
> disabled replication. However, when I ckeck ServerB, in the
> Replication\Subscriptions container, There is a "ServerA:NorthWind:"
> object. I cannot remove it. If I right click this item, it only has a "set
> update method..." menu which is grayed out, and another "help" menu. It
> looks like a phantom object.
> I then re-configure the server as a subscriber again (subscribe test DB
> and set ServerA as a publisher), the Replication\Subscriptions container
> now has another object "ServerA:test:test", and the content menu looks
> normal, which includes "New pull subscription...", "Reinitialize",
> "delete"...etc. menu.
> How can I delete the "ServerA:NorthWind:" object?
>
|||I ran the script on ServerA and got a bunch of errors:
Invalid object name 'Northwind.dbo.MSsubscription_agents'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'master.dbo.MSsubscription_agents'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'model.dbo.MSsubscription_agents'.
Msg 208, Level 16, State 1, Line 1
....
I just want to delete everything about NorthWind replication, any easy way?
like delete all rows about NorthWind in some particular table?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:Oxgn9BaEGHA.216@.TK2MSFTNGP15.phx.gbl...
> OK, it looks like you have lingering metadata. If you can, can you disable
> replication one more time.
> then run the following script
> create table whack_me ([database] sysname, [table] sysname, constraint
> Whack_me_pk primary key([database], [table]))
> GO
> insert into whack_me([database],[table])
> exec sp_msforeachdb 'select [database]=''?'',[table]=''
> MSreplication_subscriptions'' from ?.dbo.MSreplication_subscriptions
> where publisher=@.@.servername'
> insert into whack_me([database],[table])
> exec sp_msforeachdb 'select [database]=''?'',[table]=''
> MSsubscription_agents'' from ?.dbo.MSsubscription_agents where
> publisher=@.@.servername'
> whack_me will have a list of the lingering subscriptions and the databases
> they are in. Delete the contents of these tables where the publisher
> =@.@.servername
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "MLi" <lige888@.gmail.com> wrote in message
> news:uxGiwzXEGHA.3004@.TK2MSFTNGP15.phx.gbl...
>
|||in the table whack_me you will find a list of databases and tables. Go
through these databases and tables and delete the contents of them.
Ignore the error messages.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MLi" <lige888@.gmail.com> wrote in message
news:u1r7y4mEGHA.4036@.TK2MSFTNGP09.phx.gbl...
>I ran the script on ServerA and got a bunch of errors:
> Invalid object name 'Northwind.dbo.MSsubscription_agents'.
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'master.dbo.MSsubscription_agents'.
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'model.dbo.MSsubscription_agents'.
> Msg 208, Level 16, State 1, Line 1
> ...
> I just want to delete everything about NorthWind replication, any easy
> way? like delete all rows about NorthWind in some particular table?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:Oxgn9BaEGHA.216@.TK2MSFTNGP15.phx.gbl...
>
|||sp_removedbreplication
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"MLi" <lige888@.gmail.com> wrote in message
news:u1r7y4mEGHA.4036@.TK2MSFTNGP09.phx.gbl...
>I ran the script on ServerA and got a bunch of errors:
> Invalid object name 'Northwind.dbo.MSsubscription_agents'.
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'master.dbo.MSsubscription_agents'.
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'model.dbo.MSsubscription_agents'.
> Msg 208, Level 16, State 1, Line 1
> ...
> I just want to delete everything about NorthWind replication, any easy
> way? like delete all rows about NorthWind in some particular table?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:Oxgn9BaEGHA.216@.TK2MSFTNGP15.phx.gbl...
>
|||With all due respect Mike the OP did this to begin with.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:ecQUaGpEGHA.1312@.TK2MSFTNGP09.phx.gbl...
> sp_removedbreplication
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "MLi" <lige888@.gmail.com> wrote in message
> news:u1r7y4mEGHA.4036@.TK2MSFTNGP09.phx.gbl...
>
|||I'm sorry Hilary, I guess I was just too stupid to realize that. Thank you
for helping me understand my stupidity.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ulLILIsEGHA.3708@.TK2MSFTNGP10.phx.gbl...
> With all due respect Mike the OP did this to begin with.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:ecQUaGpEGHA.1312@.TK2MSFTNGP09.phx.gbl...
>
|||Just found another way to delete this lingering object-- by SQL 2005
Management Studio
The object has a "delete" context menu
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:ecQUaGpEGHA.1312@.TK2MSFTNGP09.phx.gbl...
> sp_removedbreplication
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "MLi" <lige888@.gmail.com> wrote in message
> news:u1r7y4mEGHA.4036@.TK2MSFTNGP09.phx.gbl...
>
Showing posts with label subscriptions. Show all posts
Showing posts with label subscriptions. Show all posts
Thursday, March 22, 2012
Tuesday, March 20, 2012
Cannot create subscriptions from Management Studio
I cannot create any subscriptions from Management Studio.
Reports have shared Data Source with stored credentials
SQL Agent is up and running
In surface area configuration "Scheduling and delivery" for SSRS are enabled
SSRS Execution account has been set up
E-mail settings are fine
I'm logged in as Admin, able to everything, but...
When I right-click on report/subscriptions folder, both "New subscription"
and "New data driven subscription" are DISABLED.
What's wrong? That's driving me crazy!
DmitryHello Dmitry,
I would like to know, when you try to use the Report Manager Via web
interface,
If you try to use the Report Manager via web and create the subscription,
what's the result?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOpkHyeGIHA.4268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I would like to know, when you try to use the Report Manager Via web
> interface,
> If you try to use the Report Manager via web and create the subscription,
> what's the result?
I am using custom (forms) security and the admin can only log in through
Management Studio. For security purposes (this is internet-faced
application) no separate login pages for SSRS exist.
Regular users (authenticated and authorized) can see the reports inside web
application via ReportViewer control, which is getting the instance of
IReportServerCredentials.
Regards,
Dmitry|||Hello Dmitry,
Well, since you are using the form authentication, the management studio
may not connect to the reporting services correctly.
I would like to know whether the admin account you use have the proper
permission of reporting services.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:bIg%23C9rGIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Well, since you are using the form authentication, the management studio
> may not connect to the reporting services correctly.
> I would like to know whether the admin account you use have the proper
> permission of reporting services.
Yes, the admin is in any possible role. I already mentioned that in my
initial message. I'm able to do everything that's not subscriptions related.
Subscription-related menu items are simply disabled and I need to know why.
Dmitry.|||Hello Dmitry,
The admin you use is a domain account or a form authentication account?
Have you checked what's the role of this account on the reporting services?
Is it a System admin ?
Also, for the report, does it have the Manage all subscriptions permission?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:2rG$mH3GIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> The admin you use is a domain account or a form authentication account?
There's no such account technically. Admin is authenticated by
username/password inside forms security extension and after that it is given
unlimited access in any CheckAccess method...
> Have you checked what's the role of this account on the reporting
> services?
I answered this question already:
System User
System Administrator
Browser
Content Manager
Publisher
Report Builder
> Is it a System admin ?
Yes.
> Also, for the report, does it have the Manage all subscriptions
> permission?
Through Content Manager role, yes
As a matter of fact I have just installed the second instance of RS with
standard security and all the defaults. And I observe the same damn thing:
subscription related menu items are disabled in Management studio, but I can
create subscriptions using the same Windows credentials in the browser.
Which tells me the original issue may be not related to my custom security
extension at all.
Regards,
Dmitry|||Hello Dmitry,
Could you please let me know the config file content?
rsreportserver.config and RSWebApplication.config under the ReportManager
and Reporserver folder is appreicated.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:p$%23GYM5GIHA.5176@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you please let me know the config file content?
> rsreportserver.config and RSWebApplication.config under the ReportManager
> and Reporserver folder is appreicated.
E-mail delivery of those files failed. Please provide valid e-mail address.
The following message to <weilu@.online.microsoft.com> was undeliverable.
The reason for the problem:
5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com
(MX): NXDomain'|||Hello Dmitry,
Please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Dmitry,
I get your email.
I would like to suggest you check the web services account you use.
Could you please change it to the network services?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7mWE3N4HIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I get your email.
> I would like to suggest you check the web services account you use.
> Could you please change it to the network services?
Please advise WHERE EXACTLY this change to be made.
D.|||Hello Dmitry,
There is an element in the reportserver.config file:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
Please modify it like this.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:R78DbCCIIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> There is an element in the reportserver.config file:
> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
> Please modify it like this.
It is configured to be running as MYPCNAME\ASPNET
If I modify "like this" I'm getting the following message while trying to
navigate to any folder in Management Studio:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--
ADDITIONAL INFORMATION:
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Report Services SOAP Proxy Source)
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Microsoft.ReportingServices.Diagnostics)
D.|||Hello Dmitry,
I am performing some test on my side. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Dima,
I would like to know whether you have applied the latest service pack of
sql server and have you stored the credential for the report.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:K1afiFOLIHA.6908@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dima,
> I would like to know whether you have applied the latest service pack of
> sql server
It is 9.00.3054.00
> and have you stored the credential for the report.
There is no such thing as "stored credential for the report"
If you mean "stored credentials for the DATA SOURCE", yes that's the case.
Dmitry|||Hello Dmitry,
Could you lease send me an email and that I may involve other resources?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:j33I7UmMIHA.4380@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you lease send me an email and that I may involve other resources?
Wei,
I sent you the e-mail a week ago. Where are those "other resourses"?
D.|||Hello,
My colleague is Out of Office. Once he is back, I will escalate this issue.
Sincerely,
Wei Lu
Microsoft Online Community 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.
Reports have shared Data Source with stored credentials
SQL Agent is up and running
In surface area configuration "Scheduling and delivery" for SSRS are enabled
SSRS Execution account has been set up
E-mail settings are fine
I'm logged in as Admin, able to everything, but...
When I right-click on report/subscriptions folder, both "New subscription"
and "New data driven subscription" are DISABLED.
What's wrong? That's driving me crazy!
DmitryHello Dmitry,
I would like to know, when you try to use the Report Manager Via web
interface,
If you try to use the Report Manager via web and create the subscription,
what's the result?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOpkHyeGIHA.4268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I would like to know, when you try to use the Report Manager Via web
> interface,
> If you try to use the Report Manager via web and create the subscription,
> what's the result?
I am using custom (forms) security and the admin can only log in through
Management Studio. For security purposes (this is internet-faced
application) no separate login pages for SSRS exist.
Regular users (authenticated and authorized) can see the reports inside web
application via ReportViewer control, which is getting the instance of
IReportServerCredentials.
Regards,
Dmitry|||Hello Dmitry,
Well, since you are using the form authentication, the management studio
may not connect to the reporting services correctly.
I would like to know whether the admin account you use have the proper
permission of reporting services.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:bIg%23C9rGIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Well, since you are using the form authentication, the management studio
> may not connect to the reporting services correctly.
> I would like to know whether the admin account you use have the proper
> permission of reporting services.
Yes, the admin is in any possible role. I already mentioned that in my
initial message. I'm able to do everything that's not subscriptions related.
Subscription-related menu items are simply disabled and I need to know why.
Dmitry.|||Hello Dmitry,
The admin you use is a domain account or a form authentication account?
Have you checked what's the role of this account on the reporting services?
Is it a System admin ?
Also, for the report, does it have the Manage all subscriptions permission?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:2rG$mH3GIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> The admin you use is a domain account or a form authentication account?
There's no such account technically. Admin is authenticated by
username/password inside forms security extension and after that it is given
unlimited access in any CheckAccess method...
> Have you checked what's the role of this account on the reporting
> services?
I answered this question already:
System User
System Administrator
Browser
Content Manager
Publisher
Report Builder
> Is it a System admin ?
Yes.
> Also, for the report, does it have the Manage all subscriptions
> permission?
Through Content Manager role, yes
As a matter of fact I have just installed the second instance of RS with
standard security and all the defaults. And I observe the same damn thing:
subscription related menu items are disabled in Management studio, but I can
create subscriptions using the same Windows credentials in the browser.
Which tells me the original issue may be not related to my custom security
extension at all.
Regards,
Dmitry|||Hello Dmitry,
Could you please let me know the config file content?
rsreportserver.config and RSWebApplication.config under the ReportManager
and Reporserver folder is appreicated.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:p$%23GYM5GIHA.5176@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you please let me know the config file content?
> rsreportserver.config and RSWebApplication.config under the ReportManager
> and Reporserver folder is appreicated.
E-mail delivery of those files failed. Please provide valid e-mail address.
The following message to <weilu@.online.microsoft.com> was undeliverable.
The reason for the problem:
5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com
(MX): NXDomain'|||Hello Dmitry,
Please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Dmitry,
I get your email.
I would like to suggest you check the web services account you use.
Could you please change it to the network services?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7mWE3N4HIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I get your email.
> I would like to suggest you check the web services account you use.
> Could you please change it to the network services?
Please advise WHERE EXACTLY this change to be made.
D.|||Hello Dmitry,
There is an element in the reportserver.config file:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
Please modify it like this.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:R78DbCCIIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> There is an element in the reportserver.config file:
> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
> Please modify it like this.
It is configured to be running as MYPCNAME\ASPNET
If I modify "like this" I'm getting the following message while trying to
navigate to any folder in Management Studio:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--
ADDITIONAL INFORMATION:
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Report Services SOAP Proxy Source)
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Microsoft.ReportingServices.Diagnostics)
D.|||Hello Dmitry,
I am performing some test on my side. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Dima,
I would like to know whether you have applied the latest service pack of
sql server and have you stored the credential for the report.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:K1afiFOLIHA.6908@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dima,
> I would like to know whether you have applied the latest service pack of
> sql server
It is 9.00.3054.00
> and have you stored the credential for the report.
There is no such thing as "stored credential for the report"
If you mean "stored credentials for the DATA SOURCE", yes that's the case.
Dmitry|||Hello Dmitry,
Could you lease send me an email and that I may involve other resources?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:j33I7UmMIHA.4380@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you lease send me an email and that I may involve other resources?
Wei,
I sent you the e-mail a week ago. Where are those "other resourses"?
D.|||Hello,
My colleague is Out of Office. Once he is back, I will escalate this issue.
Sincerely,
Wei Lu
Microsoft Online Community 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.
Monday, March 19, 2012
Cannot create new or change existing subscriptions
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!
Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..
ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..
|||
Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?
Thanks
|||I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc
I had a similar problem.
I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.
Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.
I also deleted as many As I could of the associated jobs but the UID makes this un-easy.
They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.
I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.
Does anybody can share such nice to have management tool?
Thanks,
Philippe
|||Just encountered the same problem with RS 2005 and this resolved my problem.
It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.
|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
|||Hi,This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe
|||
Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?
Please advice
|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?Philippe
|||
Now I get error "Credentials used to run this report are not stored"
I am logged in as admin, what changes i need to make in order to create the subscription?
Please help
|||Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?
Please guide
|||Hi,Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.
Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.
I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;
If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.
So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.
Philippe
|||
You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.
Thanks once again
Cannot create new or change existing subscriptions
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!
Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..
ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..
|||
Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?
Thanks
|||I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc
I had a similar problem.
I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.
Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.
I also deleted as many As I could of the associated jobs but the UID makes this un-easy.
They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.
I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.
Does anybody can share such nice to have management tool?
Thanks,
Philippe
|||Just encountered the same problem with RS 2005 and this resolved my problem.
It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.
|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
|||Hi,This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe
|||
Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?
Please advice
|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?Philippe
|||
Now I get error "Credentials used to run this report are not stored"
I am logged in as admin, what changes i need to make in order to create the subscription?
Please help
|||Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?
Please guide
|||Hi,Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.
Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.
I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;
If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.
So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.
Philippe
|||
You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.
Thanks once again
Cannot create new or change existing subscriptions
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!
Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..
ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..
|||
Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?
Thanks
|||I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc
I had a similar problem.
I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.
Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.
I also deleted as many As I could of the associated jobs but the UID makes this un-easy.
They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.
I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.
Does anybody can share such nice to have management tool?
Thanks,
Philippe
|||Just encountered the same problem with RS 2005 and this resolved my problem.
It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.
|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
|||Hi,This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe
|||
Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?
Please advice
|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?Philippe
|||
Now I get error "Credentials used to run this report are not stored"
I am logged in as admin, what changes i need to make in order to create the subscription?
Please help
|||Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?
Please guide
|||Hi,Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.
Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.
I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;
If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.
So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.
Philippe
|||
You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.
Thanks once again
Cannot create new or change existing subscriptions
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!
Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..
ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..|||
Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?
Thanks
|||I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc
I had a similar problem.
I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.
Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.
I also deleted as many As I could of the associated jobs but the UID makes this un-easy.
They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.
I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.
Does anybody can share such nice to have management tool?
Thanks,
Philippe
|||Just encountered the same problem with RS 2005 and this resolved my problem.
It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.
|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
|||Hi,This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe|||
Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?
Please advice
|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?Philippe|||
Now I get error "Credentials used to run this report are not stored"
I am logged in as admin, what changes i need to make in order to create the subscription?
Please help
|||Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?
Please guide
|||Hi,Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.
Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.
I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;
If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.
So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.
Philippe|||
You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.
Thanks once again
Cannot create new or change existing subscriptions
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!
Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..
ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..|||
Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?
Thanks
|||I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc
I had a similar problem.
I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.
Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.
I also deleted as many As I could of the associated jobs but the UID makes this un-easy.
They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.
I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.
Does anybody can share such nice to have management tool?
Thanks,
Philippe
|||Just encountered the same problem with RS 2005 and this resolved my problem.
It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.
|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
|||Hi,This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe|||
Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?
Please advice
|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?Philippe|||
Now I get error "Credentials used to run this report are not stored"
I am logged in as admin, what changes i need to make in order to create the subscription?
Please help
|||Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?
Please guide
|||Hi,Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.
Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.
I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;
If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.
So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.
Philippe|||
You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.
Thanks once again
Cannot create new or change existing subscriptions
We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login
When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.
We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!
Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..
ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..|||
Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?
Thanks
|||I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc
I had a similar problem.
I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.
Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.
I also deleted as many As I could of the associated jobs but the UID makes this un-easy.
They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.
I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.
Does anybody can share such nice to have management tool?
Thanks,
Philippe
|||Just encountered the same problem with RS 2005 and this resolved my problem.
It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.
|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
|||Hi,This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe|||
Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?
Please advice
|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?Philippe|||
Now I get error "Credentials used to run this report are not stored"
I am logged in as admin, what changes i need to make in order to create the subscription?
Please help
|||Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?
Please guide
|||Hi,Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.
Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.
I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;
If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.
So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.
Philippe|||
You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.
Thanks once again
Sunday, March 11, 2012
Cannot create data-driven subscription
Hi,
I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).
When I try and click on on the DDS button for a report I get the following message:
"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."
1. I have set the data source to use stored credentials.
2. I'm using one simple string parameter
3. Its not a linked report
Any ideas?
regards,
avner
Make sure your report does not contain expressions depending on user like User!UserID.
See http://msdn2.microsoft.com/en-us/library/ms156012.aspx.
|||thanks! that resolved the problem.
|||Hi,
I'm having the same problem. I'm using the browser interface for SSRS and when I click on a report and go to Subscriptions, the buttons for New Subscription and Data-driven Subscription have warning icons, and when I click on either I get the same message as above.
The report already has a data-driven subscription which was working fine. I haven't made any changes to the report. This problem is affecting all reports. What has changed is the data source (now pointing to a different database), which is using "Credentials stored securely on the server" and "Use as Windows credentials..." and "Impersonate the authenticated user..." both checked.
Is there some security setting being cached in the reports? Do I need to update the reports in some way to make them work with the updated data source?
Regards,
Greg
|||Answering my own question, the problem was the "Impersonate the authenticated user..." option. When I unchecked this for the data source I was able to create subscriptions.
Regards,
Greg
Cannot create data-driven subscription
Hi,
I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).
When I try and click on on the DDS button for a report I get the following message:
"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."
1. I have set the data source to use stored credentials.
2. I'm using one simple string parameter
3. Its not a linked report
Any ideas?
regards,
avner
Make sure your report does not contain expressions depending on user like User!UserID.
See http://msdn2.microsoft.com/en-us/library/ms156012.aspx.
|||thanks! that resolved the problem.
Subscribe to:
Posts (Atom)