Logon failed. 28000:[Microsoft][ODBC SQL Server] Logon failed for user

[metevil80]

When staff trys to logon they continue to get this error
Logon failed. 28000:[Microsoft][ODBC SQL Server] Logon failed for user 'accruser'. I can login as SA, and have even created a new user to access the Crystal Report and still nothing. This report is tied to an older version of GP which is 7.5 on SMS 2005. Access was not a probblem before. Any tips would be appreciated.

 

[infinitizon]

Are you dynamically changing your report source? If so, you will always be having that error.
You will need to also pass in the logon details at runtime.

If not, then try to logon to the sql server first directly using the management studio with the users logon and confirm that you have given them access to the appropriate dbs.

Good luck