Forums

Search Home All Forums

Home

Support

Installing BugN...

Cannot install Sql 2000 SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

4/4/2007 8:54 AM

memmaker

Joined: 4/4/2007

Posts: 4

Cannot install Sql 2000 SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I'm testing this project in sql 2000 windows 2003 ii6, i have installed asp.net 2.0 and (Microsoft Report Viewer Redistributable 2005 Microsoft ASP.NET AJAX 1.0)
i have create a new db bugnet ad get all rights on the root folder.
In the web.config i set this string connection: <add name="LocalSqlServer" connectionString="Data Source=.\LOCAL;AttachDbFilename=|DataDirectory|BugNet.mdf;User ID=XXX;Password=XXX" providerName="System.Data.SqlClient"/>
I have enable remote connection from sql server 2000.

When i try to start install.aspx i get this error:

Installing BugNET

Version: 0.7.820.0

Installation Status Report

Installing Version: 0.7.820.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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Installing BugNET Database... - 00:00:00.0156248
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Installing BugNET Default Data... - 00:00:00.0156248
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Creating Administrator Account... - 00:00:00.0156248

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]    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

Thanks all for support!

4/10/2007 8:16 AM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1425

Re: Cannot install Sql 2000 SQL Network Interfaces, error: 26 - Error Locating Server/Instance Speci

If you are using sql 2000 you will need to update the connection string accordingly to point to your sql 2000 database with the username password or integrated security.

For examples of connection strings please visit www.connectionstrings.com

Davin Dubeau

Page 1 of 1

Home

Support

Installing BugN...

Cannot install Sql 2000 SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.