IbexMark
  • Posts: 2
  • Joined: 14/01/2010
I am getting the error below while running install/default.aspx. This is a SQL Connection error; however, the "Test Connection" succeeded previously during the install. The error occurs during membership upgrade. Please note that I am using the default configuration settings for the membership. I know that the database connection has succeeded as tables have been created in my database.

I suspect this might be related to a limited number of connections allowed for SQLExpress; however, that is only a hunch.

The version is YAF-v1.9.4-RC1-BIN

The error:
Quote:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)



Web.config membership
Quote:

<roleManager enabled="true" defaultProvider="YafRoleProvider">
<providers>
<clear/>
<add connectionStringName="yafnet" applicationName="YetAnotherForum" name="YafRoleProvider" type="YAF.Providers.Roles.YafRoleProvider"/>
</providers>
</roleManager>
<membership defaultProvider="YafMembershipProvider" hashAlgorithmType="SHA1">
<providers>
<clear/>
<add connectionStringName="yafnet" applicationName="YetAnotherForum" name="YafMembershipProvider" requiresUniqueEmail="true" useSalt="true" type="YAF.Providers.Membership.YafMembershipProvider"/>
</providers>
</membership>
<profile enabled="true" defaultProvider="YafProfileProvider" inherits="YAF.Classes.Utils.YafUserProfile">
<providers>
<clear/>
<add connectionStringName="yafnet" applicationName="YetAnotherForum" name="YafProfileProvider" type="YAF.Providers.Profile.YafProfileProvider"/>
</providers>
</profile>




The stack:
Quote:

[SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5038006
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity) +5049394
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +129
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +218
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject, Boolean& isNewConnection) +933
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +154
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
YAF.Classes.Data.YafDBConnManager.get_OpenDBConnection() +39
YAF.Classes.Data.YafDBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) +78
YAF.Providers.Membership.DB.UpgradeMembership(Int32 previousVersion, Int32 newVersion) +180
YAF.Install._default.UpgradeDatabase(Boolean fullText) in c:\Ibex\Projects\YetAnotherForum\install\default.aspx.cs:1013
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) in c:\Ibex\Projects\YetAnotherForum\install\default.aspx.cs:619
System.Web.UI.WebControls.Wizard.OnNextButtonClick(WizardNavigationEventArgs e) +108
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +416
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +19
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Sponsor
Jaben
  • Posts: 2544
  • Joined: 09/10/2004
I'll bet you changed your default DB provider during the installation (e.g. instead of "yafnet" you are using something else) and did not modify your provider configuration.

Check your connection strings and rename your provider connection string name appropriately.

If this doesn't make sense you to you, post your app.config and db.config files here (sans passwords).
IbexMark
  • Posts: 2
  • Joined: 14/01/2010
I think they are fine but here they are. Perhaps you can see something

db.config
Quote:

<connectionStrings>
<add name="yafnet" connectionString="server=IBEX0004\SQLEXPRESS;initial catalog=yafnet;integrated security=SSPI" />
</connectionStrings>



app.config
Quote:

<appSettings>
<!--
******************************************************************
** ConfigPassword Key ** Defaults to: Empty (not installed) **

Password to run configuration (/install/default.aspx) for the forum.
If you cannot set write permissions on this file (app.config)
you can manually enter a plain text password here that will
be required when you attempt to run the configuration. Install/config
password is required for security reasons.
-->
<add key="YAF.ConfigPassword" value="*****" />

<!--
******************************************************************
** BoardID Key ** Defaults to: 1 **

You can create as many boards as you want and they will function as seperate
forums (with seperate users). (Admin->Boards to create new boards.)
You can also specify "BoardID" in the forum control:

<YAF:Forum ID="Forum1" runat="server" BoardID="2" />

-->
<add key="YAF.BoardID" value="1" />

<!--
******************************************************************
** EnableURLRewriting Key ** Defaults to: false **

For advanced users who need SEO-quality URLs on their forum. If
you don't know what SEO is, you probably don't need to enable.
-->
<add key="YAF.EnableURLRewriting" value="false" />

<!--
******************************************************************
** SMTP SSL Key ** Defaults to: false **

Set to true to use SSL for SMTP server connections.
-->
<add key="YAF.UseSMTPSSL" value="false" />

<!--
******************************************************************
** databaseObjectQualifier Key ** Defaults to: yaf_ **

For advanced users who want to change the prefix for Yaf DB
structure.
-->
<add key="YAF.DatabaseObjectQualifier" value="yaf_" />

<!--
******************************************************************
** DatabaseOwner Key ** Defaults to: dbo **

For advanced users who want to the change the default permissions
for the YAF DB structure.
-->
<add key="YAF.DatabaseOwner" value="dbo" />

<!--
******************************************************************
** ConnectionStringName Key ** Defaults to: yafnet **

The Database Connection string name YAF should use. Defaults
to "yafnet" for backward compatibility.
-->
<add key="YAF.ConnectionStringName" value="yafnet" />

<!--
******************************************************************
** providerExceptionXML Key ** Defaults to: ProviderExceptions.xml **

The file that the providers pull exception messages from.
-->
<add key="YAF.ProviderExceptionXML" value="ProviderExceptions.xml" />

<!--
******************************************************************
** UploadDir Key ** Defaults to: "~/upload/" **

Has now been deprecated in favour of BoardRoot. The upload folder is now
the value of BoardRoot appended with "upload/".
-->

<!--
******************************************************************
** Optional BoardRoot Key ** Defaults to a empty string.

Provides a method of moving Images/Themes/Uploads to a subfolder within
the YAF application.
Make sure there is write permissions to this directory for Uploads to
work.
<add key="YAF.BoardRoot" value="~/Boards/" />
-->

<!--
******************************************************************
** Optional MultiBoardFolders Key ** Defaults to false

Appends BoardRoot with the CurrentBoardID to allow different Images/
Uploads/Themes per board. E.g. /Boards/1/Themes.
Requires manually adding of themes.
<add key="YAF.MultiBoardFolders" value="true" />
-->

<!--
******************************************************************
** Optional File Root Key ** Defaults to: AppRoot (below) **

File Root is server-side and used by YAF to find and load files.

If YAF forum files are not located in the Application Root (~/)
of your web site you need to specify the additional url
in this root key. Example: Application Root is "/forum"
You want your forum at "www.mysite.com/forum". You need to specify
"/forum" in your root key below.

PLEASE NOTE:

YAF .dll files (from the \bin directory in the zip) AND ALL files
in the \App_Code directory MUST be located in the Application Root.

<add key="YAF.FileRoot" value="~/forum"/>
-->

<!--
******************************************************************
** Optional AppRoot ** Defaults to: "~/" **

If YAF forum URL is different than the Application Root, specify
it manually here. Do NOT include server information.

e.g. ~/forum
-->

<add key="YAF.AppRoot" value="~/" />

<!--
******************************************************************
** Optional Base Url Mask ** Defaults to: "Current Server" **

Use this key to provide a base url override or mask for your YAF
forum. This is the protocol and server ONLY - add any path information
to your AppRoot.

e.g.: https://mydomain.com 

<add key="YAF.BaseUrlMask" value="" />
-->

<!--
******************************************************************
** Membership Provider Key Type ** Defaults to: "System.Guid" **

The type that the membership provider expects the ProviderKey
to be. Most providers use expect System.Guid.

Valid values include:

System.Guid (default)
System.String (max 64 character length)
System.Int32
System.Int64

-->
<add key="YAF.ProviderKeyType" value="System.Guid" />

<!--
******************************************************************
** Optional ShowToolBar ** Defaults to: "true" **

You can hide the toolbar with the optional key below. You may want
to do this if you've incorporated YAF into your existing site and
have your own menu controls for accessing the forum.

<add key="YAF.ShowToolBar" value="false" />
-->

<!--
******************************************************************
** Optional AllowLoginAndLogoff ** Defaults to: "true" **

You can turn off the ability for YAF users to login and logoff (for
site integration) by uncommenting the key below.

<add key="YAF.AllowLoginAndLogoff" value="false" />
-->

<!-- RadEditor configuration settings-->
<add key="YAF.RadEditorSkin" value="Black"/>
<add key="YAF.UseRadEditorToolsFile" value="true"/>
<add key="YAF.RadEditorToolsFile" value="editors/radEditor/toolsFile.xml" />
<!-- RadEditor configuration settings-->
</appSettings>

Users browsing this topic
    Forum Jump  
    • You cannot post new topics in this forum.
    • You cannot reply to topics in this forum.
    • You cannot delete your posts in this forum.
    • You cannot edit your posts in this forum.
    • You cannot create polls in this forum.
    • You cannot vote in polls in this forum.

    About Us

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Powered by Resharper Donate with PayPal button

    Project Twitter Updates

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved