Report Credentials Problem

Hi Everyone,
This problem is tying me in knots and I'd be very grateful for some help.
I am to set up my reports to query a database for their datasources rather
than using shared datasources. I am now able to retrieve the connection
string perfectly well with this method. The trouble I have is that I still
need to supply credentials for the database separately.
http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
In the above MSDN section under "no credentials" tells me that I can include
my credentials as part of the connection string, and select the "no
credentials" option. This is exactly what I am trying to do, but I get the
error:
a.. 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)
The connection string that I am using is in the format:
Server={my server};Database={my database};User ID={my user};Password={my
password};Trusted_Connection=False
Can anyone tell me why the report server appears to be ignoring the username
and password supplied in the connection string?
I am using SSRS 2005 connecting to a SQL Server 2000 database.
Many thanks,
Ed AllisonDid you configure the Unattended Execution Account?
See: http://msdn2.microsoft.com/en-us/library/ms181156(SQL.90).aspx
I believe this needs to be done before the No Credentials option can be
used.
Dave
Ed Allison wrote:
> Hi Everyone,
> This problem is tying me in knots and I'd be very grateful for some help.
> I am to set up my reports to query a database for their datasources rather
> than using shared datasources. I am now able to retrieve the connection
> string perfectly well with this method. The trouble I have is that I still
> need to supply credentials for the database separately.
> http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
> In the above MSDN section under "no credentials" tells me that I can include
> my credentials as part of the connection string, and select the "no
> credentials" option. This is exactly what I am trying to do, but I get the
> error:
> a.. 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)
> The connection string that I am using is in the format:
> Server={my server};Database={my database};User ID={my user};Password={my
> password};Trusted_Connection=False
> Can anyone tell me why the report server appears to be ignoring the username
> and password supplied in the connection string?
> I am using SSRS 2005 connecting to a SQL Server 2000 database.
> Many thanks,
> Ed Allison|||Well,
The first thing that caught my eye is the fact that your using RS 2005
to access MS SQL 2000 DB. IT could be that article is for 2000=>2000
and 20005=>2005. THis could be a unique case where the DB's cant
access one another for credential information.
What you could do is set up the RS DB with the same credentials as in
the 2000 DB. Meaning copy the credentials instead of using them.
Although, I wouldn't recommend on doing so since you'll need to make a
credential change in two locations.
This is a good question though and would be glad to get an answer for
it myself.
regards,
Stas K.|||Thanks for your reply, Dave. I'll look into that.
"SleepyLab" <david.blancard@.fairmont.com> wrote in message
news:1143900841.325395.80120@.t31g2000cwb.googlegroups.com...
> Did you configure the Unattended Execution Account?
> See: http://msdn2.microsoft.com/en-us/library/ms181156(SQL.90).aspx
> I believe this needs to be done before the No Credentials option can be
> used.
> Dave
>
> Ed Allison wrote:
>> Hi Everyone,
>> This problem is tying me in knots and I'd be very grateful for some help.
>> I am to set up my reports to query a database for their datasources
>> rather
>> than using shared datasources. I am now able to retrieve the connection
>> string perfectly well with this method. The trouble I have is that I
>> still
>> need to supply credentials for the database separately.
>> http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
>> In the above MSDN section under "no credentials" tells me that I can
>> include
>> my credentials as part of the connection string, and select the "no
>> credentials" option. This is exactly what I am trying to do, but I get
>> the
>> error:
>> a.. 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)
>> The connection string that I am using is in the format:
>> Server={my server};Database={my database};User ID={my user};Password={my
>> password};Trusted_Connection=False
>> Can anyone tell me why the report server appears to be ignoring the
>> username
>> and password supplied in the connection string?
>> I am using SSRS 2005 connecting to a SQL Server 2000 database.
>> Many thanks,
>> Ed Allison
>sql