Webpage error: 40

[whodude]

 I performed a clean install of 8.5. Database located on separate server (Win2003 - SQL 2005) from the installation. DB builds correctly. NPM works correctly. When trying to access the webpage I get the following error:

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Line 39: </table>
Line 40:
Line 41: <div runat="server" visible="<%$ Code: SolarWinds.Orion.Web.DAL.WebSettingsDAL.FirstTime %>" style="margin-left: 100px;">
Line 42: You can log in with the User ID <strong>Admin</strong> and no password.<br /><br />
Line 43: You should set a password for the Admin account after you log in.<br />

Source File: e:\InetPub\SolarWinds\Orion\Login.aspx    Line: 41

Stack Trace:

SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734851
 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
 System.Data.SqlClient.SqlConnection.Open() +111
 SolarWinds.Orion.Common.DatabaseFunctions.OpenNewDatabaseConnection() +480
 SolarWinds.Orion.Web.DAL.WebSettingsDAL.Get(String settingName) +32
 SolarWinds.Orion.Web.DAL.WebSettingsDAL.get_FirstTime() +17
 ASP.orion_login_aspx.__BuildControl__control5() in e:\InetPub\SolarWinds\Orion\Login.aspx:41
 ASP.orion_login_aspx.__BuildControl__control3(Control __ctrl) in e:\InetPub\SolarWinds\Orion\Login.aspx:8
 System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12
 ASP.orion_masterpage_master.__BuildControlContentPlaceHolder1() +113
 ASP.orion_masterpage_master.__BuildControlaspnetForm() +125
 ASP.orion_masterpage_master.__BuildControlBody() +128
 ASP.orion_masterpage_master.__BuildControlTree(orion_masterpage_master __ctrl) +102
 ASP.orion_masterpage_master.FrameworkInitialize() +34
 System.Web.UI.UserControl.InitializeAsUserControlInternal() +31
 System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +1978592
 System.Web.UI.Page.get_Master() +48
 System.Web.UI.Page.ApplyMasterPage() +18
 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +543

I opened a case and was told it was a SQL problem.  Suggestions provided by SW support

Update for Case #17571 - "Orion Error Web Console"

Doug,

Error: 40 - Could not open a connection to SQL Server)

Doug, this is going to be a SQL issue and I am sending you some info that I got from doing some research for you, we like going that extra mile for our customers even when its not our issue. Here you go!


You should follow steps below to resolve this issue.

 

1. check the SQL Server Errorlog to make sure SQL Server is now listening on TCP/IP and confirm which port it is listening on. Usually 1433. In the Errorlog, you will see several lines that discuss what SQL Server is listening on. Below is an example:

 2006-01-04 01:41:07.65 server SQL server listening on 10.254.1.150: 1433. <--Shows the IP Address and the port.

 2006-01-04 01:41:07.65 server SQL server listening on 127.0.0.1: 1433. <--Shows another IP Address and the port.

 2006-01-04 01:41:07.69 server SQL server listening on TCP, Shared Memory, Named Pipes.

 2006-01-04 01:41:07.69 server SQL Server is ready for client connections

2, Make sure on Windows XP that the firewall is not blocking that port.

3, go to your client machine and run the client network configuration tool (cliconfg.exe) Make sure TCP/IP is enabled, click properties and make sure the port number is the same one as SQL Server is listening on. Here you can enable NP or disable client NP as well.

 Once both the client and the server are using TCP/IP with the same port number and the firewall on server machines is not blocked, you should be able to connect.

 Hope this helps.


Also, if this still doesnt fix ur problem , try these tips

Enable the TCP/IP protocol using the Surface Area Configuration Utility
Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility
Make sure the SQL Server browser is started. Note this step is optional. It is possible to set the SQL Server instance to use a fixed IP address - but this is non-standard for named instances
Make sure SQL Server and SQL Server Browser are exempted by the firewall on the server machine. This is done by putting sqlservr.exe and sqlbrowser.exe as an exception in the windows firewall.
Note: In order to get things to work. You might need to completely reboot the server machine after making the changes. There have been reports (thanks P.C.) that starting and stopping the SQL Server and Browser software is not enough.


James

Checked these settings still can not connect to the webpage

[whodude]

 Thanks for any help. Doug

[mark_wiggans]

 Doug-

Are you using pass through authentication or passwords with special characters? 

[whodude]

 It's setup for windows authentication and no special characters

[mark_wiggans]

 Have you already applied Hotfix 1?

[whodude]

Yes, hotfix 1 has been applied.  

[mark_wiggans]

We are currently experiencing problems with pass-through authentication. As a workaround you can disable it and put IIS back to anonymous authentication to see if that helps.

[whodude]

 I set logins to anonymous and still receive the same error message. I also deleted all the inetpub files and re-ran the configuration wizard. At the end of the wizard error "unable to update web.config file" appears. thanks for any input.

[mark_wiggans]

 In the C:\\Inetpub\Solarwinds folder you will need to add "Everyone" with Full permission to that folder and to the C:\program files\Solarwinds\Orion folder as well.

[whodude]

still getting the same error message "unable to update web configuration file" when running the config wizard. When I try to launch the web page I'm still getting error:40

[mark_wiggans]

 is this a remote web server?

[whodude]

 Yes it is.

[mark_wiggans]

 try copying the *.Schema files from your main Orion server (in C:\Program Files\Solarwinds\Orion) to the same directory on the extra web server.

[whodude]

 My apologies. Orion NPM and web services are all on the same server the database is on another server. thanks   

[whodude]

 I'm requesting a new license key and I'm going to install Orion on the same server as the DB.