Reply

Alsa1234

0 Points

Error uploading "Classifieds"

Sep 17, 2009 12:41 PM|LINK

Hi,

As a newcomer I am uncertain as what is going wrong when I try to upload my Classifieds website. I get the error stated somewhere in the forum:

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
    <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
</configuration>

I tried several of the suggestions but to no avail.

I started a new classifieds template and without any alteration, uploaded to my webhost (winhost) but get the same error.

I contacted winhost who informed that the webconfig needs alteration. I configd as per the above but it gets me to Error 501.

As a test, I installed and then uploaded "Small Business" start kit and this uploads and displays without any error. This leads me to believe that there is something that I am missing in the Classifieds configuration.

Please assist a frustrated beginner!

Thanks in advance,

Al

Reply

noahb

Contributor

2049 Points

360 Posts

Re: Error uploading "Classifieds"

Sep 17, 2009 02:56 PM|LINK

Why don't you set customErrors to Off in your web.config so you can see what exception is being thrown. That will help you figur out what is going wrong.

Please click Mark as Answer if my reply helped you.

http://blog.statichippo.com

"Any fool can recall the flight of birds across a moonlit sky but it takes a genius to forget the face of his mother."

Reply

Alsa1234

0 Points

9 Posts

Re: Error uploading "Classifieds"

Sep 17, 2009 03:29 PM|LINK

Hi,

I did and get

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

Source Error:

Line 6:      Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
Line 7:          
Line 8:          If (Not Roles.RoleExists("Administrators")) Then
Line 9:              Roles.CreateRole("Administrators")
Line 10:         End If

Source File: E:\web\clickche\global.asax Line: 8

Stack Trace:

[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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +376
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +4861315
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +87
   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +221
   System.Web.Security.SqlRoleProvider.RoleExists(String roleName) +478
   System.Web.Security.Roles.RoleExists(String roleName) +73
   ASP.global_asax.Application_Start(Object sender, EventArgs e) in E:\web\clickche\global.asax:8

[HttpException (0x80004005): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +2723002
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +128
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +188
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +295
   System.Web.HttpApplicationFactory.GetPipelineApplicationInstance(IntPtr appContext, HttpContext context) +56
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +231

[HttpException (0x80004005): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8896063
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +85
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +333

Any suggestion where to correct it?

Thanks,

Al

Reply

ONPADREISLE

Member

32 Points

30 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 06:44 AM|LINK

Al,

I changed web.config to following and was able to upload:

Reply

Rajneesh Ver...

All-Star

36867 Points

6763 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 07:07 AM|LINK

U need to make udl connection then see is it conncted to database? if yes then cross check your connction string...... with udl connection...

Mark if helped.......

Thanks

...........

Rajneesh Verma's Blog
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.

Reply

Alsa1234

0 Points

9 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 07:55 AM|LINK

Hi,

By default it is already <customErrors defaultRedirect="Error.aspx" mode="RemoteOnly"/>

Any other idea?

Thanks,

Al

Reply

Alsa1234

0 Points

9 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 08:03 AM|LINK

Hi Rajneesh,

I'm afraid I'm not familiar with udl. Could you please be more clear or direct me to some tutorial?

I just don't understand why the default Classifieds template doesn't show in the browser, since I don't do any alteration at all, or is there any alteration that needs doing to webconfig before uploading the website to the host server?

Thanks for any feedback.

Al

Reply

Alsa1234

0 Points

9 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 09:26 AM|LINK

Hi guys,

After correcting the

<!-- Web.Config Configuration File --><configuration>    <system.web>        <customErrors mode="Off"/>

I get now:

Server Error in '/' Application.

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)

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: 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)

Source Error:

Line 6:      Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
Line 7:          
Line 8:          If (Not Roles.RoleExists("Administrators")) Then
Line 9:              Roles.CreateRole("Administrators")
Line 10:         End If

Source File: E:\web\clickche\global.asax Line: 8

Stack Trace:

[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) +4846887
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
   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) +31
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +87
   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +221
   System.Web.Security.SqlRoleProvider.RoleExists(String roleName) +478
   System.Web.Security.Roles.RoleExists(String roleName) +73
   ASP.global_asax.Application_Start(Object sender, EventArgs e) in E:\web\clickche\global.asax:8

[HttpException (0x80004005): 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.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +2723002
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +128
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +188
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +295
   System.Web.HttpApplicationFactory.GetPipelineApplicationInstance(IntPtr appContext, HttpContext context) +56
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +231

[HttpException (0x80004005): 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.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8896063
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +85
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +333

My webconfig is:

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
   <location path="Admin">
       <system.web>
           <authorization>
               <allow roles="Administrators"/>
               <deny users="*"/>
           </authorization>
       </system.web>
   </location>
   <location path="PostAd.aspx">
       <system.web>
           <authorization>
               <deny users="?"/>
           </authorization>
       </system.web>
   </location>
   <location path="EditPhotos.aspx">
       <system.web>
           <authorization>
               <deny users="?"/>
           </authorization>
       </system.web>
   </location>
   <location path="MyAds.aspx">
       <system.web>
           <authorization>
               <deny users="?"/>
           </authorization>
       </system.web>
   </location>
   <location path="MyProfile.aspx">
       <system.web>
           <authorization>
               <deny users="?"/>
           </authorization>
       </system.web>
   </location>
   <system.web>
       <customErrors mode="Off"/>
       <pages styleSheetTheme="Red"/>
       <authentication mode="Forms"/>
       <membership>
           <providers>
               <clear/>
               <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
           </providers>
       </membership>
       <profile enabled="true">
           <properties>
               <add name="FirstName" type="System.String"/>
               <add name="LastName" type="System.String"/>
               <add name="MemberId" defaultValue="0" type="System.Int32"/>
               <group name="Core"/>
           </properties>
       </profile>
       <roleManager enabled="true"/>
       <siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">
           <providers>
               <clear/>
               <add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
           </providers>
       </siteMap>
       <compilation debug="true"/></system.web>
   <connectionStrings>
       <clear/>
       <add name="LocalSqlServer" connectionString="server=DB2005;database=clickcheclick1;uid=clickusr;pwd=test#123;" providerName="System.Data.SqlClient"/>
       <add name="classifiedsConnection" connectionString="server=DB2005;database=clickcheclick1;uid=clickusr;pwd=test#123;" providerName="System.Data.SqlClient"/>
   </connectionStrings>
   <system.net>
       <mailSettings>
           <smtp>
               <network host="yourSMTPhostname" port="25" defaultCredentials="true" userName="enterUserNameHereIfRequired" password="enterPasswordIfRequired"/>
           </smtp>
       </mailSettings>
   </system.net>
</configuration>

I'm sorry for the bother but is there anybody who could help, please?

Thanks in advance,

Al

Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.4049

Reply

ONPADREISLE

Member

32 Points

30 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 12:14 PM|LINK

Will the Classifieds Starter Kit run on your computer (Local Server) when you first start a new website from the template. When you run the "Welcome" page can you see "Default.aspx" on your local server?

Reply

ONPADREISLE

Member

32 Points

30 Posts

Re: Error uploading "Classifieds"

Sep 19, 2009 12:31 PM|LINK

I had the same error you are having when I first tried to start the CSK (I am using a different hosting company but maybe this will help). I followed procedures in this post to upload and connnect.

http://forums.asp.net/t/1196793.aspx

Also www.connectionstrings.com

Error uploading "Classifieds" RSS

15 replies

Alsa1234

Error uploading "Classifieds"

Runtime Error

noahb

Re: Error uploading "Classifieds"

Alsa1234

Re: Error uploading "Classifieds"

ONPADREISLE

Re: Error uploading "Classifieds"

Rajneesh Ver...

Re: Error uploading "Classifieds"

Alsa1234

Re: Error uploading "Classifieds"

Alsa1234

Re: Error uploading "Classifieds"

Alsa1234

Re: Error uploading "Classifieds"

Server Error in '/' Application.

ONPADREISLE

Re: Error uploading "Classifieds"

ONPADREISLE

Re: Error uploading "Classifieds"

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft