reporting error???

[anhlam]

Can someone point me in the right direction to this issue? When I launch the Reporting from server, I get the following error:

An error occurred when the report was run. The details are as follows:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error Number: -2147467259
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 18452

thanks again

 

[Mich]

Make sure you have a SQL login with appropriate DB rights. This login must also have rights on the SMS server to the virtual directory in IIS. Post back if you need help with this.

-If it ain't broke, break it and make it better.

 

[anhlam]

I was able to resolve the problem. Thanks for getting back to me.

 

[Cybrtek2001]

anhlam,

Would you mind giving us details on what you did to correct this problem. This may happen to someone else and that info would be very useful in the future.

Thanks!