sql server reporting services: Hi,

My client requires to use SQL server authentication instead of windows
authentication while running reports.

While report is running OK in Visual Studio and on the intranet it
fails on the intranet when I come to work in the next morning. This is
the situation which I observed several times:
OK in the evening, failure in the morning (""SQL Server does not exist
or access denied").

I'm using Reporting Services for 2K and making no reboots.

Stan

How do you remedy the problem? I would look at that and maybe that will
indicate further what exactly is going on.

--
Ben Sullins
http://bensullins.com

Not yet. In fact, I come in the moning and intranet reports with SQL
server authentication fail. Then I run report in Visual Studio - Ok.
Now report runs OK on intranet. Weird ...

Stan