ASP pages not working after move to new server |
Post Reply |
Author | |
DonnaT
Newbie Joined: 24-May-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
Posted: 20-January-2010 at 3:00pm |
I moved my website to a new server. All files appeared to upload seamlessly. The home page and any .html page on the site will load just fine. However, any productcart asp page (eg. CustPref.asp,, viewcart.asp, contact.asp, checkout.asp etc) will not load. The store has basically been disabled. I get http 500, website cannot display the page. Any thoughts regarding why this is happening?
|
|
netprofits
Certified ProductCart Developers Joined: 05-January-2006 Location: United States Status: Offline Points: 22 |
Post Options
Thanks(0)
|
Does the web hosting company support ASP and is it enabled for this site. If they do, has the Product Cart database been moved to the new hosting service and is the connection string setup correctly. The new hosting will problably have a different server setting for the database. Or if you're using Access you would need to make sure the permissions are setup correctly.
Also, in your browser make sure you turn off "friendly HTTP error messages" (Tools | Internet Settins then Advanced tab) so you get real error messages with the problem.
|
|
DonnaT
Newbie Joined: 24-May-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
The asp page problem is now resolved. I pushed another copy of the ProductCart directory to the server from home (avoiding corporate routers/filters). I can now see asp pages through my browser. However, the new sql database is still not working. The new database has a different name from the original one. I restored the data from the origianl database to the new one and ensured that the connection string was set up correctly (diagnostics confirms that it was). However, I still have no access to the database from the site. it should be noted that when I restored the database, it reported that the database was restored successfully but also reported an "orphaned user" (it wa actually the name of the original dbo). It looks like the tables in my new database are still owned by the former sql user and not recognized by the new dbo?? Not sure how to change ownership of sql tables if that is indeed the problem. Anyone have a quick fix for that?
|
|
netprofits
Certified ProductCart Developers Joined: 05-January-2006 Location: United States Status: Offline Points: 22 |
Post Options
Thanks(0)
|
I would recommend contacting your web hosting support department for help. They should be able to help you restore the database correctly and create the correct user account in the database.
|
|
Guests
Guest |
Post Options
Thanks(0)
|
Yep, sounds like a problem with db ownership.
Do you have access to the SQL server? You can run a script in Querry Analyzer to reset the ownership to reset the ownership back to "dbo" rather than the username that is probably in there now.
|
|
DonnaT
Newbie Joined: 24-May-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
Thanks, Sean! I ran an SQL script to take care if the name problem and it it worked. However, it states that I have an "orphaned user" (which has the same name as the previous database) so I still cannot access my database from the website. I have found an SQL command that will hopefully resolve this
EXEC sp_change_users_login 'Auto_Fix', 'Username' but do not have the rights to run it on the server. I am now awaiting assistance from my webhoster :( |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |