"Jon Jahren" <jon.jahren.fightspam@sqlkompetanse.no> wrote in message
news:uzkq#1JyEHA.2676@TK2MSFTNGP12.phx.gbl...
> Sergio,
> In your data source, check for "allow saving password". You should also
> consider using windows authentication instead.
>
> Jon Jahren
>
> "Sergio Florez M." <sergioflorezm @ hotmail.com> wrote in message
> news:OcSs0hDyEHA.3804@TK2MSFTNGP10.phx.gbl...
> > I created a very simple report just to see how Reporting Services works
> adn
> > it shows all the data just fine in the preview inside Visual Studio but
> whe
> > I run the report it shows me this error:
> >
> > Reporting Services Error
>
> --------------------------------------------------------------------------
> --
> > ----
> >
> > a.. An error has occurred during report processing.
> (rsProcessingAborted)
> > Get Online Help
> > a.. Cannot create a connection to data source 'Northwind'.
> > (rsErrorOpeningConnection) Get Online Help
> > a.. Login failed for user 'sa'.
> >
>
> --------------------------------------------------------------------------
> --
> > ----
> > Microsoft Reporting Services
> >
> > Isn't this weird? I mean, I'm working with a shared data source which
> > connects properly when I test it and the data gets shwon on the preview
so
> > why doesn't it work?.
> >
> > --
> > Sergio Florez M.
> > Medellin, Colombia
> >
> >
>
>

"Sergio Florez M." <sergioflorezm @ hotmail.com> wrote in message
news:OcSs0hDyEHA.3804@TK2MSFTNGP10.phx.gbl...
> I created a very simple report just to see how Reporting Services works
adn
> it shows all the data just fine in the preview inside Visual Studio but
whe
> I run the report it shows me this error:
>
> Reporting Services Error
> --------------------------------------------------------------------------
--
> ----
>
> a.. An error has occurred during report processing.
(rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Northwind'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Login failed for user 'sa'.
>
> --------------------------------------------------------------------------
--
> ----
> Microsoft Reporting Services
>
> Isn't this weird? I mean, I'm working with a shared data source which
> connects properly when I test it and the data gets shwon on the preview so
> why doesn't it work?.
>
> --
> Sergio Florez M.
> Medellin, Colombia
>
>