Cannot create a connection to data source

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, ColombiaSergio,
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
>|||I changed the connection settings in the report manager and now it works
fine. Now I have the same problem in a report that I created without a
shared data source and I can't find how to allow saving password.
Changing to Windows authentication isn't the kind of solution I'm looking
for as it should work just fine either way.
--
Sergio Florez M.
Medellin, Colombia
"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
> >
> >
>