Stored Credentials On Shared Data Source

Jan 5, 2007

I'm trying to use stored credentials to enable caching. I've created a special windows user account with minimum permissions for just this task, and once set up, it works great (almost).

I can update the shared data source using SQL Mgt Studio or directly via the Report Manager to use a set of -windows- stored credentials. But I don't seem to be able to do the same via VS.NET 2005. I can only store -SQL- credentials, which I have no need to enable and no desire to add to my surface area.

The problem lies that every time I deploy any report that using that data source (which is nearly all of them), the data source is re-published, which wipes out the stored credentials and caching immediately stops.

I've tried messing with the XML directly, with no luck, and changing assorted advanced settings, but nothing seems to stick.

Obviously I can manually update the credentials each time I deploy something, but surely it seems that there must be a better way. Is there a way to either set the DS to use stored windows credentials, or just plain prevent the deployment of the DS every time a dependent report is published?

Suggestions?

Geof

P.S. SQL 2005 Standard Ed SP1 32-bit

View 1 Replies


ADVERTISEMENT

Shared Connections And Stored Credentials For Subscriptions?

Apr 11, 2007

I can't seem to get this to work and have to resort to a custom connection for each report in Server Manager. The problem with that is that I have to re-do it every time I re-deploy the reports. Is there a secret to this that I have not found yet?



Dick Campbell

View 9 Replies View Related

Data Source Credentials Problem

Mar 21, 2007

Hi guys. I've got an Xml DataSource in my report server, used to talk to a web service to retrieve it's data. Now, since this is an Xml DataSource that talks to a Web service, i shouldn't have to give it credentials to run with, or - since the web service runs on the machine right next to my report server - I could use Windows Integrated Auth. However ... when I try to use Windows Integrated auth. I get back the error:"This
data source is configured to use Windows integrated security. Windows integrated
security is either disabled for this report server or your report server is
using Trusted Account mode. "And when I tried to use no credentials, before I can even see the report, I get the error:"the user data source credentials that are required to execute this report are
not stored in the report server database." - where I just told it that it doesn't need credentials to run this datasource !!!

View 7 Replies View Related

Error For The User Data Source Credentials.

Oct 16, 2007

Hi,

I Created Report using shared data source but when I try to run this report using dynamic connection string parameter I am getting error

I supplied parameter to connection string is

"data source=" & Parameters!Server.Value & ";initial catalog=" & Parameters!Database.Value &";user id="Parameters!LoginID.Value & ";password="Parameters!Password.Value


I also created these parameters like Server, Database, LoginID, Password in report paramenters


but when I try to run this I am getting either of these errors

error no 1.The current action cannot be completed because the user data source credentials that are required to execute this
report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)

error no 2.An error has occurred during report processing.
Cannot create a connection to data source 'SRVDataSource'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors


Please help me out

T.I.A

View 1 Replies View Related

User Data Source Credentials Error

Jun 21, 2007



I have created reports using in SSRS 2005 and deployed in Reportserver.

when I run the reports I am getting the following error.



"
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)



"

View 1 Replies View Related

Setting Report Data Source Credentials Programmatically?

Feb 1, 2006

Hello,

I've been working on an application that uploads an RDL to Reporting Services (through the SOAP webservice method CreateReport) programmatically. I'm having difficulty setting up the data source properties for my uploaded report. In particular the Data Source Credentials property.

The datasource for my report doesn't require credentials. By default after I upload the report to Reporting Services, the Data Source Credentials property is set to "Credentials supplied by the user running the report". How do I go about setting the Data Source Credentials property to "Credentials are not required" programmatically through the webservice?

Thanks in advance

View 6 Replies View Related

Shared Data Source

Dec 19, 2006

I experimented a strange behavior using connections for data source inside packages in vss 2005.

Suppose we have a tab1 in a develpment source db and in a test source db:

tab1 dev db contains 100 records
tab 2 test db contains 200 records

I start developing a package using an 'ole db data source' task inside a data flow. When I change the data source from dev to test, strange thinks happens.

The 'ole db source task' retrieve only 197 records ... but if I open the connection inside the connection manager pane and only after i click on the 'test connection' button tI get 200 records.

The source db is a sql 2000 db server and I use ole db provider for sql server.

Cosimo

View 1 Replies View Related

Accessing Shared Data Source In VS.net

Aug 10, 2007



How can i get the shared data sources i created in the report manager to be available in VS.net to be able to assign to a report. I want to be able to create the shared data source first in Report manager and then be able to assign it a report in VS.Net



Thanks.

View 4 Replies View Related

SQL 2012 :: SSRS Data Shared Data Source Connection Login

Jan 12, 2015

Was wondering if there was a best practice minimum permissions for creating a SQL login to use when setting up a new shared Data source for SSRS report manager?

Something along the lines of them being a data read for the DB and permissions to update tempdb?

Would have thought it not advisable to have the login be able to update the main db...

View 1 Replies View Related

Change Data Source For Shared Dimensions

Jun 21, 2005

I have an archive of an Analysis Services database that was created on a server that is not accessible to me. I also have a copy of the source SQL Server database that it uses as a data source. I have restored both of these to my server. I have figured out how to change the data source to point to my server for the fact tables referenced, but I can't figure out how change the data source for the shared dimensions. I would like to be able to do work on this version of the database, but I get errors when I try to browse the dimension data because it can't connect to the original data source. Any ideas?

View 6 Replies View Related

What Are The Intended Boundaries Of A Shared Data Source?

Dec 7, 2007

I see that a .rds file was created as a result of me defining a shared data source. So are they meant to be shared across projects only within the same solution, across solutions perhaps with references, system wide etc?

View 1 Replies View Related

Modifying Shared Data Source At Runtime

Mar 20, 2007

Hi all,
I have several reports using single shared datasource. I want to change at a runtime database that is used by that datasource. Can this be achieved? If not what are the other solutions €“ I guess that using not shared datasource for each report may be the solution (is it?) but it is not the best solution for me. My goal is to allow users to run the same set of reports, viewed in ReportViewer control, but using different databases (connection string dependant).

Thanks in advance for any suggestions

View 4 Replies View Related

Error In Accessing Shared Data Source

Aug 16, 2007



I created the shared data source and the report in VS 2005. After deploying the report to the Report server and trying to access it produces the following error.
An error has occurred during report processing.

Cannot create a connection to data source 'kv_testQA'.


ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified












I checked to see if the Data source exists in the Report Server and it does. But it still produces the error. What is the issue here.




Thanks for the help.






















View 3 Replies View Related

User Credentials Are Getting Lost When Using Shared Datasource

Jun 6, 2007

Hello All,



I have a situation and no idea what is going wrong.



We have many reports stored and view from the report manager. many of these reports internally use a datasource which is shared among others.



Many a times we have realised that the report stops working with the error.
Reporting Services Error




The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Get Online Help



SQL Server Reporting Services




All i have to again do is update the user credentials and it starts working again. but nobody explicitly remove the credentials also. i dont know if it a tools bug or some where i am making a mistake in deploying. i deploy the reports through visual Studio.



Any idea?

/Soni

View 1 Replies View Related

Reporting Services :: How To Setup Data-source Credentials With User Running The Report

Jun 2, 2015

I want to create a datasource but the credentials I want to use will be based on the user running the report rater than hard coded.

I have tried using Windows Integrated Security but all i can is cant log in as NTAnonymous User?

View 8 Replies View Related

Dynamically Change Initial Catalog In Shared Data Source In Reporting Services?

Oct 30, 2007

First off, let me just say that I'm a complete newbie to SQL Reporting Services, and .NET in general. We have a VB 6 application that is trying to launch an SRS 2005 report in a viewer window. This was accomplished by creating A VB.NET "wrapper" window that launches the report, and allows the report to be previewed, exported, etc. I did not write any of this.

The report is using a Shared Data Source, which points to a specific database. My problem is that the users can select which db they want when they launch the VB 6 Application, so I need to find a way to edit the connection string in the report to specify which database to use on the fly. I have the db name in the "wrapper" application, but I can't figure out how to pass it to the report.


thx,

Paul

View 3 Replies View Related

Integration Services :: Package Failed After Changing Password In Shared Data Source

Jun 19, 2015

I'm using a shared data source to connect an Oracle server in my packages.  After changing the database user password in the shared data source, I noticed the package concerned would fail with the following description.

Source: "OraOLEDB"  Hresult: 0x80004005  Description: "ORA-01017: invalid username/password; logon denied".

Is there a way to ensure the packages will use the latest information in the shared data source?  I did do a Rebuild before executing the packages.

View 5 Replies View Related

Where Are Credentials For Data Sources Stored?

Apr 22, 2008

For credentials, I have a Shared Data Source that "uses a specific user name and password".

When I open the data source's RDS file, I observed that the credentials are not stored in the RDS file.

Where are the credentials for the data sources stored?

It has to be stored somewhere. When I close and reopen the solution, the credentials for the data source are still intact.

View 1 Replies View Related

How To Connect To File Source And Supply Credentials

Feb 25, 2008

I have a package that moves Interbase data over to a Sql server. All works fine but I need to supply credentials (windows not db) when connecting to the source. Right now I am creating a share on the source but I want to remove that requirement. What do use for this and where does it go in the process?

Thanks

View 11 Replies View Related

Reporting Services :: SSRS Shared Dataset As Source For SSIS?

May 12, 2015

Could we use SSRS Shared Dataset as a source to the SSIS package?

View 3 Replies View Related

Credentials Used To Run This Report Are Not Stored

Jan 23, 2007

Hi all,

When I create a new report subscription in report manager, I got this error

Credentials used to run this report are not stored



any idea?

Thanks,

Jone

View 17 Replies View Related

Credentials Used To Run This Report Are Not Stored.

Apr 17, 2007

I created a report in SSRS, and deployed it. I have created security where when users run the on demand report, it will prompt them for a username and password. I went to the properties of the report then Execution, and tried to set up report execution snapshot and got an error 'Credentials used to run this report are not stored.' I get the same error if I go to History and try to select any of the options there.

View 11 Replies View Related

Credentials And Extended Stored Procedures

Jun 11, 2007

I have a database script that uses the extended stored procedures sp_OACreate and sp_OCMethod to execute an .exe file. The .exe file is located on the same machine as the SQL Server. At this time it does nothing but log the name of the user calling it.



When I execute the script from Management Studio (logged in as myself) the user being logged as the caller of the .exe is still NT AUTHORITYSYSTEM. I don't know why NT AUTHORITYSYSTEM is the caller, cause the SQL Server service runs under another domain account.



I have tried playing around with EXECUTE AS USER but no matter what, the caller of the .exe is always logged as NT AUTHORITYSYSTEM.



Are there any way I can pass my credentials to the executable that I am calling from the T-SQL script?

View 2 Replies View Related

Report Server Stored Credentials

Dec 11, 2006

I am getting the standard "Subscriptions cannot be created because the credentials used to run the report are not stored -".I tried to store them in the Stored Data Source in the Visual Studio Project and then deployed. I cannot find in any documentation a reference where to go to STORE CREDENTIALS for a Report Server subscription. I would really appreciate any help on this. I did look at the existing threads, but they don't specifically address where to create the credentials. Thanks for any help you can provide.

View 6 Replies View Related

Stored Credentials When Using Report Models?

Apr 17, 2007

I am have a few reports built in Report Builder and obviously using Report Models. All these report models are using a share data source. When I try enable to enable chache or creating subscription I get and error that "Credentials used not stored".



I thought well let me store the credentials for the data source used by the model used by the report on the server. I still get the same error.


I tried to create a custom data source for the report but there is not option for connection string to connect to Report Server Model. We have "Microsoft SQL SEVER", "OLE DB", "Microsoft SQL Analysis Services", "ORACLE", "ODBC", "XML", "SQP Netweaver BI" and "Hyperion Essabe"


if I understand this right to create cache or subscription I must store the credentials for each report making shared Data source concept redundant. Also I cannot create a connection string to connect to Report Server Model.


I would greatly appreciate if anyone can tell me how to enable cache or subscriptions for report that are built on report models using shared data source.

View 1 Replies View Related

Can You Use A Stored Procedure In A Data Source View?

Aug 2, 2007

Is it possible to use a stored procedure in a Data Source View? When I use the wizard to create the Datasource View, all it lets me choose is tables and views in the database. Am I missing something, or trying to do something that is impossible?

View 8 Replies View Related

Using A Stored Procedure As A Data Flow Source

Dec 11, 2007



Simple question - can I use an external stored procedure for my data flow source. I assume that I can use the OLEDB connection and go from there?

Can I use SQL command and do exec sp_thisprocedure?

Thanks for the information.

View 5 Replies View Related

Stored Procedures Not Possible As Data Source View?

Apr 3, 2007

only the tables and views are shown in the wizard (BIDS) thanks...

View 1 Replies View Related

How To Export Data From Stored Procedure Source?

Mar 31, 2006

Hi,

I have a SSIS package which exports data from a view in SQL database into Excel file. It was created by Export Wizard in SQL 2005 Server.

Now I would like to modify this package and change data source from view to stored procedure.

What component from toolbox should I use? it should be placed in Control Flow or Data Flow? And how connetc it with my Excel Destination?

thanks,

Przemo

View 3 Replies View Related

SSIS-Use Stored Procedure/function As The Data Source

Jan 28, 2008



How do I use stored procedure or a user defined function as the data source in my SSIS package.
I am very new to SSIS.
Thanks

View 5 Replies View Related

Calling A Stored Procedure On A Data Source (with Parameters)

Nov 29, 2007

This seems to be much more difficult than it was in DTS (or perhaps I just need to adjust to the new way of doing things).

Eventually I found that I needed to use "SQL command from variable" and using two other variables as input parameters. The expresion for the command is

"usp_ValveStatusForDay '" + @[User:ate] + "','" + @[User::Report] + "'"

which typically evaluates as

usp_ValveStatusForDay '18 Oct 07','Report_Name'

This previews correctly and the resulting columns are available for mapping to a destination. So far so good.

By the way, is this the best way to call a stored procedure with parameters?

I have pasted the stored procedure at the end of this posting because I have come accross a puzzling problem. The query as shown below works correctlly but if I un-comment the delete statement, the preview still works and the columns are still avilable for mapping but I get the following errors when the package is executed.


Error: 0xC02092B4 at Data Flow Task, OLE DB Source [1]: A rowset based on the SQL command was not returned by the OLE DB provider.

Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC02092B4.

I realise that I could execute the delete query in a separate SSIS package step but I am curious as to why there is a problem with the way I tried to do it.

At one stage the stored procedure used a temp table and later I also experimented with a table variable. In both cases I got similar errors at execution time. In the case of the temp table there was another problem in that, while the preview worked, there were no columns available for mapping. Using a table variable seemed to overcome this problem but I still got the run time error. eventually I found a way to avoid using either a temp table or a table variable and the package then worked correctly, copying the data into the desitnation table.

It seems to me that if there is any complexity at all to the stored procedure, these errors seem to occur. Can anyone enlighten me as to what the "rules of engagement" are in this regard? Is one solution to use a wrapper stored procedure that simply calls the more complex one?



ALTER procedure [dbo].[usp_ValveStatusForDay]

(

@dateTime DateTime,

@reportName VarChar(100)

)

AS

BEGIN

DECLARE @day VarChar(10)

DECLARE @month VarChar(10)

DECLARE @year VarChar(10)

DECLARE @start VarChar(25)

DECLARE @end VarChar(25)

SET @day = Convert(Varchar(10),DatePart(day, @dateTime))

SET @month = Convert(VarChar(10), DatePart(month, @dateTime))

SET @year = Convert(VarChar(10), DatePart(year, @dateTime))

IF @month = '1' SET @month = 'Jan'

IF @month = '2' SET @month = 'Feb'

IF @month = '3' SET @month = 'Mar'

IF @month = '4' SET @month = 'Apr'

IF @month = '5' SET @month = 'May'

IF @month = '6' SET @month = 'Jun'

IF @month = '7' SET @month = 'Jul'

IF @month = '8' SET @month = 'Aug'

IF @month = '9' SET @month = 'Sep'

IF @month = '10' SET @month = 'Oct'

IF @month = '11' SET @month = 'Nov'

IF @month = '12' SET @month = 'Dec'

SET @start = @day + ' ' + @month + ' ' + @year + ' 00:00:00'

SET @end = @day + ' ' + @month + ' ' + @year + ' 23:59:59'

--delete from ValveStatus where SampleDateTime between dbo.ToBigInt(@start) and dbo.ToBigInt(@end)

exec dbo.usp_ValveStats_ReportName @reportName, @start, @end, '1h'

END

View 8 Replies View Related

Need A SqlServer Stored Procedur To Check Login Credentials

Mar 10, 2006

Sid writes "Hi,
can anybody plz provide me the stored procedure for checking the credentials(uid,Pwd) of a login page in sqlserver.

Thanks,
Sid."

View 2 Replies View Related

An Error Has Occurred During Report Processing. A Data Source Instance Has Not Been Supplied For The Data Source DetailDS_get_o

Mar 13, 2008

hi ,

i am trying for a drill through report (rdlc)

ihave written the following code in drill through event of reportviewer, whenever i click on the first report iam getting the error like

An error has occurred during report processing.


A data source instance has no
t been supplied for the data source "DetailDS_get_orderdetail".







the code is



using System;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

//using Microsoft.ApplicationBlocks.Data;

using Microsoft.Reporting.WebForms;

using DAC;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

ReportViewer1.Visible = false;

}

protected void Button1_Click(object sender, EventArgs e)

{

DAC.clsReportsWoman obj = new clsReportsWoman();

DataSet ds = new DataSet();

ds = obj.get_order();

ReportViewer1.LocalReport.DataSources.Clear();

ReportDataSource reds = new ReportDataSource("DataSet1_get_order", ds.Tables[0]);



ReportViewer1.LocalReport.DataSources.Add(reds);

ReportViewer1.LocalReport.ReportPath = "C:/Documents and Settings/km63096/My Documents/Visual Studio 2005/WebSites/drillthrurep/Report.rdlc";

ReportViewer1.LocalReport.Refresh();

ReportViewer1.Visible = true;

}

protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)

{

DAC.clsReportsWoman obj = new clsReportsWoman();

ReportParameterInfoCollection DrillThroughValues =

e.Report.GetParameters();



foreach (ReportParameterInfo d in DrillThroughValues)

{

Label1.Text = d.Values[0].ToString().Trim();

}

LocalReport localreport = (LocalReport)e.Report;

string order_id = Label1.Text;

DataSet ds = new DataSet();

ds = obj.get_orderdetail(order_id);



ReportViewer1.LocalReport.DataSources.Clear();

ReportDataSource reds = new ReportDataSource("DetailDS_get_orderdetail", ds.Tables[0]);

ReportViewer1.LocalReport.DataSources.Add(reds);

ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"Reportlevel1.rdlc");

ReportViewer1.LocalReport.Refresh();





}



}

the code in method get_orderdetail(order_id) is

public DataSet get_orderdetail(string order_id)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.Parameters.Add("@order_id", SqlDbType.VarChar, 50);
cmd.Parameters["@order_id"].Value = order_id;
ds = SQLHelper.ExecuteAdapter(cmd, CommandType.StoredProcedure, "dbo.get_orderdetail");
return (ds);
}pls help me.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved