Running Crystal Reports with a SQL Server Login instead of a Network Login

5 pts.
Tags:
Crystal Reports
Crystal Reports error messages
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following