Installation Traumas

Ok, I have been having several problems with uploading and getting nopcommerce to work on 123 reg hosting.  firstly every thing runs fine on the local machine.  I have uploaded all files via FTP using webmatrix "Publish" button.  The .sql File has been loaded to the hosted database by the host support.  The web.config file and the settings file in App_data have been modified to point at the hosted database.

Now when I look at the site I get:

Server Error in '/' Application.

Login failed for user 'ATLAS\W3SVC4667_Anon_cjpme'.

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: Login failed for user 'ATLAS\W3SVC4667_Anon_cjpme'.

After all the other problems I have had I'm just about ready to pull my hair out.

Why does the site use this login for the database? How/Where do I find out which users are registered?

Any help would be greatly appreicated
Chris

If you've "uploaded all files via FTP", then you've included the /App_Data/Settings.txt file which includes the connection string for your local PC database.  That won't work on your host.  You need to ask your host support for the connection information for database that was "loaded to the hosted database by the host support".  Then edit the Settings.txt file.

I have already changed the settings.txt file to point at the hosted database.

chris.07970 wrote:

The user in question is not a nopCommerce user account.

It is the SQL user account used by nop to log into the SQL database.

So the problem lies either with the settings.txt file having the wrong user details or the nop SQL database not having the correct user details set up.

HTH

Thanks for the reply,

How do I set up the correct user details on the nop SQL database?

Just an update,

All of my problems were solved very simply by moving from 123 reg hosting. Their tech support was hopeless just kept telling me to clean my database and re-upload, despite the fact I tried a clean install with "create database" ticked, and the fact I could not upload a script using their database uploader.

I have moved to Arvixe and my site was up, connected and using original database in under an hour!

I will neither bad mouth 123-reg or praise arvixe, just leave you to make up your own mind!

Just an update,

All of my problems were solved very simply by moving from 123 reg hosting. Their tech support was hopeless just kept telling me to clean my database and re-upload, despite the fact I tried a clean install with "create database" ticked, and the fact I could not upload a script using their database uploader.

I have moved to Arvixe and my site was up, connected and using original database in under an hour!

I will neither bad mouth 123-reg or praise arvixe, just leave you to make up your own mind!