Hello
I have been working on installing BugNet for days for a major software project, and I can't get it to work. My operating system is XP Pro, and I have SQL Server 2005 Express installed on it. I am getting this 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)
I think something is wrong with my connection strings but I don't know how to fix it:
Connection String for Web.config:
<connectionStrings>
<clear />
<add name="LocalSqlServer" connectionString="server=DRICKA/SQLEXPRESS;database=IssueTracker;uid=DRICKIA/Rena Smith;pwd=chair890" providerName="" />
</connectionStrings>
Connection String for Log4Net.config:
<connectionString server="DRICKA/SQLEXPRESS;database=IssueTracker;uid=DRICKIA/Rena Smith;pwd=chair891" />
I followed tips online to try to solve this problem such as going to the SQL Server Surface Area Configuration and changing the remote connection to use TCI/IP and named piples, and I enabled the SQL web browser. I also configured the firewall for sqlbrowser.exe and sqlservr.exe. Any help would be appreciated. I checked my virtual directory and it's ok I believe. I can see the contents of it when I use localhost in my web browser. Here are the errors in detail:
Installing BugNET
Version: 0.7.881.0
Installation Status Report
Installing Version: 0.7.881.0
Installing Membership Provider... - 00:00:00
Error!
Error in file:C:\BugNet\Install\dbscripts\InstallCommon.sql
Message: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)
Error!
Error in file:C:\BugNet\Install\dbscripts\InstallMembership.sql
Message: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)
Error!
Error in file:C:\BugNet\Install\dbscripts\InstallProfile.sql
Message: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)
Error!
Error in file:C:\BugNet\Install\dbscripts\InstallRoles.sql
Message: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)
Installing BugNET Database... - 00:00:00.0312500
Error!
Error in file:C:\BugNet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message: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)
Installing BugNET Default Data... - 00:00:00.0468750
Error!
Error in file:C:\BugNet\Install\dbscripts\BugNET.Data.SqlDataProvider.sql
Message: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)
Creating Administrator Account... - 00:00:00.0468750
Server Error in '/BugNet' Application.
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)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
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.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612
System.Web.Security.Membership.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +224
System.Web.Security.Membership.CreateUser(String username, String password, String email) +30
BugNET.Install.Install.InstallBugNET() +368
BugNET.Install.Install.InstallApplication() +1449
BugNET.Install.Install.Page_Load(Object sender, EventArgs e) +260
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
|
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42