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


ADVERTISEMENT

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

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

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

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 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

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

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

Credentials Of The User Datasource

Sep 12, 2007



Hi,

I'd like to programme the execution of a report through the execution property option. However, when I try to do it a message error appears related to credentials of the datasource.

The present action is impossible to complete, because the credentials of the user datasource needed to execute this report are not stored on report server database.

I've tried all possible combinations.

Any idea?

Thanks.

View 2 Replies View Related

Cannot Impersonate User For Data Source

May 26, 2008

Hi all,

I encountered a problem when I tried to generate .rdl report in my PWA website integrated with report server. In the "Manage Data Source", when I set the credential type to "Windows authentication (integrated)", it works.
However, when I changed it to "Stored credentials" with the windows account as the Login, the following error occurs:

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'CustomizedDB'. (rsErrorImpersonatingUser)

Logon failed. (rsLogonFailed)

Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)



Does anyone know the reason behind? Thanks in advance.



The problem also happens when "Prompt for credentials (use as Windows Credential)" is used.

View 1 Replies View Related

Prompt For User Credentials For Database

Jun 18, 2007

Hello friends,
In my web application I have saved my connection string into web.config file. Now I have to send this web application to the client in the form of web set up. The issue is that on the client side, user credentials for the database will be different. So can we do some setings that the web application whenever will run should ask for the server name, username & Password. If this can be done then the application can be run anywhere considering all compatibilities.
Please let me know how this can be done.
Thanks & RegardsGirish Nehte

View 2 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

SQL Security :: Sync AD User Credentials With Database

Mar 14, 2014

How Sync the user and password from my Active Directory, to a SQL Database. Actually, my environment have a database with users and password added, my custom applications uses it like a passport, but now I want to use Active Directory to control these users, but I can't use windows authentication in my old apps. I was reading about Forefront Identity Manager to do this, but I need a free solution. The Sharepoint database sync user credentials with AD?

MCTS Exchange 2010

View 3 Replies View Related

Accessing User Info In Data Source Where Clause?!

Mar 22, 2008

I have created a data repeater with a data source and want to select records by user, I know how to access the current user in ADO.NET but cant for the life of me see how I can access it with the data source wizard??
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Thanks for your help

View 1 Replies View Related

Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log

Dec 13, 2007



Hi,

I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.

Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."

Please help me

thanks in advance

Srinivas



View 1 Replies View Related

Import Excel Data From User-selected Source File

Dec 4, 2007

Is it possible to import data from an Excel spreadsheet using OPENROWSET or OPENDATASOURCE without having to explicitly define the filepath of the source file? Currently, I have this piece of code within a sproc:


INSERT INTO [dbo].[ProductionRequirementDetail]

([ProductionRequirementHeaderID], [SKU], [Quantity])

SELECT @ProductionRequirementHeaderID,

[SKU],

[LAMPS]

FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0; Database=C:WeeklySchedule.xls', 'SELECT * FROM [Master$C5:Q65536]') AS XL

LEFT JOIN [dbo].[PartMaster] ON (RIGHT([XL].[CODE], 7) = [PartMaster].[SKU])

WHERE [SKU] IS NOT NULL

AND [CODE] IS NOT NULL

AND [LAMPS] IS NOT NULL

AND [LAMPS] > 0

AND [LampTypeID] = @LampTypeID




I would like to remove the hardcoded reference 'Database=C:WeeklySchedule.xls' and replace it with a parameter for the filepath. Is this possible? This is in SQL Server 2000. Also, if there is a way to do this with DTS I'd be open to doing it that way too.

View 8 Replies View Related

How To Set My ASP.NET Application To Access SQL Server 2005 Using Client's User Credentials?

Jan 29, 2007

Hi guys,I'm not sure if I'm just bad at googling but I can't seem to find a way to set an ASP.NET 2.0 web application to connect to SQL Server 2005 using the current client's user credentials. My web application is using Integrated Windows Authentication so its Page.User.Identity is set to a DOMAINusername value... I want to pass that to my connectionstring or have my connections pick up the identity automatically and use that Identity when accessing the db server.Oh and another thing, my IIS Application Pool is using a specific Identity itself, so I don't know if that might affect the above.Hope someone could help. 

View 2 Replies View Related

User Credentials Delegation From IIS On WinXP To SQL Server On Win2003SRV Fails

Jan 12, 2007

Problem:

I am trying to create an asp.net website with integrated windows authentication
to access SQL databases. IIS resides on WinXP and SQL Server
on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot
reside on the same machine and a stand alone web server is
ideal as the website needs to access multiple SQL Servers. IIS is set to
Integrated Windows Authentication. The machine running IIS & the SQL Server
are set to be "trusted for delegation" in active directory. The domain user
accounts that will be accessing the databases are not marked as "Account
is sensitive and cannot be delegated".

The connection string that the web app uses to connect to SQL database is:

"Data Source=PWSSQLT;Integrated Security=SSPI;Initial Catalog=Pace_Master;Persist Security Info=true"

with which the user credentials should be flown to the SQL database.
But instead the delegation fails and results in the following ANONYMOUS authentication failure error:

Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

Description: An unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it originated in the code.

--------------------------------------------------------------------------------------------------------------------

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

Source Error:

// Open the connection, and return it

oConn.Open();
return oConn;


Source File: e:ING eIMSApp_CodeDataAccessConnectionManager.cs

Stack Trace:
[SqlException (0x80131904): Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.]

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader
dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject,
SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity,
SqlConnectionString connectionOptions, Object providerInfo, String newPassword,
SqlConnection owningObject, Boolean redirectedUserInstance)
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options,
Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open()

INGRS.DataAccess.ConnectionManager.GetConnection() in e:ING eIMSApp_CodeDataAccessConnectionManager.cs:
DAActivity.Page_Load(Object sender, EventArgs e) in e:ING eIMSDADAStatusDAActivity.aspx.cs
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
_______________
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
---------------------

View 6 Replies View Related

Cannot Create A Connection To Data Source 'xxxxx' When User Runs Report

Dec 6, 2007

We have a new installation of sql server 2005 reporting services.
we can deploy reports without a problem users can connect to report server
but when they try to run reports they get this error msg.

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

in reporting services the datasource credentials are saved on the server

View 3 Replies View Related

Script Task User Defined Variable And Data Reader Source SQL Statement

Jan 12, 2007

Hello,

Please can anyone tell me if or how I have to cross reference to a user defined variable from a script task in the SQL of a Data Reader Source?



The script task creates a variable for the last Sales Ledger Session. The SQL in the data reader source that updates the DW sales invoice lines file based upon those invoice lines where the session number is greater than the value from the script task.



The SQL command in the custom properties doesn't cross reference back to the variable.



If anyone can help or needs further detail to help please post a resonse.

Thanks,

Marcus Simpson

View 4 Replies View Related

Pipeline Error-excel Source-data Reader Does Not Read In Meta Data

Apr 16, 2008

Hi all, i got this error:


[DTS.Pipeline] Error: "component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

and also this:

[Excel Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "Fiscal Week" needs to be updated in the external metadata column collection. The column "Fiscal Year" needs to be updated in the external metadata column collection. The column "1st level" needs to be added to the external metadata column collection. The column "2nd level" needs to be added to the external metadata column collection. The column "3rd level" needs to be added to the external metadata column collection. The "external metadata column "1st Level" (16745)" needs to be removed from the external metadata column collection. The "external metadata column "3rd Level" (16609)" needs to be removed from the external metadata column collection. The "external metadata column "2nd Level" (16272)" needs to be removed from the external metadata column collection.


I tried going data flow->excel connection->advanced editor for excel source-> input and output properties and tried to refresh the columns affected.
It seems that somehow the 3 columns are not read in from the source file?
ans alslo fiscal year, fiscal week is not set up up properly in my data destination?
anyone faced such errors before?

Thanks

View 13 Replies View Related

XML Data Source .. Expression? Variable? Connection? Error: Unable To Read The XML Data.

Feb 23, 2008

RE: XML Data source .. Expression? Variable? Connection? Error: unable to read the XML data.

I want my XML Data source to be an expression as i will be looping through a directory of xml files.

I don't see the expression property or the connection property??

I tried setting the XMLData property to @[User::filename], but that results in:

Information: 0x40043006 at Load XML Files, DTS.Pipeline: Prepare for Execute phase is beginning.
Error: 0xC02090D0 at Load XML Files, XML Source [108]: The component "XML Source" (108) was unable to read the XML data.
Error: 0xC0047019 at Load XML Files, DTS.Pipeline: component "XML Source" (108) failed the prepare phase and returned error code 0xC02090D0.
Information: 0x4004300B at Load XML Files, DTS.Pipeline: "component "OLE DB Destination" (341)" wrote 0 rows.
Task failed: Load XML Files
Information: 0xC002F30E at Bad, File System Task: File or directory "d:jcpxmlLoadjcp2.xml.bad" was deleted.
Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
The program '[3312] Package.dtsx: DTS' has exited with code 0 (0x0).


Thanks for any help or information.

View 3 Replies View Related

Data Source Error?

Feb 2, 2006



Hey everyone,

Just wondering if anyone could answer a simple question for me. Here is a brief background on what I'm trying to do and my setup. I'm working with .net studio 2005 and Windows Mobile 2005. I'm just doing some testing with SQLCE for future projects that I plan to implement with it. I'm somewhat new to .net, however I have experience in VS6.0. I wrote a simple app that contains Data Binding and was attempting at Datasets on a Mobile device, but I ran across some error. However that error I'm not concerned with yet. The error that I'm concerned with is tring to implement the same project except connecting to a mobile database on the desktop. I created a database called Tech that is a mobile database sitting in MyDocuments. In the Server Explorer window the database shows that I'm connected to it. I can using Databinding just fine, however when I try to connect through code I get an error saying "Data Source not found". At first I thought maybe my connection string is wrong .. well I don't think it is. If I look at the project window Tech.sdf shows up but it looks as if the icon is a unknown file type. I don't think this would be the case being that DataBinding works however .. you never now. This is how I'm attempting to connect with out any trys and catches though.

Dim Conn As SqlServerCe.SqlCeConnection

Dim DA As SqlServerCe.SqlCeDataAdapter

Dim DS As New DataSet

Conn = New SqlServerCe.SqlCeConnection("Data Source = Tech.sdf")

DS = New SqlServerCe.SqlCeDataAdapter("Select * from User", Conn)

Conn.Open()

Nothing advance just tring to do a simple connection so that I can fill a DataSet. I have also tried placing the complete file path for the connection string with no luck. The DB has no password or anything. Just keeping it straight forward as possible while I try to conquer this learning curve. Any clue?

View 4 Replies View Related

Error While Creating Credentials

Aug 10, 2005

Hi guys

View 5 Replies View Related

Runtime Data Source Error

Nov 29, 2006

Hello

I have a defined data source to an oracle server. I've alredy intalled oracle client, and setup my data source to save the user and password. I'm using .NET provider/OracleClient DataProvider Connection. When I click on "Test Connection" Button, SSIS reports SUCCESS. In Connection Manager TAB I created on connection called "OracleServer" from my oracle data source, described above.

In my package, I defined a DataReaderSource task, I specified "OracleServer" as a connection to it. I can preview data and view oracle's columns name..., so it make me think that everything is fine. But when It execute the task it FAIL and notify logon error and that password can't be blank.

Please help, I need read from the oracle server!!

Thank you.

View 2 Replies View Related

ODBC Data Source Error

Apr 20, 2006

As other contributors, all I am trying to do is import data from an ODBC source (spelled 'non-Microsoft data source') into a SQL 2005 table. I can easily do this in SQL 2000 with DTS, but when I use the same DSN in VS 2005 it doesn't work.

I created an integration project, and made a connection in Connection Manager to the DSN and clicked Test Connection. It succeeded, or so it claimed.

Click OK and drag a DataReader Source onto the Data Flow surface Doubleclick it and select the connection manager per above. Note the error: Error at Data Flow Task [DataReader Source[50]]: Cannot acquire a managed connection from the run-time connection manager.

What does that mean? More to the point, how to fix it?

View 7 Replies View Related

Data Source / ODBC Error

Dec 31, 2005

Hi all,

My replication of those SQL 2000 servers gave errors: Data source (11): General Network Error. Check your network documentation... and ODBC (08S01): Communication link failure. The replication was across the WAN. I don't know where to start to troubleshoot this problem. Please help!

Thanks in advance.

John

View 12 Replies View Related

Email Subscription Error On Credentials

Sep 18, 2007

Hello,

When trying to subscribe to an report via email I get to 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)


Can anybody help me with this issue.

Greetings
Vinnie

View 15 Replies View Related

Reporting Services - Credentials Error.

Dec 14, 2006

Hi everyone.

I have created a report in RS and it works fine (am invoking from VB.Net - windows forms).

However, I have copied the report into a new one as I need a very similar looking report to be called from the same application, but if I attempt to invoke it in the same way as the first I get the following error:

"An attempt was made to set credentials for a data source '<name>' associated with thre report. Report data source settings are specified in a way that prevens credentials from being submitted to the report server."

I am passing the credentials like so:

Dim cc As New DataSourceCredentials
Dim cred() As DataSourceCredentials = {cc}

cred(0).Password = "*****"
cred(0).UserName = "****"
cred(0).DataSourceName = "**DSNAME**"

Any help would be gratfully recieved, as this is driving me completely nuts.

Thanks in advance.

View 1 Replies View Related

Cannot Create A Connection To The Data Source Error

Apr 22, 2008



Hi,

I have setup SSRS with 3 data models using 3 different datasources on one server. I can create reports ok, but if any of the other users I want to access these reports tries to open the report I created or run there own reports (they can create a report), it gives them the error:

Report Execution Error

Cannot create a connection to the data source 'datasource1'

I do not recieve this error, but the other users do. I have set the other users as System administrator in the site-wide permissions, so they have access to everything.

Everything is set to integrated windows authentication.

On the Reporting Server Configuration Manager, the Unattended Execution Account is not selected and is blank.

What could cause these users not to be able to run existing or new reports they create?

Thanks for any help,

Steve

View 1 Replies View Related

Error When Generating Data Source Model

Mar 20, 2008

When I attempt to generate a datasource model I get the following error messages:
------------------------------------------------
More than one item in the Entity 'Customer' has the
name 'Customer Merge Custs'. Item names must be unique
among immediate siblings. (DuplicateItemName)

More than one Field in the Entity 'Customer' has the
name 'Customer Merge Custs'. Field names must be
unique within an Entity. (DuplicateFieldName)

More than one item in the Entity 'Pricing Service Layout
Detail' has the name 'Pricing Service
Extensions'. Item names must be unique among immediate
siblings. (DuplicateItemName)

More than one Field in the Entity 'Pricing Service Layout
Detail' has the name 'Pricing Service
Extensions'. Field names must be unique within an Entity.
(DuplicateFieldName)
---------------------------------------------------

Examining any of the above tables in SQL Server Management Studio does not reveal any duplicate column names. In fact, 'Customer_Merge_Custs' does not appear to be a column in 'Customer' nor does 'Pricing_Service_Extensions' appear in 'Pricing_Service_Layout_Detail'.

As an experiment, deleting the table 'Pricing_Service_Extensions' and regenerating did make the two associated messages go away.

Steve P.

View 3 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

Error When Connect To Oracle Data Source

Mar 4, 2008

Hi,

I have several oracle reports which running in SharePoint Integrated mode. They were working well when the SharePoint server and report server in same machine. But after that the report server move out to another machine, we got the problem with connection to oracle databasen. Reports with Sql server as data source has no problem at all.

We have installa both oracle client and odp.net in both machines, and tried to give Network Service full access right in
Bin catalog in oracle client but nothing helps. Please help!!!!!


An error has occurred during report processing. (rsProcessingAborted)


Cannot create a connection to data source 'Ellentst'. (rsErrorOpeningConnection)


For more information about this error navigate to the report server on the local server machine, or enable remote errors






In log file:

Cannot create a connection to data source 'DatabasName'. ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

We have installed oracle client version 10.2.0 in both machine.

View 2 Replies View Related







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