×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

ASP.Net Crystal Reports connection to SQL Server through published website

ASP.Net Crystal Reports connection to SQL Server through published website

ASP.Net Crystal Reports connection to SQL Server through published website

(OP)
I am working to have a report show in my website that will be accessible through a computer network. When debugging the website in Visual Studio I can run the report just fine, however when I publish my website and access it through any PC on the network I receive the error:

Failed to open the connection. [Database Vendor Code: 18456]

I can still access SQL Server throughout the rest of the website through forms and insert, update, delete functions etc.

How can this be resolved? Is it a problem with my configuration settings in IIS or SQL Server? Or anything else?

RE: ASP.Net Crystal Reports connection to SQL Server through published website

What type of database connection are you using? Are you setting the database location and logon information in your code? Which version of VS and the Crystal for VS SDK are you using?

-Dell

Senior Manager, Data & Analytics
Protiviti
www.protiviti.com

RE: ASP.Net Crystal Reports connection to SQL Server through published website

(OP)
I have since fixed the problem. Before the logon information was coming from the web config, but since adding this to the code it now works.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close