Preview error

This is my first report. I used VS.NET 2003 wizard to create the report,
which consisted of a very simple select query report.
When I switch to preview tab in IDE, I am getting the following error.
Processing Errors:
An error has occurred during report processing.
Cannot create a connecttion to data source 'xxx'.
Login failed for user 'yy'
Any ideas of why this is happening? I looked at rdl file in notepad. The
credentials supplied during report creation is not stored in that file.
Please help ASAP.
Thanks,
Live_Love_LaughIf you are using a shared data source, in solution explorer, double click on
the datasource file. Select the credentials tab. The problem is likely here.
If you are using SQL authentication, either enter a password or select the
option to prompt for a password. Let me know if this helps.
"Live_Love_Laugh" wrote:
> This is my first report. I used VS.NET 2003 wizard to create the report,
> which consisted of a very simple select query report.
> When I switch to preview tab in IDE, I am getting the following error.
> Processing Errors:
> An error has occurred during report processing.
> Cannot create a connecttion to data source 'xxx'.
> Login failed for user 'yy'
> Any ideas of why this is happening? I looked at rdl file in notepad. The
> credentials supplied during report creation is not stored in that file.
> Please help ASAP.
> Thanks,
> Live_Love_Laugh
>
>|||I am not using a shared data source. On the data tab, I can see the tables
and my query. But when I switch to preview tab to fetch the data, it is
giving the error. Also on the data tab, I can run the query and see the
results.
Thanks,
Live_Love_Laugh
"vmp_pdx" <vmppdx@.discussions.microsoft.com> wrote in message
news:60D5F30E-F474-4AA3-B6B9-5805A046B898@.microsoft.com...
> If you are using a shared data source, in solution explorer, double click
on
> the datasource file. Select the credentials tab. The problem is likely
here.
> If you are using SQL authentication, either enter a password or select the
> option to prompt for a password. Let me know if this helps.
> "Live_Love_Laugh" wrote:
> > This is my first report. I used VS.NET 2003 wizard to create the report,
> > which consisted of a very simple select query report.
> > When I switch to preview tab in IDE, I am getting the following error.
> >
> > Processing Errors:
> >
> > An error has occurred during report processing.
> > Cannot create a connecttion to data source 'xxx'.
> > Login failed for user 'yy'
> >
> > Any ideas of why this is happening? I looked at rdl file in notepad. The
> > credentials supplied during report creation is not stored in that file.
> >
> > Please help ASAP.
> >
> > Thanks,
> > Live_Love_Laugh
> >
> >
> >|||Can anybody help with this?
Thanks,
Live_Love_Laugh
"Live_Love_Laugh" <OnlineSubscribe@.yahoo.com> wrote in message
news:%23NTAPMvpEHA.2588@.TK2MSFTNGP12.phx.gbl...
> I am not using a shared data source. On the data tab, I can see the tables
> and my query. But when I switch to preview tab to fetch the data, it is
> giving the error. Also on the data tab, I can run the query and see the
> results.
> Thanks,
> Live_Love_Laugh
> "vmp_pdx" <vmppdx@.discussions.microsoft.com> wrote in message
> news:60D5F30E-F474-4AA3-B6B9-5805A046B898@.microsoft.com...
> > If you are using a shared data source, in solution explorer, double
click
> on
> > the datasource file. Select the credentials tab. The problem is likely
> here.
> > If you are using SQL authentication, either enter a password or select
the
> > option to prompt for a password. Let me know if this helps.
> >
> > "Live_Love_Laugh" wrote:
> >
> > > This is my first report. I used VS.NET 2003 wizard to create the
report,
> > > which consisted of a very simple select query report.
> > > When I switch to preview tab in IDE, I am getting the following error.
> > >
> > > Processing Errors:
> > >
> > > An error has occurred during report processing.
> > > Cannot create a connecttion to data source 'xxx'.
> > > Login failed for user 'yy'
> > >
> > > Any ideas of why this is happening? I looked at rdl file in notepad.
The
> > > credentials supplied during report creation is not stored in that
file.
> > >
> > > Please help ASAP.
> > >
> > > Thanks,
> > > Live_Love_Laugh
> > >
> > >
> > >
>|||Could you email to me your RDL?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Live_Love_Laugh" <OnlineSubscribe@.yahoo.com> wrote in message
news:OZEmZy$pEHA.2900@.TK2MSFTNGP12.phx.gbl...
> Can anybody help with this?
> Thanks,
> Live_Love_Laugh
> "Live_Love_Laugh" <OnlineSubscribe@.yahoo.com> wrote in message
> news:%23NTAPMvpEHA.2588@.TK2MSFTNGP12.phx.gbl...
>> I am not using a shared data source. On the data tab, I can see the
>> tables
>> and my query. But when I switch to preview tab to fetch the data, it is
>> giving the error. Also on the data tab, I can run the query and see the
>> results.
>> Thanks,
>> Live_Love_Laugh
>> "vmp_pdx" <vmppdx@.discussions.microsoft.com> wrote in message
>> news:60D5F30E-F474-4AA3-B6B9-5805A046B898@.microsoft.com...
>> > If you are using a shared data source, in solution explorer, double
> click
>> on
>> > the datasource file. Select the credentials tab. The problem is likely
>> here.
>> > If you are using SQL authentication, either enter a password or select
> the
>> > option to prompt for a password. Let me know if this helps.
>> >
>> > "Live_Love_Laugh" wrote:
>> >
>> > > This is my first report. I used VS.NET 2003 wizard to create the
> report,
>> > > which consisted of a very simple select query report.
>> > > When I switch to preview tab in IDE, I am getting the following
>> > > error.
>> > >
>> > > Processing Errors:
>> > >
>> > > An error has occurred during report processing.
>> > > Cannot create a connecttion to data source 'xxx'.
>> > > Login failed for user 'yy'
>> > >
>> > > Any ideas of why this is happening? I looked at rdl file in notepad.
> The
>> > > credentials supplied during report creation is not stored in that
> file.
>> > >
>> > > Please help ASAP.
>> > >
>> > > Thanks,
>> > > Live_Love_Laugh
>> > >
>> > >
>> > >
>>
>