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

Error message question..

I am getting the error message
Procedure or function sp_MSaddinitialarticle has too many arguments specified. The step failed.
Please help me resolve this issue (The knowledge base did not have any relevent information).
Thank you for a quick response,
Carl
You are trying to put more arguments to a
procedure or funtion than it needs.
for example: (psuedo code)
sp_myproc @.A, @.B, @.C
and then you
EXEC sp_myproc 1, 2, 3, 4
would get you the error because you
have too many arguments (4) for the
procedure (3)
Bob M.
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:AB31BB38-3C7A-4772-93C4-6E453ACC3C63@.microsoft.com...
> I am getting the error message
> Procedure or function sp_MSaddinitialarticle has too many arguments
specified. The step failed.
> Please help me resolve this issue (The knowledge base did not have any
relevent information).
> Thank you for a quick response,
> Carl
|||Carl,
Whats the SQLServer edition and service pack?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:AB31BB38-3C7A-4772-93C4-6E453ACC3C63@.microsoft.com...
> I am getting the error message
> Procedure or function sp_MSaddinitialarticle has too many arguments
specified. The step failed.
> Please help me resolve this issue (The knowledge base did not have any
relevent information).
> Thank you for a quick response,
> Carl

Error message question..

I am getting the error message
Procedure or function sp_MSaddinitialarticle has too many arguments specifie
d. The step failed.
Please help me resolve this issue (The knowledge base did not have any relev
ent information).
Thank you for a quick response,
CarlYou are trying to put more arguments to a
procedure or funtion than it needs.
for example: (psuedo code)
sp_myproc @.A, @.B, @.C
and then you
EXEC sp_myproc 1, 2, 3, 4
would get you the error because you
have too many arguments (4) for the
procedure (3)
Bob M.
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:AB31BB38-3C7A-4772-93C4-6E453ACC3C63@.microsoft.com...
> I am getting the error message
> Procedure or function sp_MSaddinitialarticle has too many arguments
specified. The step failed.
> Please help me resolve this issue (The knowledge base did not have any
relevent information).
> Thank you for a quick response,
> Carl|||Carl,
Whats the SQLServer edition and service pack?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:AB31BB38-3C7A-4772-93C4-6E453ACC3C63@.microsoft.com...
> I am getting the error message
> Procedure or function sp_MSaddinitialarticle has too many arguments
specified. The step failed.
> Please help me resolve this issue (The knowledge base did not have any
relevent information).
> Thank you for a quick response,
> Carl

Error Message Question..

Inserting is not supported by data source 'SqlDataSource1' unless InsertCommand is specified.

got this error message while inseting data in my database...how can i solve this?...can anybody explain how can i solve this problem...and im sorry but i cant understand the codes thoroughly..please explain briefly...thank u...

You have some control (presentation control) which is using SqlDataSource1 as source of data.

However, when your presentation control try to insert some data, it fails, because you did not specify which command to use when inserting data.

You need to complete definition of SqlDataSource1 or Adapter by specifyingInsertCommand

Error message question..

I am getting the error message
Procedure or function sp_MSaddinitialarticle has too many arguments specified. The step failed.
Please help me resolve this issue (The knowledge base did not have any relevent information).
Thank you for a quick response,
CarlYou are trying to put more arguments to a
procedure or funtion than it needs.
for example: (psuedo code)
sp_myproc @.A, @.B, @.C
and then you
EXEC sp_myproc 1, 2, 3, 4
would get you the error because you
have too many arguments (4) for the
procedure (3)
Bob M.
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:AB31BB38-3C7A-4772-93C4-6E453ACC3C63@.microsoft.com...
> I am getting the error message
> Procedure or function sp_MSaddinitialarticle has too many arguments
specified. The step failed.
> Please help me resolve this issue (The knowledge base did not have any
relevent information).
> Thank you for a quick response,
> Carl|||Carl,
Whats the SQLServer edition and service pack?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Carl" <Carl@.discussions.microsoft.com> wrote in message
news:AB31BB38-3C7A-4772-93C4-6E453ACC3C63@.microsoft.com...
> I am getting the error message
> Procedure or function sp_MSaddinitialarticle has too many arguments
specified. The step failed.
> Please help me resolve this issue (The knowledge base did not have any
relevent information).
> Thank you for a quick response,
> Carl