ESP.Portal and “A network-related or instance-specific error occurred while establishing a connection to SQL Server”

Filed under BPI
Tagged as , , ,

When I opened the ESB.Portal (BizTalk ESB Guidance 2.0) in Internet Explorer I ran into the next problem:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 27-3-2009 20:26:37
Event time (UTC): 27-3-2009 19:26:37
Event ID: f5247af6841e45349be4dbd365417ff9
Event sequence: 99
Event occurrence: 4
Event detail code: 0
Application information:
    Application domain: /LM/W3SVC/1/ROOT/ESB.Portal-1-128826538435234595
    Trust level: Full
    Application Virtual Path: /ESB.Portal
    Application Path: C:\projects\microsoft.practices.esb\Source\Samples\Management Portal\ESB.Portal\
    Machine name: myMachine
Process information:
    Process ID: 5752
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
    Exception type: SqlException
    Exception message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.)
Request information:
    Request URL: http://localhost/ESB.Portal/Lists/RegistrySummaryContainer.aspx
    Request path: /ESB.Portal/Lists/RegistrySummaryContainer.aspx
    User host address: ::1
    User: myMachine\user 
    Is authenticated: Trueetc etc

To fix this you must make sure your SQL connections are configured properly, like:

Sql Server Configuration Manager - ESB.Portal

TCP/IP must be enabled!

  • Share/Bookmark

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*