SSRS &&"cannot Create A Connection To Datasource&&" Error

Hai All..

I have develop any report in reporting services on server Development. i deploy my report to server production.
i have connection to cube as data source. if open report manager in server production and open the report, its succesfully. the report is open. but if i open report manager in server development show error

An error has occurred during report processing. (rsProcessingAborted)

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

For more information about this error navigate to the report server on the local server machine
i use windows authentication in my pnl datasource.



View Replies


Cannot Create Connection To Datasource?

I've had this datasource set up for awhile now, and i had it runing off of my login and password (with the selection "Credentials stored securely in the report server" selected). and the check box for "Impersonate the authenticated user after a connection has been made to the data source" checked. But recently my password expired for my domain account, and i changed it, and now, it is not accepting either my old or new password. What is going wrong?

Here is the error messege:

An error has occurred during report processing. (rsProcessingAborted)

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

Login failed for user 'TZaccheus'.

View Replies View Related

Cannot Create A Connection To The Datasource 'DataSource1'

Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message, Its very strange it seems that its trying to generate or create a datasource.

Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
No se puede crear una conexión al origen de datos 'dataSource1'.
Error al procesar el informe.

View Replies View Related

How To Create A Datasource Which Connection Type Is SQL Server Anlysis Service In Rss Script?

I am making a rss script to deploy the reports and datasources.

View Replies View Related

2005 Reporting Service - Cannot Create Connection To Oracle Datasource On Web Server

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

View Replies View Related

Datasource Connection Error

have developed a report on a test server which I can access from i./e. http://localhost/reports

DataSourcce is accessed using a sql login

My colleague on his machine can not access. His error is:

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

View Replies View Related

Cannot Create A Connection To Data Source !!!! SSRS 2005

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group! Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password. I thought that since this datasource was set to Windows Authentification that it would just pass it through?

I'm pulling my hair out at this point:

Screen Shots:

Also As far as I know, I've given sufficient permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run

An error has occurred during report processing.

Cannot create a connection to data source 'datasourcename'.

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

View Replies View Related

Use Sybase Odbc Datasource Or Oledb Datasource,run No Error,but 0 Row Data Output,why? Help Me!!!

use sybase odbc datasource or oledb datasource,run no error,but 0 row data output,why? help me!!!

use sql server2005 ssis

View Replies View Related

SSRS Report As A Datasource To SSIS

Hi All,
Is there a way in SSIS to specify SSRS report as a datasource? I don't see any options in the data flow sources..
Thanks a lot!!

View Replies View Related

SSIS Datareader Destination As Datasource For SSRS

I am currently trying to use a SSIS datareader destination as a datasource in Reporting Services (RS). I have sucessfully developed the report and I am able to execute and see the results from it in the RS preview pane. I am also able to deploy it (same server as RS development and report is on) without errors. However, once deployed, I am unable to get the report to work in Report Manager. I get the following error message:

"An error has occurred during report processing. Query execution failed for data set Dynamic_POS_BO_xRef'. The package failed to execute."

I have read everything in BOL regarding configuration of the RS Execution Account and have configured it with a domain member that has admin rights and tryed it with one that has limited rights (best practice recommendation).

Any ideas about what else I can try?

View Replies View Related

SSIS As DataSource For SSRS - Failure On Different Machine (Server Vs Dev)

I have developed an SSIS Package which is the Data Source for a Reporting Services report (using the OLE DB Destination DataReader component - very cool and powerfull!!!).

I have one Connection Manager defined in the package to access a SQL Server 2000 Database. The authentication is set to SQL Server Authentication (per the documentation in BOL) where I provide the UserID and Password.

Here is what works and what doesn't work:

In BIDS on my local machine the report executes beautifully.

When deploying the SSIS Package to my local machine's Integration Services File System and the report to my local machine's Report Server database the report executes beautifully (Yes, I'm using the developer edition).

When deploying the package to a W2003 Server Integration Services installation as well as deploying the Report and Data Source to the same W2003 Server's Reporting Services installation - the report fails.

I think it is because the passsword to the SQL Account is not "set". I am able to run the package through BIDS via dtexecui on this W2003 server successfully. However, when I run the report on the server it fails.

I am guessing it is because the password for the SQL Server Authenitcation is not "there". I am encrypting via "Save SensitiveDataWithPasssword".

What am I doing wrong? Any suggestions would be welcome.

View Replies View Related

Parent-child Hierarchy In A SSRS Project Using A SSAS Datasource

Hi everybody,

I would like to know how to create a hierarchy in a SSAS project using a SSRS datasource?

All values are displayed when I drag the field "parent" in the MDX generator...

Thanks in advance for any idea...

View Replies View Related

Programmatically Assigning The Datasource In The Server Report Ssrs 2005

Dear All:

I am new to SSRS 2005.

I have created many shared datsources and reprots at http://localhost/resportserver.

I am trying to access these reports from ReportViewer in the web application. Actually I want to use these reports for different customers by just changing the datsource programitically.

Is this is a possible?

Thank you

View Replies View Related

XML DataSource, Text Dataset And Image From Database Using Visual Studio 2K5 And SSRS 2K5

"Short" Story Version:

I have a VS 2005 Web Appplication solution that uses SQL Server Reporting Services 2005. One of the projects is a Report Server Project. In this project I have an RDL file that has:
1.)a non-shared XML DataSource (no credentials),
2.)a DataSet with a Command Type of Text and a Query String that is as follows:

3.)a field that comes from the Database that is of VarBinary(Max) that is a JPEG Image

What happens is, is that by doing #2 above, at design time I can create tables and hook into my datasets and get the report all designed out the way I want. Then at runtime, I have a Stored Procedure that uses the "FOR XML AUTO" option so that I can represent my results from the database in an XML fashion which will allow me to replace the XML Schema in between the Root tags above (in #2) with my actual data (which still has the same schema). I then save the modified RDL to a database table field and move on to happily ever this case, not. In this case, since an VarBinary is involved, unless I want to get a pointer back for the Diagram Column, I have to use the "FOR XML AUTO, BINARY BASE64" option. This returns an Encoded string to represent the Binary value that was in the Database....and this is the partial source of my on.

My approach that I described above worked flawlessly in all cases where an image wasn't involved. This report is the only report in the whole system I am working on that will have an image and it is the last one being done, so that's why I didn't run into this earlier.

I have tried all kinds of things at different levels, but the thing that I have tried that seemed to me to have the most potential was to use Embedded Code to take the Encoded ASCII Value and convert into something binary that the SSRS Reporting Engine likes (so my image will show), but I have been unsuccessful thus far. The error message I keep getting now from my Embedded Function is: "Invalid length for a Base-64 char array", which I have not been able to resolve thus far....and I do know that the Binary value in the database is good becuase I can see it in pages in my application otherwise.

This aside, is there anyone out there that knows how to take the value of a VarBinary(Max) field and insert it into the Text (XML) DataSet in the markup of an RDL file....and have it appear correctly when the report is rendered in something like the standard Report Viewer Control (or even when being previewed at design time inside of Visual Studio for that matter)?

Just to be clear, the root of my problem, as I see and understand it, is that I have a VarBinary value in a database that is being converted to a string (ASCII...I am presuming) due to how I am writing my stored procedure and then needs to go back to something else binary that the SSRS Engine will accept so that I can see my Image in the report when I render it.

I am wishful that someone out there understands my problem and has run into this and has a solution......but I am wishful of winning the lottery, too, and that hasn't happened yet...............


View Replies View Related

Error In Trying To Create A New Connection.

I'll ask for patience cause am new to this....but I am trying to create a new connection while trying to add a new Data Source in Visual Studios, and I keep getting the error "Login failed for user 'Mohaminho-PCMohaminho'." I have tried several things that my little knowledge knows, but no success.
Any ideas anyone?

View Replies View Related

Error Message When Trying To Create An SQL Connection

Hi,Just recently I am getting the following error when trying to connect to an SQL DB: Exception has been thrown by target of an invocation. This happens even if I create a new website/solution. Procedure I use:open server explorer and click on create a new connectionchoose SQL server from the listenter my IP address and credentials, click on test and everything is fine. When I go to select the DB the dropdown box is empty, if I type in my database name and click on ok I get the following message:Exception has been thrown by target of an invocationI know it is nothing to do with SQL or credentials as I can create a datasource to my SQL server using my colleagues computer!I have removed VS 2005 from my computer and reinstalled only to be met with the same problem.reinstalling my computer is a last resort!Any ideas?Cheers,  Ps, I can connect to my DB using VB code behind.   

View Replies View Related

Cannot Create A Connection To The Data Source Error


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,


View Replies View Related

Cannot Create A Datasource Items

I'm trying to use WSS3 & RS 2005 as Integration Mode.
But i cannot create a data source item on sharepoint site library.

If i go to Central Administration > Configure Reporting Services Integration,

I can see the settings, thats mean that the Report Server is available ( i think so )
And also i can create dataources on Central Administration Web site (//servername:12500)

But from my production server web site ( //servername/ ), i cannot create those items.

I received the message

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

Can somebody help me to fix that strange behavior.


View Replies View Related

How To Create A Datasource Which Is Not Shared

Is it possible to create a datasource, which is not at al shared via vs 2005

View Replies View Related

Client Connection Error While Trying To Create Maintenane Plans

Error:  Ole db error 0x80004005 Client unable to establish connection

This happens when trying to create a maintenance plan in sql 2005 sp 1

It has now happend with 3 installs - one fresh install and two upgrades from 2000 to 2005.  The startup account for sql server is a domain user account and has not been changed.  This happens on both windows 2000 and windows 2003. 


This however does not happen if the sql startup account is in the local admin group for the machine


Any help is greatly appreciated



View Replies View Related

SQL Error On URL -cannot Create New Connection Because In Manual Or Distributed Transaction Mode

We are using a Standard Microsoft Product called Solomon which has aWeb interface.We have installed this in more than 50 sites but we are getting thefollowing error after being in the Web application for a few minutes:'cannot create new connection because in manual or distributedtransaction mode'Could someone provide some help on how we can have a resolution forthis error.Could this be a SQL Server issue or is it a programming issue.Please assistSam CommarJoin Bytes!

View Replies View Related

Unable To Create Datasource In VB 2005 Express

mike writes "Hi
Brand new at SQL and am using VB 2005 express edition with MS SQL 2005 ver 9.00.1116 on windows XP home

Following instructions in the MS free video tutorials lesson 8/9 I created my first database then tried to create a datasource and dataset. The "dataset" appears to create ok but I then get an error message "Could not get type information for ...(mydatabase name) dataset"

I have searched forum and help for some indication why this happens but no luck. Hopefully you maybe able to help.I hope so.Databases are my interest but not skil;led enough to work without an IDE.


View Replies View Related

How To Create Cascading Parameters In A Report With Cube As Datasource

I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in creating a cascading parameter.
The following scenario:
I have a dimension "Period" as Paremeter.
The Period dimension is cascaded to year- quarter- month.
So, I would like to create a cascading parameter for period as year - quarter - month.

Please let me know, how to acheive this.


View Replies View Related

Missing Permission To Create Datasource, New Folder, Add Security..etc

I have windows 2003 reporting services 2005 that has been working fine. Now all of a sudden when I go to http://localhost/reports I am unable to assign security to folders(the link is hidden) the New data source button is hidden, the new folder button is hidden, upload folder and report builder are also hidden. I am logged in as aministrator.

Also when I connect to reporting services through SQL Mgmt Studio I have the same issue, there are no options for permissions only a general option.

I'm sure it's a permissions issue but what do i do to resolve?


View Replies View Related

Nonstop Datasource Connection

Does anyone out there have any ideas on the best way to connect in integration services to a nonstop sql database running on a tandem computer? We have some odbc drivers that have proven to be problematic and slow to use. What oledb products I can find apparently come with something that's around $36K per processor to buy. Thanks.

View Replies View Related

Problem With The Connection To The Datasource

Hi everyone,

I have one problem with my reports. I have one Cube and every week, we process the cube to recalculate the measures.
Before, my report can be displayed with any problem but know, since we process the cube, we can't see the reports based on the cube.
The errors display in the report manager are :
rsProcessingAborted and

When i try to access the report directly from my local project thanks to visual studio, the reports works well.

I think that it may be a problem of rights and abilitations. Or maybe it'a an IIS problem ? Or a firewall problem ?

Thanks for your response.


View Replies View Related

Nonstop Datasource Connection

Hi, the integration services forum recommended that I come over here for this. Here's what I posted there:

Does anyone out there have any ideas on the best way to connect in integration services to a nonstop sql database running on a tandem computer? We have some odbc drivers that have proven to be problematic and slow to use. What oledb products I can find apparently come with something that's around $36K per processor to buy. Thanks.

View Replies View Related

Batch Script To Create ODBC And Update Registry Datasource Key - Help!

I have create a batch file, that creates an ODBC then updates the application datasource key in the registry to the new system dsn name.

The problem is that the new DSN doesn't work when i try and connect the application...but if i had manually created the odbc source the app connects as expected... i have checked the registry and there is no difference between the two dsns created...but the application throws IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified after i have also changed the applications registry key to point to the new database.

Now the interesting things to note are that when i re-create the odbc to the old server and database (sql 2000) by batch file it works fine. The new ODBC is linking to a sql 2005 database, but it is still using the 2000 drivers and when i manually created it, it worked also.

Another interesting thing is that if i go into the odbc dsn and click configure, go through and test the connection it works fine... after i close this i then retry the application and it opens correctly...

I need this to be automated with no manual intervention, as this will be added to a large group of users login scripts!

Any help greatly appreciated.

My batch file code is as below:

ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=RMS Live 2005 | SERVER=d-db99sql2005| Trusted_Connection=Yes | Database=RMS-Livedb"

View Replies View Related

Configuring The Connection (DataSource) Dynamically

Hi All,
I need to write a report which will run based on the user's input for Server Group. Meaning, if the user wants the report to be run for one say, UAT group, the report (and therefore the stored procedure) should be executed against UAT server. Or, if the user wants it to be run on the Production machine, the stored procedure should be executed on the Production Server. Assume that both UAT and Production servers are in the same domain to rule out any authentication issue.

I think one way of doing it is to create a linked server on one server which we use to connect via the Report Manager. So, whatever Server Group is selected based on that the SP will be executed on that respective Server Group's Server, since in the query we will have given full names of the tables that we use.

But, I strongly suspect, that having linked servers will not be accepted since it requires that the server owners maintain that. So, I was thinking if there is any other way of achieving this. If anyone knows, please help me with this.

Thanks a lot and let me know if the question is not clearly stated.


View Replies View Related

Trouble Using ADOX To Create Linked Tables In Jet Database From An ODBC Datasource


I am using ADOX to create linked tables in a jet database from an ODBC datasource.
The tables in the ODBC data source does not have a primary key.
so I am only able to create read only linked tables.But I want to update the records also.
I tried adding a primary key column to the linked table while creating the link.
but I am getting an error while adding the table to the catalog.

The error message is "Invalid Argument".

I use the following code for creating the linked table

Sub CreateLinkedTable(ByVal strTargetDB As String, ByVal strProviderString As String, ByVal strSourceTbl As String, ByVal strLinkTblName As String)

Dim catDB As ADOX.Catalog
Dim tblLink As ADOX._Table

Dim ADOConnection As New ADODB.Connection

ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strTargetDB & ";User Id=admin;Password=;")

catDB = New ADOX.Catalog

catDB.ActiveConnection = ADOConnection

tblLink = New ADOX.Table

With tblLink

' Name the new Table and set its ParentCatalog property
' to the open Catalog to allow access to the Properties
' collection.
.Name = strLinkTblName
.ParentCatalog = catDB

' Set the properties to create the link.
Dim adoxPro As ADOX.Property

adoxPro = .Properties("Jet OLEDB:Create Link")
adoxPro.Value = True

adoxPro = .Properties("Jet OLEDB:Link Provider String")
adoxPro.Value = strProviderString

adoxPro = .Properties("Jet OLEDB:Remote Table Name")
adoxPro.Value = strSourceTbl

End With

'Adding primary key,
'***** the source column name is "Code" ******
tblLink.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "Code")

'Append the table to the Tables collection.
'******The exception occurs on the following line***********

'Append the primary index to table.
catDB = Nothing

End Sub

If I avoid the line for adding the primary key,everything works fine,but the table ctreated is readonly.

Thanks in advance
Sudeep T S

View Replies View Related

How To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder

I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?

View Replies View Related

DTS - Updating DataSource Connection Via ActiveX Script Task


I've written a DTS Package to pull information from a number of servers. I have a list of servers (Source Servers) and for each one I automatically update the Datasource property of the Source Server connection using vbscript in an ActiveX Script task and a global variable.

I have a transformation that occurs between the Source server and Target server.

As I process each Source Server in turn, the global variable gets set correctly and so does the Datasource property of the Source Server connection. However the transformation still runs against the first Source Server that was processed.

Looking at BOL it appears that a transformation stays connected even after it has finished. Therefore I assume that although I change the Datasource of the connection to a new server, it still runs against the first server that was used.

My question is how do I get the connection to run against the updated Datasource, i.e. do I need to do a refresh of the Connection, disconnect or what ?

Any ideas would be much appreciated.


View Replies View Related

New SSRS Install, Works Great Until I Try To Access Oracle Datasource - System.Data.OracleClient Requires Oracle Client Software

re: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software

From my desktop the report accessing an Oracle 9i db with no problem.
I've deployed other reports accesing sql server with no problem.
Now I deploy the report and try to access my Oracle source and get:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
On the server in question, I know they've installed the oracle client. I can access the db from sql plus with no problem.
As the user that I access ssrs credentials, i remote login and am able to write to oracle home.. C:oracleora10gNETWORKADMIN
i've confirmed my database is in tnsnames and it works from sqlplus.

View Replies View Related

Copyrights 2005-15, All rights reserved