October 28, 2005 at 10:50 am
I have IIS and SQL running on a Windows 2003 Server. The program is web based and I am trying to run a report, but I receive this message. the reporting was working fine.
| ||||||||||||||
October 28, 2005 at 10:56 am
database logon failed
Is the application using windows authentication or sql authentication to connect to sql server?
October 28, 2005 at 11:00 am
It is sql authentication.
October 28, 2005 at 11:03 am
Can you connect to the database using the connectionstring the application uses? (using query analyzer)
October 28, 2005 at 11:07 am
Sorry, I do not know what you mean by connectionstring? I am not familiar with SQL.
October 28, 2005 at 11:54 am
October 29, 2005 at 6:40 am
Is the sql reporting server on the same server as your IIS/SQL server?
The reporting was working fine->what has changed? (Moved from development to production....?)
October 31, 2005 at 5:52 am
Yes, the sql reporting server is on the same server as the IIS/SQL server.
User uses the reporting services daily. User could not open up the report on Friday.
October 31, 2005 at 6:39 am
It could have been that the server was too busy.
Is the user able to open the report now?
October 31, 2005 at 7:44 am
I can't open the report myself. We can view the report by pdf or html, but we are unable to open any of them.
October 31, 2005 at 8:18 am
Just for kicks I changed the server back to workgroup. After doing that I logged back in, I am able to view the reports.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply