Hello, being very new to .net and yet very eager to learn, I appologize in advance for my ignoranceand any information I have left out.  I was most interested in the starter kits as they really give you a change to dig in to a working program to see the nuances.  I hope with the help of this forum I can get this program working. 

I have the following config:

Separate Server 2003 server on local lan for testing running SQL 2000 and SQL 2005 Express
WINXP on development machine runing Visual Studio 2005

I downloaded Classifieds Starter kit; installed it; loaded it into VWD 2005; created an admin account; ran the program using Ctrl + F5; browsed the app; everything worked as expected.

I built and published the project to a folder on the local machine and the copied the files over to the webserver.  I attacted the 2 databases in the App_Data folder to the SQL2005 Express. I ran the default.apx file and "poop" no go.  I am sure I am doing something wrong or havn't configured it properly, but being this my first real project to look at, I don't know where to start.  I have included the web.config file and the error received when trying to run the default.aspx page.  I look forward to any responses to help solve this mystery.

Thanks a million.

 Wolf

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

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

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

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

Hi,

can you please change your web.config as follows:

change in this line <customErrors defaultRedirect="Error.aspx" mode="RemoteOnly"/>

change RemoteOnly to On so that you can view the error message and display it here. The error message you posted is a generic error message which doesn't contain any info to help rectify the error.

Regards

Actually, in the web.config file you want Off not On.

Like this <customErrors mode="Off"/>

Note that it is case sensitive "Off"

The other issue, to start at least, is with your connection string.

Try something like this, of course you will have to enter your usernames and passwords.

The first connection is pointing to the ads database, and the second is pointing to your asp.net members database.

<connectionStrings>

<remove name="LocalSqlServer"/>

</connectionStrings>

If that doesn't work post your error, once you have the mode="Off" it will give more information.

Also, whoever your hosting server is there should be somewhere on their site,

or in the control panel that will give you an idea of how they want you to connect to the databases.

Good Luck

Daniel Meis

As Daniel mentioned, DB connection strings is the most common cause of errors when uploading to a host.

It'll help if you disable custom errors. This will allow you to view a stack trace of the cause of the exception.

Thats exactly my problem I dont know where to begin 6 long days and nights i think i figured how to put the databases on the server using database publishing wizard and database manager but im only allowed one database so i cant get the 2 of them on If thats right not sure if i need to buy another?

Also I havent been able to get any starterkits working on the host, any help from anyone would be great plzzzzzzzzz

Thanks for the input Daniel,

 I changed the mode to "Off" - However, I still receive the same error message.  Does this change need to be made within VWD 2005 and then rebuild?

Also - I have changed the conection strings as you indicated - however, I am not sure of two items.

1 - Would the datasource look somthing like this?  I am runing this on a local server to get working first then loading to host. 
<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Inetpub\wwwroot\classifieds\App_Data\classifiedsdb.mdf;

2. - I am not sure what data should be entered for the following:
Initial Catalog=xxxxxxxxxx

Thanks for the replies...

Wolf

You do not need to rebuild. Just make the change to the webconfig file and upload it.

the xxxxxxxxxx are the database name.

The DOT in DataSource =.\SQLExpress means your localhost running a sql express instance named "SQLExpress" so you need to replace that DOT with the database server name that your host provided. You will also need to enter the user/pass to access that database. If you need help creating the connection String check http://www.connectionstrings.com/?carrier=sqlserver2005 

Your's should look like

<add name="LocalSqlServer" connectionString="Data Source=DB_SERVERNAME;Initial Catalog=DATABASE_NAME;User Id=USER;Password=PASS;" providerName="System.Data.SqlClient"/>

To answer the previous post, YOU CAN merge both databases into ONE.

Use C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe to prepare the classifieds database to support membership then point the membership connection string the to classifieds db

Like that

<connectionStrings>
<clear/>
<add name="classifiedsConnection" connectionString="Data Source=server ;Initial Catalog=db;User Id=user;Password=pass;" providerName="System.Data.SqlClient"/>
<add name="LocalSqlServer" connectionString="Data Source=server ;Initial Catalog=db;User Id=user;Password=pass;" providerName="System.Data.SqlClient"/>
</connectionStrings>

Good luck

thanks ashmetry

This is the error im getting i find the coding quite blinding could you help me if i give you my server details etc to adjust my web.config

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) +739123
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
   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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
   AdsDataComponentTableAdapters.AdsDataAdapter.GetAdsByRandomOrder(Int32 NumRecords, Int32 AdStatus, Int32 AdLevel) +349
   AspNet.StarterKits.Classifieds.BusinessLogicLayer.AdsDB.GetFeaturedAdsSelection(Int32 maxNumAds) +72
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.FetchFeaturedAd() +14
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.GetFeaturedAd(HttpContext context) +107
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.GetFeaturedAd() +12

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040
   System.Web.UI.WebControls.Repeater.GetData() +50
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
   System.Web.UI.WebControls.Repeater.DataBind() +72
   System.Web.UI.WebControls.Repeater.EnsureDataBound() +55
   System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12
   System.Web.UI.Control.PreRenderRecursiveInternal() +77
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

first line  An error has occurred while establishing a connection to the server. 

Means You have bad configuration to your database. You will need to get that from your hosting provider, ask for the server name, database name, your user/pass

where are you hosting?

-Ash

This is my web.config could you give me some pointers as to what goes where i want to see this site working so much :)

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<deny users="?"/>

</system.web>

<location path="EditPhotos.aspx">

<authorization>

</authorization>

</location>

<system.web>

<deny users="?"/>

</system.web>

<location path="MyProfile.aspx">

<authorization>

</authorization>

</location>

<customErrors defaultRedirect="Error.aspx" mode="Off"/>

<authentication mode="Forms"/>

<providers>

<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=""/>

</membership>

<properties>

<add name="LastName" type="System.String"/>

<group name="Core"/>

</profile>

<siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">

<clear/>

</providers>

</system.web>

<add name="classifiedsConnection" connectionString="Data Source=mssql.pipeten.co.uk\SQLEXPRESS;AttachDbFilename=|DataDirectory|\classifiedsdb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

<system.net>

<smtp>

</smtp>

</configuration>

you'll need to create a sql2005 db from your hosting control panel, enter that db name in the initial catalog as well as the user/pass

<add name="classifiedsConnection" connectionString="Data Source=mssql.pipeten.co.uk;Initial Catalog=db_name;User Id=user;Password=pass;" providerName="System.Data.SqlClient"/>

Thanks mate

Yes I have all the details of user name etc i think I have a reseller package with pipeten.

It was just what i wrote and where could you guide me through it please

I have put the aspnet and classifieds.mdf on the server with database publishing wizard

Well what does the wizard tell you one where the mdf are stored? You need to find the path to the mdf files then use that...Im assuming you're not using sqlserver 2005 then?? in that case the connection string is different..check http://www.connectionstrings.com/?carrier=sqlserver2005 

I would contact pipe10 to get the details oh the sqlserver connection. i pretty sure thats the main problem at the moment

I have the target database etc its just where do i put it in the files ?

If i can get this to work i know i can get the rest to work

thanks for helping

Im not sure what you mean. The mdf file IS your database.. they should sit in your App_Data folder

I mean what files do i change to direct them to it is it my web config?? this is my web config file i actually got to see the site live on the web but i must have done something its not showing again hmmmmmmmm thanks once again !

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<system.web>

<allow roles="Administrators"/>

</authorization>

</location>

<system.web>

<deny users="?"/>

</system.web>

<location path="EditPhotos.aspx">

<authorization>

</authorization>

</location>

<system.web>

<deny users="?"/>

</system.web>

<location path="MyProfile.aspx">

<authorization>

</authorization>

</location>

<customErrors defaultRedirect="Error.aspx" mode="Off"/>

<authentication mode="Forms"/>

<providers>

<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=""/>

</membership>

<properties>

<add name="LastName" type="System.String"/>

<group name="Core"/>

</profile>

<siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">

<clear/>

</providers>

</system.web>

<add name="classifiedsConnection" connectionString="Data Source=mssql.pipeten.co.uk\MSSQL\Databases;Initial Catalog=NeroLyl_one;User Id=xxxxxxxxxx;Password=xxxxxxx" providerName="System.Data.SqlClient"/>

<system.net>

<smtp>

</smtp>

</system.net>

</configuration>

try changing Source=mssql.pipeten.co.uk\MSSQL\Databases;Initial Catalog=NeroLyl_one;User Id=xxxxxxxxxx;Password=xxxxxxx"

to Source=mssql.pipeten.co.uk;Initial Catalog=NeroLyl_one;User Id=xxxxxxxxxx;Password=xxxxxxx"

or tp Source=mssql.pipeten.co.uk\MSSQL;Initial Catalog=NeroLyl_one;User Id=xxxxxxxxxx;Password=xxxxxxx

still not working for me ? hmm sorry

[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) +739123
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
   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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
   AdsDataComponentTableAdapters.AdsDataAdapter.GetAdsByRandomOrder(Int32 NumRecords, Int32 AdStatus, Int32 AdLevel) +349
   AspNet.StarterKits.Classifieds.BusinessLogicLayer.AdsDB.GetFeaturedAdsSelection(Int32 maxNumAds) +72
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.FetchFeaturedAd() +14
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.GetFeaturedAd(HttpContext context) +107
   AspNet.StarterKits.Classifieds.Web.FeaturedAdCache.GetFeaturedAd() +12

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040
   System.Web.UI.WebControls.Repeater.GetData() +50
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
   System.Web.UI.WebControls.Repeater.DataBind() +72
   System.Web.UI.WebControls.Repeater.EnsureDataBound() +55
   System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12
   System.Web.UI.Control.PreRenderRecursiveInternal() +77
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360