I am evaluating MS SQL Server Reporting Services and during the process, I
encountered issues pertaining to connectivity with Informix Database.
I want to design a report by retrieving data from Informix
database. I have a code that generates the .RDL file (which is in XML
format). When I deploy the .RDL file on the server, it does so successfully.
But when I try to view it through the IE 6.0 its gives me an error -
An attempt has been made to use a data extension '****' that is not
registered for this report server. (rsDataExtensionNotFound)
How could I solve this problem ?
Hi
The account that is running the Reporting Server Service, does it have
permission to access the Informix database?
Is the Informix driver installed on the server? Have you checked
connectivity from the Web Server to the DB?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Skeptic45" <Skeptic45@.discussions.microsoft.com> wrote in message
news:AD68D8B3-0B49-488F-B09A-D41D129E6344@.microsoft.com...
> I am evaluating MS SQL Server Reporting Services and during the process, I
> encountered issues pertaining to connectivity with Informix Database.
> I want to design a report by retrieving data from Informix
> database. I have a code that generates the .RDL file (which is in XML
> format). When I deploy the .RDL file on the server, it does so
> successfully.
> But when I try to view it through the IE 6.0 its gives me an error -
> An attempt has been made to use a data extension '****' that is not
> registered for this report server. (rsDataExtensionNotFound)
> How could I solve this problem ?
>
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Sunday, March 25, 2012
Thursday, March 8, 2012
Connection to Reporting Server problem
Has anybody seen this? I have been pulling my hair out trying to figure this out. I hav enot made any changes to the Report Server and now all of a sudden this is happening. Thanks for any information.
TITLE: Connect to Server
----------
Cannot connect to UKCINT\UKCAZOSQL.
----------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.2047.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
----------
BUTTONS:
OK
----------
Really a tough issue. If you're using IIS6.0, please change the "Run WWW web service as IIS5 Isolation Mode" option (can be found in Services tab, Properties of Websites) and try again.
If it doesn't work, check your SQL version. You'd better upgrade to sp3 version if the version is eariler than sp3. SQL 2000 SP3a can be downloaded here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en
And here is a KB that may help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;821268#appliesto
|||Unfortunately I am using IIS 5.1. And I have SQL Server 2005.
Connection to Oracle
I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.
Reports off the SQL Server Data Sources arerunning fine.
Can any one out there help me out on this. I will really appreaciate.
Regards,
Sam.
Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668
-- Robert
|||Hi Robert,
Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.
|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||
It seems Permissions were my problem.
I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem
Thanks for all the Advise.
|||Hi there,
I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:
I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.
But same error, will not connect to the Oracle data source.
Connection to Oracle
I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.
Reports off the SQL Server Data Sources arerunning fine.
Can any one out there help me out on this. I will really appreaciate.
Regards,
Sam.
Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668
-- Robert
|||Hi Robert,
Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.
|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||
It seems Permissions were my problem.
I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem
Thanks for all the Advise.
|||Hi there,
I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:
I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.
But same error, will not connect to the Oracle data source.
Connection to Oracle
I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.
Reports off the SQL Server Data Sources arerunning fine.
Can any one out there help me out on this. I will really appreaciate.
Regards,
Sam.
Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668
-- Robert
|||Hi Robert,
Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.
|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||
It seems Permissions were my problem.
I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem
Thanks for all the Advise.
|||Hi there,
I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:
I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.
But same error, will not connect to the Oracle data source.
Connection to Oracle
I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.
Reports off the SQL Server Data Sources arerunning fine.
Can any one out there help me out on this. I will really appreaciate.
Regards,
Sam.
Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668
-- Robert
|||Hi Robert,
Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.
|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||
It seems Permissions were my problem.
I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem
Thanks for all the Advise.
|||Hi there,
I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:
I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.
But same error, will not connect to the Oracle data source.
Sunday, February 19, 2012
Connection string for reporting model
Hi,
I've just created a reporting model to use with my reports.
I have deployed the model to my localhost reporting server.
The name of my model is : mod_agentreporting
Can someone give me the right connection string that i have to use ?
Is there any advantage for using reporting models as datasources for reports
or a shared data sources ?
Thanks already in advance for your remarks.
Vincent
http://msdn2.microsoft.com/en-us/library/ms345238.aspx
btw, that's the top result you get by googling:
site:msdn2.microsoft.com +"report model" +"connection string"
Connection string and external web host.
Hey guys, I'm havnig a bit of trouble setting up my sql reporting tools. My webhost's technical support either does not know what they're doing or might just not care. They 've been unelpful so I'm resorting to asking a stupid noob question again. I hope you guys can help me out.
On my home pc, all i woul have to input is
Data Source=mycomputername\sqlexpress;AttachDbFilename=c:\document and settings\administrator\mydocuments\test8_data1.mdf;Initial Catalog=test
and it would work.
However, when I upload thist stuff to my host and in their admin pages I entered various strings and none of them work.
For the data source I've tried :
Data Source = ./sqlexpress
data source = server ip
data source = server ip/sqlexpress
data source = sqlexpress
as for attachdbfilename I've tried
|datadirectory|\test8_data1.mdf
full path to test8_data1.mdf
and just test8_data1.mdf
In addition to that, in order for this to work, do I need to both input the connection string on the server as well as the .RDL file I upload? I assume both settngs need to be identical for it to work.
Unfortruantely after trying all this,
"An error has occurred during report processing.
Cannot create a connection to data source 'test'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors "
1) Chane hosting company :) Try CrystalTech, Webhost4life - both have great support and will always help you solve problems like that
2) You will find all info about connection strings here
http://www.connectionstrings.com/
3) What you have is database file (from sql express) - most hosting companies DO NOT support it, but they should offer some tools to copy it/attach it to full SQL server. Or you can create backup and ask them to restore it for you - after that go to website i gave you and it will work :)
|||the irony, I use webhost4life.
I sent over 5 helpdesk tickets about what would go into datasource, and I got answers such as, you can input that in the report manager. which wasn't the question.
On my computer I have the computer name so I can easily just do servername\sqlexpress, but i've tried everythign and it won't work on their server.
As for item 3, I did use sqlexpress for my .mdf file , created a backup and restored it into webhost4life's sql server. So that isn't an issue.
|||With Webhost4life
- login to your acc.
- go to "database" top menu
- click on "MSSQL Admin" left menu
- and you should see all your SQL databases there wit the IP and login ingo you should use to connect to it
Your connections string will look like that
connectionString="Data Source='sql332.mysite4now.com';User ID='USER_HERE';Password=PASSWORD_HERE;database='DATABASENAME_HERE'"
change sql332.mysite4now.com to your sql server
and that is it
|||hey tom thanks very much. Still having some issues, if you don't mind I'd like to request some more advice.
1) My current status is, went into sqlreport01.mysite4now.com/reports... and created a data source and used that as a shared data source and also inputed the info for my .rdl file
i've also, tried just deleting the shared data source and used a custom datasource and my .rdl report file.
currently its listed as.
"Data Sources="Data Source='sql380.mysite4now.com';User ID=' my username ';Password=' my password ';database='bkt_data.mdf'""
on the site,
and
<DataSource Name="test">
<ConnectionProperties>
<IntegratedSecurity>true</IntegratedSecurity>
<ConnectString>Data Sources="Data Source='sql380.mysite4now.com';User ID=' my username ';Password=' my password ';database='bkt_data.mdf'";</ConnectString> <DataProvider>SQL</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>df397291-cd99-460b-9468-1324b2143105</rd:DataSourceID>
</DataSource>
</DataSources>
in the .rdl file
I've tried both ways and they both don't seem to work.
bkt_data is a sql2005 database that i created from their site.
So now after trying your advice, I realized that the message
"
can you access your database from EM ?
|||I actually don't have EM i beleive. I'm assuming that comes with sql server. I only have express edition. However like i stated, the database itself was loaded into a sqlserver database from the control panel. Do i need eM?
|||scratchthat, microsoft has an web version of smoethign similair to em and I'm using it. It works, I can connect to the database. so then I wonder what the problem is.|||ok and what is the database name there ?|||now i'm not even sure what you are using database file in app_data folder ? or you uploaded db from backup ?
if file in app_data folder read this :
http://www.webhost4life.com/kb/question.php?qstId=153
|||my db name is bkt and its the same from the tool as well as the database tab in the control panel.
also, I restored db from backup.
|||it is late :)
anyway if your database name is "bkt" why are you using "'bkt_data.mdf'" as a database name in connection ???
"Data Sources="Data Source='sql380.mysite4now.com';User ID=' my username ';Password=' my password ';database='bkt_data.mdf'""
|||my apologies. My database is named bkt, but the file name that webhost4life gave it is bkt_data.mdfI'm gonna try it again later today and see if it works. thanks for all your help. I really appreciate it.|||
I misread what you had wrote up there so here is the revised script in my rdl file. I noticed it automatically makes a custom data source on the report manager side.
<ConnectString>connectionString="Data Source='sql380.mysite4now.com';User ID='user';Password='password';database='bkt'";</ConnectString>
still does not seem to work. Is there a simple way to test if the report manager can even access sql380.mysite4now.com?
|||Hey tom, got it to work. Thanks for all your help. I usually print out my reports with .16 margins all around, but there no setting for that here. Is that something I can input into the .rdl files?
Subscribe to:
Posts (Atom)