Creating an OLTP datasource for writing reports
As suggested on:
http://msdn2.microsoft.com/en-US/library/ms159161(SQL.90).aspx
I created a new data source which I have called TfsOltpReportDS and which uses the Microsoft SQL Server connection type and the following connection string:
data source="(local)";initial catalog=MyProject
However I have login problems. If I enter the user and password which is used for TfsReportDS then I get failed login errors when I clickApplythe first time orGenerate Model.
If I select the option "Credentials supplied by the user running the report" to diagnose this and try to generate a model I get this error:
SQL Server Reporting Services
Error
Logon failed. (rsLogonFailed) Get Online Help Value does not fall within the expected range.
and I am not prompted with "Type or enter a user name and password to access the data source:" as I expect to be. What is wrong here? I am confused.
Bernd,
The reason why the credentials of the user provided in the other datasource work is because that user has permissions to the specific database used to define the datasource(for TfsReportDs the service account has permissions to the relational TfsWarehouse).
For example , if you wish to report on Work Items, you could define a datasource mapped to the TFSWorkItemTracking table and grant the service account(which would be used to render reports) the correct permissions.
Thanks,
Othmane
Othmane,
That makes sense but I'm still not sure what it means with regards to the error I have. O.K. I means I'm trying to access a database for which the service account does not have persmissions. I can fix that on the SQL server no doubt by granting the permissions required. But how do I identify which database is involved? I have to admit I'm not adept at and thoroughly confudsed by all the on-line help thus far on, the interpretation and construction of connection strings.
What is it in the connection string above that identifes the database for which the service account must have perimssions?
Also, why am I not prompted for a login when I choose that option? That behaviour seems totally far field to me. Something odd is going on there. I'm not asking it to use any account just to prompt me when the connection attempt is made so I can play with accounts and passwords and do some diagnistic login work I guess. It's not crucial to try this way, but the failure to deliver a prompt certainly seems odd!
What are you going to use the new data source for? If you need additional information in the Warehouse or the Cube in order to create custom reports you may be able to extend the current warehouse/cube definition by adding additional "Reportable" fields.
I notice you have MyProject listed as the "initial catalog" in the connection string - do you want to collect data specific to a project?
Regarding why you are not prompted - this is outside of my domain. The SQL Reporting Services Forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) will be a better resource for specific Reporting Services questions.
Regarding the database involved - if you wanted to get data from TfsWorkItemTracking (not recommended) then you would set the connection string to:
Data source=YOUR_MACHINE;initial catalog=TFSWorkItemTracking
and add whichever user you specified to the TFSWorkItemTracking permissions.
