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.
Showing posts with label credentials. Show all posts
Showing posts with label credentials. Show all posts
Tuesday, March 20, 2012
Thursday, March 8, 2012
Cannot create a connection to data source 'dataSource1'.
I am getting this error from Report Builder
Cannot create a connection to data source 'dataSource1'.
Back end SQL 2000
Credentials stored securely in the report server
Login and password of the SQL login
The weird thing is pointing to another db on the same server works fine
--
Peter
Peter.freeborn@.halliburton.comHope you have created Report model, If not use report model to access reports
from builder.
If you have already created it check the datasource "test connection" in the
report model project.
If you are accessing directly from builder using "open report server file",
dont do it cause it will ask for datasource which you cannt include. So
create a model and then access.
Amarnath
"Peter" wrote:
> I am getting this error from Report Builder
> Cannot create a connection to data source 'dataSource1'.
> Back end SQL 2000
> Credentials stored securely in the report server
> Login and password of the SQL login
> The weird thing is pointing to another db on the same server works fine
>
> --
> Peter
> Peter.freeborn@.halliburton.com|||I've struck this problem, I did some digging around and it seems that this is
a problem with kerberos security. Basically if you store the credentials in
the report server then the report server can pass the credentials fine,
however on a remote server it can't unless you've set up kerberos and use
windows security.
Thats my understanding of the problem, however the error message doesn't
really lead you in that direction.
HTH
"Peter" wrote:
> I am getting this error from Report Builder
> Cannot create a connection to data source 'dataSource1'.
> Back end SQL 2000
> Credentials stored securely in the report server
> Login and password of the SQL login
> The weird thing is pointing to another db on the same server works fine
>
> --
> Peter
> Peter.freeborn@.halliburton.com
Cannot create a connection to data source 'dataSource1'.
Back end SQL 2000
Credentials stored securely in the report server
Login and password of the SQL login
The weird thing is pointing to another db on the same server works fine
--
Peter
Peter.freeborn@.halliburton.comHope you have created Report model, If not use report model to access reports
from builder.
If you have already created it check the datasource "test connection" in the
report model project.
If you are accessing directly from builder using "open report server file",
dont do it cause it will ask for datasource which you cannt include. So
create a model and then access.
Amarnath
"Peter" wrote:
> I am getting this error from Report Builder
> Cannot create a connection to data source 'dataSource1'.
> Back end SQL 2000
> Credentials stored securely in the report server
> Login and password of the SQL login
> The weird thing is pointing to another db on the same server works fine
>
> --
> Peter
> Peter.freeborn@.halliburton.com|||I've struck this problem, I did some digging around and it seems that this is
a problem with kerberos security. Basically if you store the credentials in
the report server then the report server can pass the credentials fine,
however on a remote server it can't unless you've set up kerberos and use
windows security.
Thats my understanding of the problem, however the error message doesn't
really lead you in that direction.
HTH
"Peter" wrote:
> I am getting this error from Report Builder
> Cannot create a connection to data source 'dataSource1'.
> Back end SQL 2000
> Credentials stored securely in the report server
> Login and password of the SQL login
> The weird thing is pointing to another db on the same server works fine
>
> --
> Peter
> Peter.freeborn@.halliburton.com
Cannot create a connection to data source
I am in the same situation as many who have been getting this problem except
I have a slightly unique situation. I cannot specify credentials in my
shared connection. I am using the three tier approach without AS. I cannot
specify credentials because I want them to run a stored procedure that uses
the credentials passed in to return them only thier data, not the data of any
other user. It parses the user name using the system_user attribute to find
out who is calling the procedure and then queries the database with that
information. If I pass credentials in then everyone will see the same data,
not the result I want. I need to know how to get the credentials to pass to
the third tier. Can someone help with this...?
-Ed
Web Systems Engineer
Mercy Medical CenterThis seems to have one more wrinkle. It is only when I try to use pass
through authentication. If I switch the data source to "The credentials
supplied by the user running the report" and check the box "Use as Windows
credentials when connecting to data source." and then use the same
credentials I am logged into the computer with the report loads exactly as
expected. If I change the datasource to Windows NT Integrated Security then
the reports fails to load with an error. The error is :
"Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'src'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection. "
-Ed Mackin
Web Systems Engineer
"Ed Mackin" wrote:
> I am in the same situation as many who have been getting this problem except
> I have a slightly unique situation. I cannot specify credentials in my
> shared connection. I am using the three tier approach without AS. I cannot
> specify credentials because I want them to run a stored procedure that uses
> the credentials passed in to return them only thier data, not the data of any
> other user. It parses the user name using the system_user attribute to find
> out who is calling the procedure and then queries the database with that
> information. If I pass credentials in then everyone will see the same data,
> not the result I want. I need to know how to get the credentials to pass to
> the third tier. Can someone help with this...?
> -Ed
> Web Systems Engineer
> Mercy Medical Center
>
I have a slightly unique situation. I cannot specify credentials in my
shared connection. I am using the three tier approach without AS. I cannot
specify credentials because I want them to run a stored procedure that uses
the credentials passed in to return them only thier data, not the data of any
other user. It parses the user name using the system_user attribute to find
out who is calling the procedure and then queries the database with that
information. If I pass credentials in then everyone will see the same data,
not the result I want. I need to know how to get the credentials to pass to
the third tier. Can someone help with this...?
-Ed
Web Systems Engineer
Mercy Medical CenterThis seems to have one more wrinkle. It is only when I try to use pass
through authentication. If I switch the data source to "The credentials
supplied by the user running the report" and check the box "Use as Windows
credentials when connecting to data source." and then use the same
credentials I am logged into the computer with the report loads exactly as
expected. If I change the datasource to Windows NT Integrated Security then
the reports fails to load with an error. The error is :
"Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'src'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection. "
-Ed Mackin
Web Systems Engineer
"Ed Mackin" wrote:
> I am in the same situation as many who have been getting this problem except
> I have a slightly unique situation. I cannot specify credentials in my
> shared connection. I am using the three tier approach without AS. I cannot
> specify credentials because I want them to run a stored procedure that uses
> the credentials passed in to return them only thier data, not the data of any
> other user. It parses the user name using the system_user attribute to find
> out who is calling the procedure and then queries the database with that
> information. If I pass credentials in then everyone will see the same data,
> not the result I want. I need to know how to get the credentials to pass to
> the third tier. Can someone help with this...?
> -Ed
> Web Systems Engineer
> Mercy Medical Center
>
Subscribe to:
Posts (Atom)