Double check your connection string that you use to connect to your database server (local/remote). Check the Hostname/IP Address and authentication mode (provide username & password if required).
Thanks TFR. On Sat, Feb 28, 2009 at 1:36 AM, Lee Gunn <[email protected]> wrote: > Hi, > > Sounds like you either want to use SQL Server authentication ie supply a > username and password in the connection string or create a login in sql > server for the account that asp.net is running under. > > lee > > ------------ > > http://www.jiba-jaba.com <http://www.jiba-jaba.com> > -- The Home of Public Microblogging > > ________________________________ > > From: [email protected] on behalf of Stacie > Sent: Fri 27/02/2009 18:40 > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > Services,.NET Remoting > Subject: [DotNetDevelopment] Login failed error when accessing Crystal report > > > > > I have a Crystal report included in my web app. After deploying my > web app to my web server when I try to access the report I receive the > following error "Logon failed. Details: ADO Error Code: 0x Source: > Microsoft OLE DB Provider for SQL Server Description: Login failed for > user '(null)'. Reason: Not associated with a trusted SQL Server > connection. SQL State: 42000 Native Error: Error in File C:\WINDOWS > \TEMP\Timecard {D01BFAAC-FA1F-4D29-8C7F-456964301B5C}.rpt: Unable to > connect: incorrect log on parameters." > > I can access the report on my dev server with no problems. Does > anyone know how to fix this error? > > >
