locked
CRYSTAL REPORT in ASP.NET with UNC and SQL-Server RRS feed

  • Question

  • User-1536940678 posted

    We are using CRYSTAL Report (13.0) through ASP.NET(4.0) on Win2008.
    The Report files (RPT) are kept at UNC location on seperate machine, the database (SQL Server) is located on another machine. The ASP.NET based application access the database using SQL-Server Authentication.
    The UNC location has share&full access for everyone. The crystal-report (RPT) files are designed using OLE-DB and SQL-Server authentication. At runtime the Crystal Report engine is supplied with SQL-Server user-credentials. To access the RPT file from UNC, the impersonation tag is added in Web.Config.
    However the Crystal Report runtime generates the error saying "Failed to open the connection".
    I have been reading about issue of 'Double-Hop' while dealing with Crystal Report through ASP.NET (However no luck in figuring it out)
    Any idea about the root cause of problem and possible resolution?

    Thursday, August 30, 2012 9:34 AM

Answers

  • User-578610739 posted

    Hi Yogeshb,

    First check that your local sql management studio connect the sqlserver. Also check server connection proerties i.e. Named Pipes or

    see all link, may be help you.

    http://forums.asp.net/t/1310061.aspx/1

    http://stackoverflow.com/questions/5235929/crystal-reports-failed-to-open-connection

    http://www.sqlservercentral.com/Forums/Topic543809-324-1.aspx

    http://forums.asp.net/t/1212953.aspx/1

    http://forums.asp.net/t/1338911.aspx/2/10

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 3, 2012 4:05 AM
  • User1196771204 posted

    hi yogeshb,

    The "failed to open the connection" error message simply means that:

    1. Your SQL Server is not found
    2. Your SQL Server port is closed

    Above all, this is the issue with your connection string. May I please know how did you host this Crystal Report? Do you run your own server or do you host it with a hosting provider? If you run your own server, you need to make sure you can connect to your SQL Server first via SQL Mgmt Studio tool. If you can connect, you just need to use exactly the same settings on your connection string

    If you host it with a hosting provider, you need to contact them to find the correct connection string.

    Please mark this response as an "answer" if it helps you. Thanks heaps! 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, September 7, 2012 5:51 AM

All replies

  • User-578610739 posted

    Hi Yogeshb,

    First check that your local sql management studio connect the sqlserver. Also check server connection proerties i.e. Named Pipes or

    see all link, may be help you.

    http://forums.asp.net/t/1310061.aspx/1

    http://stackoverflow.com/questions/5235929/crystal-reports-failed-to-open-connection

    http://www.sqlservercentral.com/Forums/Topic543809-324-1.aspx

    http://forums.asp.net/t/1212953.aspx/1

    http://forums.asp.net/t/1338911.aspx/2/10

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 3, 2012 4:05 AM
  • User1196771204 posted

    hi yogeshb,

    The "failed to open the connection" error message simply means that:

    1. Your SQL Server is not found
    2. Your SQL Server port is closed

    Above all, this is the issue with your connection string. May I please know how did you host this Crystal Report? Do you run your own server or do you host it with a hosting provider? If you run your own server, you need to make sure you can connect to your SQL Server first via SQL Mgmt Studio tool. If you can connect, you just need to use exactly the same settings on your connection string

    If you host it with a hosting provider, you need to contact them to find the correct connection string.

    Please mark this response as an "answer" if it helps you. Thanks heaps! 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, September 7, 2012 5:51 AM