Showing posts with label external. Show all posts
Showing posts with label external. Show all posts

Tuesday, March 27, 2012

Error processing a report connecting to an external SQL db

I created a report that uses data from an external SQL Server database. I
specified Windows Authentication. My NT account has full rights on the
external SQL server. When I run a report with ''localhost'' in the URL, it
works fine. However, when I use the actual server name, it first prompts me
for NT login/password (which is fine), but then I get the following:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection do data source 'MyDataSource'.
(rsErrorOpeningConnection)
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
My assumption after reading MS docs was that the Reporting Server would use
the current user's credentials to connect to the external data source, but
it's not happening.
Any ideas on how to fix this would be highly appreciated.
Thanks,
LeoHi Leo,
Did you find a solution to this? I have the same problem. Are running
Reporting Services/SQL Server 2005 and can not run reports which get data
from an external SQL Server 2000.
Thanks,
Soren
"LeoW" wrote:
> I created a report that uses data from an external SQL Server database. I
> specified Windows Authentication. My NT account has full rights on the
> external SQL server. When I run a report with ''localhost'' in the URL, it
> works fine. However, when I use the actual server name, it first prompts me
> for NT login/password (which is fine), but then I get the following:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection do data source 'MyDataSource'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> My assumption after reading MS docs was that the Reporting Server would use
> the current user's credentials to connect to the external data source, but
> it's not happening.
> Any ideas on how to fix this would be highly appreciated.
> Thanks,
> Leo|||Any answer on this? I am having this problem as well. I am still just
running 2000 though. I am able to open and connect with several other
reports. But I have one that is not connecting and getting this error when I
click on the data tab. When I create the data source and test the
connection, it says it connects successfully.
Please someone answer this questions!!!!!!!!!!!!! :)
"LeoW" wrote:
> I created a report that uses data from an external SQL Server database. I
> specified Windows Authentication. My NT account has full rights on the
> external SQL server. When I run a report with ''localhost'' in the URL, it
> works fine. However, when I use the actual server name, it first prompts me
> for NT login/password (which is fine), but then I get the following:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection do data source 'MyDataSource'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> My assumption after reading MS docs was that the Reporting Server would use
> the current user's credentials to connect to the external data source, but
> it's not happening.
> Any ideas on how to fix this would be highly appreciated.
> Thanks,
> Leo|||+1. I am hitting the same issue as well. Does any one have a solution for this?
Thanks
Sushmitha
"SharinDenver" wrote:
> Any answer on this? I am having this problem as well. I am still just
> running 2000 though. I am able to open and connect with several other
> reports. But I have one that is not connecting and getting this error when I
> click on the data tab. When I create the data source and test the
> connection, it says it connects successfully.
> Please someone answer this questions!!!!!!!!!!!!! :)
> "LeoW" wrote:
> > I created a report that uses data from an external SQL Server database. I
> > specified Windows Authentication. My NT account has full rights on the
> > external SQL server. When I run a report with ''localhost'' in the URL, it
> > works fine. However, when I use the actual server name, it first prompts me
> > for NT login/password (which is fine), but then I get the following:
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot create a connection do data source 'MyDataSource'.
> > (rsErrorOpeningConnection)
> > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> > My assumption after reading MS docs was that the Reporting Server would use
> > the current user's credentials to connect to the external data source, but
> > it's not happening.
> >
> > Any ideas on how to fix this would be highly appreciated.
> >
> > Thanks,
> > Leo|||Was this ever resolved? I see that the last post was posted a few months ago.
I am looking for a soltuion to the following:
Server A is the Web, SQL, and RS Server (2k all around). No issues with
reports.
Server B is a 2nd SQL box (2k as well.)
I create a report in VS 2k03 and can preview it no problem using a shared
data source with stored credentials.
When i deploy the report and try to generate it via Report Mgr, I get
"Cannot create a connection to data source..."
Any hints?
Much appreciated.
"Sushmitha Kini" wrote:
> +1. I am hitting the same issue as well. Does any one have a solution for this?
> Thanks
> Sushmitha
> "SharinDenver" wrote:
> > Any answer on this? I am having this problem as well. I am still just
> > running 2000 though. I am able to open and connect with several other
> > reports. But I have one that is not connecting and getting this error when I
> > click on the data tab. When I create the data source and test the
> > connection, it says it connects successfully.
> >
> > Please someone answer this questions!!!!!!!!!!!!! :)
> >
> > "LeoW" wrote:
> >
> > > I created a report that uses data from an external SQL Server database. I
> > > specified Windows Authentication. My NT account has full rights on the
> > > external SQL server. When I run a report with ''localhost'' in the URL, it
> > > works fine. However, when I use the actual server name, it first prompts me
> > > for NT login/password (which is fine), but then I get the following:
> > > An error has occurred during report processing. (rsProcessingAborted)
> > > Cannot create a connection do data source 'MyDataSource'.
> > > (rsErrorOpeningConnection)
> > > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > > Server connection.
> > >
> > > My assumption after reading MS docs was that the Reporting Server would use
> > > the current user's credentials to connect to the external data source, but
> > > it's not happening.
> > >
> > > Any ideas on how to fix this would be highly appreciated.
> > >
> > > Thanks,
> > > Leo

Monday, March 12, 2012

Error of Microsoft OLE DB Provider for SQL Server

Hi All:

I have a ASP page which use external DLL load data from SQL 2000 server, but it keeps give me error as following:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Microsoft OLE DB Provider for SQL Server (0x8004000)

the line cause the error is as:

<%

dim newRS

dim visiter = Server.CreateObject("ExternalDLL.visit")

newRS = visiter.enews.getENews

%>

visit and enews are all class file inside ExternalDLL.

any body can help me out what's wrong with my page? the external DLL and sqloledb.dll are both registed on the machine.

Your help is great appreciate

Regards

Echo

Echo,

"Microsoft OLE DB Provider for SQL Server (0x8004000)" is related to the forum. However, for ASP related issue, you might want to check ASP forum as well.

|||

Hi !

As another poster said, this is defintely not a SQL Server related problem. You are loading an external DLL which does some SQL stuff and which has probably a bug inside or is not configured probably. So ask the vendor how to trace or how to configure this the right way. If you have no support, you can go the long way, tracking the users which try to login to SQL Server (if the server is configured the right way for this application) and see what statement are executed for the server. As I said thats the long way using the profiler. :-(

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

Friday, February 24, 2012

Error Message requires explanation please

Hi
I am a basic user and need to know what this error message means
10025 Write to SQL Server faile
The database that I was using (external application has data hosted to SQL Server 2000) was idle at the time. I understand that this could be a network problem. Is it something as simple as a timeout issue, and if so, how do I rectify this
This message was also displayed
Context: SQLOptLockErrPara
dbo.CA
What does this mean? If anyone could give me an example of why this happens I would really appreciate it
Thank
ShnibniHi!
Do please check if the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;109787 helps you.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Shnibnib" <anonymous@.discussions.microsoft.com> wrote in message
news:52137B66-4562-4EE9-A579-65E6346ED76F@.microsoft.com...
> Hi,
> I am a basic user and need to know what this error message means:
> 10025 Write to SQL Server failed
> The database that I was using (external application has data hosted to SQL
Server 2000) was idle at the time. I understand that this could be a
network problem. Is it something as simple as a timeout issue, and if so,
how do I rectify this?
> This message was also displayed:
> Context: SQLOptLockErrParam
> dbo.CAL
> What does this mean? If anyone could give me an example of why this
happens I would really appreciate it.
> Thanks
> Shnibnib
>

Error Message requires explanation please

Hi,
I am a basic user and need to know what this error message means:
10025 Write to SQL Server failed
The database that I was using (external application has data hosted to SQL S
erver 2000) was idle at the time. I understand that this could be a network
problem. Is it something as simple as a timeout issue, and if so, how do I
rectify this?
This message was also displayed:
Context: SQLOptLockErrParam
dbo.CAL
What does this mean? If anyone could give me an example of why this happens
I would really appreciate it.
Thanks
ShnibnibHi!
Do please check if the article at
http://support.microsoft.com/defaul...kb;en-us;109787 helps you.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Shnibnib" <anonymous@.discussions.microsoft.com> wrote in message
news:52137B66-4562-4EE9-A579-65E6346ED76F@.microsoft.com...
> Hi,
> I am a basic user and need to know what this error message means:
> 10025 Write to SQL Server failed
> The database that I was using (external application has data hosted to SQL
Server 2000) was idle at the time. I understand that this could be a
network problem. Is it something as simple as a timeout issue, and if so,
how do I rectify this?
> This message was also displayed:
> Context: SQLOptLockErrParam
> dbo.CAL
> What does this mean? If anyone could give me an example of why this
happens I would really appreciate it.
> Thanks
> Shnibnib
>