View Single Post
  #1 (permalink)  
Old September 16th, 2006, 02:03 PM
dynamicarray dynamicarray is offline
Registered User
 
Join Date: Sep 2006
Location: baton rouge, LA, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Problem /Chapter 03 Wrox United Example

I am trying to do the examples from Chapter 03 with the Wrox United files but when i go to run the site I am getting this error message.

Server Error in '/WroxUnited' 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:

Line 112: Public Overridable Property Theme() As String
Line 113: Get
Line 114: Return CType(Me.GetPropertyValue("Theme"),String)
Line 115: End Get
Line 116: Set


Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\23e58e6c\d0079918\App_Code.1lwpdy o2.5.vb Line: 114

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.SqlClient.SqlInternalConnection. OnError(SqlException exception, Boolean breakConnection) +117
System.Data.SqlClient.TdsParser.ThrowExcepti onAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Connect(Bool ean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1091
System.Data.SqlClient.SqlInternalConnectionT ds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1083
System.Data.SqlClient.SqlInternalConnectionT ds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272
System.Data.SqlClient.SqlConnectionFactory.C reateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +351
System.Data.ProviderBase.DbConnectionFactory .CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +82
System.Data.ProviderBase.DbConnectionPool.Cr eateObject(DbConnection owningObject) +558
System.Data.ProviderBase.DbConnectionPool.Us erCreateRequest(DbConnection owningObject) +126
System.Data.ProviderBase.DbConnectionPool.Ge tConnection(DbConnection owningObject) +651
System.Data.ProviderBase.DbConnectionFactory .GetConnection(DbConnection owningConnection) +160
System.Data.ProviderBase.DbConnectionClosed. OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122
System.Data.SqlClient.SqlConnection.Open() +229
System.Web.DataAccess.SqlConnectionHolder.Op en(HttpContext context, Boolean revertImpersonate) +114
System.Web.DataAccess.SqlConnectionHelper.Ge tConnection(String connectionString, Boolean revertImpersonation) +225
System.Web.Profile.SqlProfileProvider.GetPro pertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +1005
System.Web.Profile.SqlProfileProvider.GetPro pertyValues(SettingsContext sc, SettingsPropertyCollection properties) +467
System.Configuration.SettingsBase.GetPropert iesFromProvider(SettingsProvider provider) +325
System.Configuration.SettingsBase.GetPropert yValueByName(String propertyName) +372
System.Configuration.SettingsBase.get_Item(S tring propertyName) +142
System.Web.Profile.ProfileBase.GetInternal(S tring propertyName) +52
System.Web.Profile.ProfileBase.get_Item(Stri ng propertyName) +91
System.Web.Profile.ProfileBase.GetPropertyVa lue(String propertyName) +29
ProfileCommon.get_Theme() in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\23e58e6c\d0079918\App_Code.1lwpdy o2.5.vb:114
Wrox.Web.GlobalEvents.ThemeModule.app_PreReq uestHandlerExecute(Object Sender, EventArgs E) in C:\BegASPNET2\Chapters\Begin\Chapter03\WroxUnited\ App_Code\ThemeModule.vb:30
System.Web.SyncEventExecutionStep.System.Web .HttpApplication.IExecutionStep.Execute() +167
System.Web.HttpApplication.ExecuteStep(IExec utionStep step, Boolean& completedSynchronously) +117