reg Caching Configuration

Hi ,
I am trying to configure the Caching in Reporting Services. I came to know
that i have to store the credentials in the Report server. After storing the
credentitals in the report server using Datasource properties and i tried to
acess the report. i am getting following error.
â?¢ â'An error has occurred during report processing.
o Cannot create a connection to data source '<datasourcename>'.
Login failed for user '<user>'. The user is not associated with a trusted
SQL Server connection.
Is there anything I am missing here.
Thanks in advance
BhaskarBhaskar
I would suggest that sql server is rejecting the user name you are
using . Try to create a connection by using the connection wizard
which will allow you to test the connection. In visual studio right
click on shared datas sources and click on add new data source . In
the dialog box, instead of typing your connection string , click edit
try specifying sql server authentication. Click on test connection. if
that works , try using the connection to execute a query or stored
proc by creating a new data set .
Cheers
Shai
On Nov 20, 8:03 am, Bhaskar <Bhas...@.discussions.microsoft.com>
wrote:
> Hi ,
> I am trying to configure the Caching in Reporting Services. I came to know
> that i have to store the credentials in the Report server. After storing the
> credentitals in the report server using Datasource properties and i tried to
> acess the report. i am getting following error.
> * 'An error has occurred during report processing.
> o Cannot create a connection to data source '<datasourcename>'.
> Login failed for user '<user>'. The user is not associated with a trusted
> SQL Server connection.
> Is there anything I am missing here.
> Thanks in advance
> Bhaskar|||On Nov 19, 5:03 pm, Bhaskar <Bhas...@.discussions.microsoft.com> wrote:
> Hi ,
> I am trying to configure the Caching in Reporting Services. I came to know
> that i have to store the credentials in the Report server. After storing the
> credentitals in the report server using Datasource properties and i tried to
> acess the report. i am getting following error.
> * 'An error has occurred during report processing.
> o Cannot create a connection to data source '<datasourcename>'.
> Login failed for user '<user>'. The user is not associated with a trusted
> SQL Server connection.
> Is there anything I am missing here.
> Thanks in advance
> Bhaskar
Bhaskar,
Any time you see the word "Trusted" in an error messege it means you
have the database set to Windows Authentication only and you are
passing a User ID and Password in your connection. Either
1) Change the connection to Windows Authentication which will not
prompt for credentials OR
2) Right click on your SQL Server, not the database but the server,
and go to Properties -> Security; then change to SQL Server and
Windows Authenication mode.
Dennis