Home > IT Answers > Business Intelligence > Running Crystal Reports with a SQL Server Login instead of a Network Login
DB2009
5 pts.
 Running Crystal Reports with a SQL Server Login instead of a Network Login
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
I'm trying to run a Crystal Report using Crystal Runtime but I'm getting a "Logon Failed. Details: [Database Vendor Code: 18456]" After running a SQL Trace, I think I have found why. It appears as though it depends on how the user is logged on to the network as to whether or not they are able to run the reports. Instead of logging on under SQL server, it seems to be defaulting to the network logon instead. How can I make this default to SQL Server?

Software/Hardware used:
ASKED: June 12, 2009  4:46 PM
UPDATED: November 5, 2011  12:02 PM
RELATED QUESTIONS
Answer Wiki:
Sounds like your database server isn't configured for both NT and SQL authentication. or you can use sa user that have access over target database.
Last Wiki Answer Submitted:  November 5, 2011  12:02 pm  by  Shani   15 pts.
All Answer Wiki Contributors:  Shani   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _