|
BugNET Forums
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
| 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! |
|
|
|
| |
|
|
| 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
BugNET - Core Developer
|
|
|
|
| |
| | |
| | |
| | |
|
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.
|
|