Can Report Manager add data source do one with a stored procedure
-
On another thread someone kindly suggested using reporting services to do a new front end report.
The issue is that I have got the report working perfectly in BIDS but cannot deploy it as its asking for id and password and I've tried everything inc all the admins and no go!
So I'm left with uploading the report file into Report Manager, but that does not take the data source that is set up to use a stored procedure! However in Report builder I can't find any way of adding a stored procedure based data source, unless I can put it in the connection string? Is that possible please?
I thought I'd change the windows service identity password in Reporting Services config but that then asks me for the encryption Key that I also do not have so drew a blank there. The guy who set all this up walked away leaving with little documentation! 🙁
Google leads me to believe it might be something to do with IIS but reporting services is not in the IIS tree.
Any further thoughts anyone. This should have gone live today!
-
Robin,
On the SQL Server open Reporting Services Configuration Manager and connect to the SQL Server you have reporting services installed on. If there are any red 'X's on the left side click on that text and correct the problem reported. My first guess is that the report server is not initialized, so there will be a red 'X; next to initialization.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Hi Jack and thanks for responding.
All the icons are green except:
- 'Sharepoint Integration' and 'Encryption Keys' which are both blue exclamation marks.
- 'Initialisation' which is a tick but greyed out such that I can't get to it. The key at the botto indicates its not supported in the current mode!
Does this help or hinder?
Thanks again ........ Robin
-
Okay, that's good I think as I have never seen it grayed out. This could be a permissions issue.
Can you connect to the report server (http://server name/reports is the default) using a browser (it looks best in IE)? You can verify the path by looking at the Report Manager Virtual Directory in Reporting Services Configuration.
If you can connect go to Site Settings (upper right hand corner), then check out Configure site-wide security. If you can't get there then you need to work with a server admin to get SSRS security setup so you can publish reports and you may want to request Admin rights within SSRS. Not knowing your corporate culture I don't know how you'd go about that. If you can get to the security tab then you are probably okay as far as security, so post your results and we'll try something else.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Thanks Jack.
I can get into Site settings.
First screen.
Name: SQL Server Reporting Services
Enable My reports is ticked.
Unlimited snapshots.
Exec time max 1800
Exec logging ticked.
Log entris over 60 days removed.
Site wide security screen.
Two roles configured.
BUILTIN\Administrator Overall, System Admin, System User
Me. Overall, System Admin, System User
We are a very small dept and I am in system admins group. However I set myself up specifically in a fruitless attempt to get around the security problem!
Thanks for helping .......... Robin
-
Okay so you are all set with access to the report server. That eliminates permissions. Now the question is are you correctly connecting to the report server when deploying from BIDS?
Open your report project in BIDS and go to Project -> Properties. You should see something like this:
Is the information correct?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Hi Jack.
Here it is when:
Debug = StartItem
OverwriteDataSources = False (makes no difference I still get the UID and password request if set true)
TargetDataSourceFolder = Data Sources
TargetReportFolder = Report Project2
TargetServerURL = http://jrssvr/reports (This is the server in question and is the same URL used to get into Report Manager).
So yes, all looks OK to me but perhaps you can see something I'm missing?
Thanks for your patience ...... Robin
-
I've found the answer.
Looking at those properties again, it occurred to me I really wanted to publish to the the database, not to the site. I changed the target server to /Reportserver rather than /Reports and it all worked a treat.
Then I looked back at Jack's last post and noted that the clue was staring me in the face but I read what I expected to see, not what was there! :doze:
So many thanks Jack and please forgive my stupidity. At least others might learn from it.
Best wishes ....... Robin
-
Robin,
Glad you found it. I would have caught the issue had you not done so before I got here.
You are not the only one to have that issue. In some ways MS made SSRS harder than it needs to be I think.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
I'm just grateful this forum and all its helpful contributors exist. Thanks again Jack.
Robin
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply