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 shared. Show all posts
Showing posts with label shared. Show all posts
Tuesday, March 20, 2012
Thursday, March 8, 2012
Cannot create a connection to data source
Why is it that sometimes I get this error and sometimes not after I deploy the same shared data souce to my Report Server?
Even if I try deleting the datasouce through Report Manager the redeploy it from VS 2005, it still errors out when I run my report. I am able to run my report fine in VS.
An error has occurred during report processing.
Cannot create a connection to data source 'mydatasourcenamehere'.
For more information about this error navigate to the report server on the local server machine, or enable remote error
Most likely the data source is configured to use Windows Integrated Security. When deployed to the report server (machine A), accessing the report from (machine B) will run into the double-hop issue when the report tries to access a data source on machine C.
-- Robert
|||I struggled with this problem for a few hours until I figured out that I had a file system permission problem. The user running the report must have write permissions on the ../Reports directory. Once I made this change in IIS, the report ran with no errors.
I suppose this permission is required because new .aspx pages have to be created to represent the report instance in the web site's file system.
HTH,
tqheel
Cannot create a connection to data source
Why is it that sometimes I get this error and sometimes not after I deploy the same shared data souce to my Report Server?
Even if I try deleting the datasouce through Report Manager the redeploy it from VS 2005, it still errors out when I run my report. I am able to run my report fine in VS.
An error has occurred during report processing.
Cannot create a connection to data source 'mydatasourcenamehere'.
For more information about this error navigate to the report server on the local server machine, or enable remote error
Most likely the data source is configured to use Windows Integrated Security. When deployed to the report server (machine A), accessing the report from (machine B) will run into the double-hop issue when the report tries to access a data source on machine C.
-- Robert
|||I struggled with this problem for a few hours until I figured out that I had a file system permission problem. The user running the report must have write permissions on the ../Reports directory. Once I made this change in IIS, the report ran with no errors.
I suppose this permission is required because new .aspx pages have to be created to represent the report instance in the web site's file system.
HTH,
tqheel
Thursday, February 16, 2012
Cannot connect to shared database
Using Vista, when I start Outlook 2007 I get the following message:
Business Contact Manager for Outlook could not connect to the shared database.//looking for msslbiz Do you want to work offline?
I click Continue and get the messagebox:
Business Contact Managerdatabase cannot be loaded
This action cannot be completed because Business Contact Manager cannot access the database. The database is currently stopped.
Do you want to change the database configuration?
i say Yes and the messagebox says
Microsoft Windows Search Protocol Host has stopped working.
A problem cause the program to stop working correctly. Windows will close the program and notify you if a solution is available.
I close program (no choice) and message says:
Cannot find the selected database. Verify that the network and the computer on which the databases are located are available, and that you have permission to access the database, and then retry.
Connect to computer name prompt does not work
Create new database does not work
Database creation was unsuccesful
Using MS SQL Server Management Studio Express) to connect to msslbiz
SQLServer does not allow remote connections (when trying to conect to
Note that SqlServer Express is started and running on the Vista machine, and the databases I create are available to other machines on my lan. I cannot find a way to enable remote connections on msslbiz. Any help would be greatly appreciated.
If I understand what you're trying to do, consider that SQL Express' default behavior is to disable the ability to view the server instance from another system on the LAN. You'll need to follow the instructions in http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html. Basically, this means enabling the SQLBrowser service, enabling the ports and protocols needed to share the SQLEXPRESS instance. This is generally done using the SQL Server Surface Area Configuration Tool.
hth
Subscribe to:
Posts (Atom)