"SharinDenver" <SharinDenver@discussions.microsoft.com> wrote in message
news:B31CB016-2132-4472-93D1-34FB72685E4F@microsoft.com...
>I am using SQL Server 2000 and VS.net 2003 with Reporting Services. I have
> deployed several reports.
>
> I am trying to open a report to edit it. When I click on the data tab, I
> get the following error:
>
> A connection cannot be made to the database.
> Set and test the connection string.
> Login failed for user 'null'. Reson: not associated with a trusted SQL
> Server connection.
>
> I can open a different report and it works fine. I am connecting to the
> exact same db with the exact same credentials. I am using the "use a
> specific username and password" option and using a read only account
> created
> in SQL Server. I can test the connection and it says it connects
> successfully.
>
> What is going on? It is so random. Of all my reports, some have this
> problem and then others don't and they are all using the same connection.
> What can I do to edit this report?

"Kaisa M. Lindahl" wrote:

> Are the problem reports connected to more than one Database connection?
> If I need to connect to two different databases in one report, I have
> problems with the connection. All dataconnections to SQL Servers seems to
> use the same credentials... So if I want to connect to database1 with user1
> and database2 with user2, I will end up trying to connect to both database1
> and database2 with the credentials for user2. Off course this can cause
> problems. I don't know why, and ususally I end up trying to either use the
> same connection, or have a read only user with the same credentials in both
> databases. (Not very secure.)
>
> Kaisa M. Lindahl Lervik
>
>
> "SharinDenver" <SharinDenver@discussions.microsoft.com> wrote in message
> news:B31CB016-2132-4472-93D1-34FB72685E4F@microsoft.com...
> >I am using SQL Server 2000 and VS.net 2003 with Reporting Services. I have
> > deployed several reports.
> >
> > I am trying to open a report to edit it. When I click on the data tab, I
> > get the following error:
> >
> > A connection cannot be made to the database.
> > Set and test the connection string.
> > Login failed for user 'null'. Reson: not associated with a trusted SQL
> > Server connection.
> >
> > I can open a different report and it works fine. I am connecting to the
> > exact same db with the exact same credentials. I am using the "use a
> > specific username and password" option and using a read only account
> > created
> > in SQL Server. I can test the connection and it says it connects
> > successfully.
> >
> > What is going on? It is so random. Of all my reports, some have this
> > problem and then others don't and they are all using the same connection.
> > What can I do to edit this report?
>
>