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

[PeaEssEl]

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?

 

[hilfy]

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

http://www.protiviti.com

 

[PeaEssEl]

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.