So far i have the site set up and my self set as the administrator.

I have then set up the web config with the the sql connection string provided from my hosting provider.

Saved all documents

Then uploaded my site to the ftp server.

I get the error -

You probably got a runtime error somewhere. You'll need to disable customErrors from webconfig to be able to see what the problem is. After you identify the problem you can turn it back on again.

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

Change that to:

ashmetry:

You probably got a runtime error somewhere. You'll need to disable customErrors from webconfig to be able to see what the problem is. After you identify the problem you can turn it back on again.

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

Change that to:

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

 

Yes i have done this. still have the same screen coming up!!! the only other page i can view if i upload it again is the original welcome.html page by typing in the complete url.

please help lol its driving me insane.

I would remove that tag completly for test. Also check your Global.asax to make sure you are not doing anything special in Application_Error. Also try to check the settings on your hosting account to see if you've setup a custom errors page there.

The html page is working because simply its not an asp.net page :)

Sometimes the initial loading can be a pain.

But who are you hosting with?

Did you set the asp.net runtime to version 2.0?

Unless you setup with the rare provider that will allow your databases to be uploaded through the App_Data folder,

you are going to have to set the two databases up from scratch.

Another option is the tag that Ash was refering to, the Off is case sensitive, and I always remove the redirect part aswell.

Like this:

<customErrors mode="Off"/>

Let us know what's happening and we can help you fix it.

Daniel Meis

Awesome i have just change alot of things and have deleted all hosted data and have uploaded from scratch to help prevent previous errors from repeating.

According to my service provider i have ASP .NET 2.0 runtime on my 2005 edition SQL Server

The custom errors string is set to Off with the capital O

And i have installed the sql server script to the web.config file as the provider has instructed and removed the privious script with the notation lock <!--   -->

I have not uploaded anything to the sql server.

Your help and ash's help is very much appreciated.

Thanks

I will return in about ten minutes to let you know how the upload went

 Ok some progress :-) i hope lol

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unrecognized element.

Source Error:

Line 68:         -->
Line 69:         <add name="classifiedsConnection" connectionString="Data Source=p3swhsql-v09.shr.phx3.secureserver.net; Initial Catalog=xxxxxxxxxx; User ID=xxxxxxxxxxx; Password='xxxxxxxxx'" />
Line 70:     </connectionStrings>
Line 71:     - <system.net>
Line 72:         - <mailSettings>

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Not sure, but can there be single quotes around the password? Try without these maybe

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>

Above is the new message!!!!

The only problem with custom errors mode error is that it is how it is in my web.config file

Try adding this to your web.config

<compilation debug="true" />

It needs to be inside one the system.web tags.

And you still have the custom errors mode set to Off in your online version, Right?

If there's still no luck, post your connection strings, xxxxx out userids and passwords.

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

<compilation debug="true" />

<pages styleSheetTheme="Red"/>

<membership>

<clear/>

</providers>

<profile enabled="true">

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

<add name="MemberId" defaultValue="0" type="System.Int32"/>

</properties>

<roleManager enabled="true"/>

<providers>

<add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>

</siteMap>

<connectionStrings>

<add name="classifiedsConnection" connectionString="Data Source=p3swhsql-v09.shr.phx3.secureserver.net; Initial Catalog=xxxxxxxx; User ID=xxxxxx; Password='xxxxxxxx'/>

<system.net>

<smtp>

</smtp>

</system.net>

</configuration>

Who's your host, GoDaddy?????

And how come you only have one connection string, or did you combine both databases into one?

No the data base's are set up just as they came in the kit

im guessing that is one of my problems

And my service provider is www.domainsrightnow.com

Im hoping thats not a problem

So my host is GoDaddy, so the format might be a little different, but here's mine.

<connectionStrings>
    <add name="classifiedsConnection" connectionString="xxxxxxxxxxxxxxxxxxxxxx;
      Initial Catalog=xxxxxxxxxxx;
      User ID=xxxxxxxxx;
      Password='xxxxxxxxx';" />

    <remove name="LocalSqlServer"/>

    <add name="LocalSqlServer" connectionString="xxxxxxxxxxxxxxxxxxxxxxxxxx;
      Initial Catalog=xxxxxxxxxxxxxxx;
      User ID=xxxxxxxxxx;
      Password='xxxxxxx';" />

  </connectionStrings>

Try a layout like that, and make sure you leave in the LocalSqlServer

That name is referenced elsewhere as well.

Good Luck

Yes i have done that now and is both the connection strings the same??

I did some investigation and go daddy and domainsrightnow are identical apart from domainsrightnow are cheaper lol.

The following is the new error:

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)

Im getting a head ack

No, they are not the same.

The first one points to your classifieds_Ads database, and the second points to your members database.

Ok so that brings me back to my original question!!!!

Do i have to upload anything to the hosted SQL server?

And how do i achive connecting the 2 data bases sitting on the ftp server to the sql server? (isnt this done with the strings below?)

<connectionStrings>

<remove name="LocalSqlServer"/>

</connectionStrings>

Now I am not hosting with the same provider, so I could be wrong, but it looks like your second connection is correct.

Your first needs to be written like the second.

I looked at domainsrightnow and it looks like it is a lot like GoDaddy, I am assuming that you set up with the deluxe plan, so you would get 2 MsSql databases.

And when I did it, I created two databases, on godaddy it created all the standard aspmember tables automatically.

So the members database needed no manipulation, and the Ads Database I had to delete the auto created tables, views, and stored procedures.

Then it had a tool called query analizer, basically it runs Sql scripts.

I used a database program to convert my altered database to Sql and ran the scripts.

If you made no modifications to your database then you can use the included .sql files in your App_Data folder.

I can go into more detail if you need it.

But I think the main problem you are having is that your connection string is telling the application to run the Ads database locally.

So start with writing your connection strings in the same format as the second, but pointing to the two databases,

Ads first then the members one second.

Yes i realised the string was wrong just after my last post and corrected it. so now im hoping the web config file is correct.

Now to the data base. so i do have to upload information. thats cool i will have a go at it. I also have a go daddy account and yes the interface and everything else is very much the same but i prefer to use domainsrightnow due to there ongoing deals that undercut go daddy.

And no i have only one mssql server but can set up a second one if neccessary!! do i need to modify or just insert scripts to query??

So the scripts i need to query in the analizer are they the 3 files in app_data folder ending with .sql??? no i have not changed anything yet.. and do i do this on the second MS SQL server??

And i Set the string in the web config file so it points to the second sql server as the classifiedsConnection yes???

Below is the current error that im assuming will be gone once i have done the above

Could not find stored procedure 'GetAdsByRandomOrder'.

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: Could not find stored procedure 'GetAdsByRandomOrder'.

Ok so i have set up the second MSSQL data base and configured the strings to suite.

Problem....... the website cannot be found through htp://

Whats gone wrong