Last post Jan 25, 2006 11:54 AM by J7Mitch
Jan 24, 2006 01:50 PM|tekvaio|LINK
Ok..Let me to try explain myself. We have been using DNN for over 1 year and 1/2 now. Currently, it's being hosted from a remote server that I have limited access to, fortunately, I do have access to the Application Directory that it does reside in. We
currently access the portal through http://xxx.xx.com The new server (2003 server) that we will be using, I have complete access over. It has a copy of SQL 2000 and running IIS6. I copied over all of the files from the
Application Directory, set the 'Networ Service' account complete permissions over it., added this directory to IIS and used SQL Server "Data Transformation Services -->> import data" to copy over the DB... Well we did receive one error during the copy of the
data base that [Microsoft][ODBS SQL Server Driver][SQL Sever]SETUSER permission denied in databae 'xxxxxx'.
When I try to access this page through a browser... in the status bar it will act like it's search for this page, then for some reason, redirect to the existing site. There is no way that I can bring down the existing site. From here, I used TOAD to look
for any references to the old URL name. I saw portal alias and one other.. I changed both of them, now I'm able to get back in. Since I ran the Data Transformation Services again, and I'm back to where I was with the site getting redirected.
Any suggestions? Has this been done before?
Jan 24, 2006 02:34 PM|tekvaio|LINK
Jan 24, 2006 04:09 PM|j7mitch|LINK
the portal alias is what is causing the redirect as you figured out.
If you copy the data back over then you will need to change the record to match your new site location.
After changing the data directly in the databas you will need to restart the web app because the PortalAliases are cached.
See the blog below for more info:
Jan 24, 2006 05:39 PM|tekvaio|LINK
Thanks, that was a big help. That corrected my problem.. however, no for some reason, the links that I had to some documents are broken... I did transfer the directories over, it just seems that it's missing a extra level...?..?..
This is something that I can probably figure out, and will try to as i feel that I didn't hit a dead end. Thanks so much,,
Jan 25, 2006 02:12 AM|smehaffie|LINK
Jan 25, 2006 09:59 AM|tekvaio|LINK
Thanks for that information. Unfortunately, I'm unable to find this value. Would you know what table this resides in? Thanks
Jan 25, 2006 11:54 AM|j7mitch|LINK
It's in the HtmlText table, but it's not easy to change there because it is a text field.
The easiest way is to just go back and modify the Html module with the editor.
If there are a lot of modules and you would rather do it directly in the DB, then I would recommend connecting to it with MS Access through ODBC, so that the text fields can be edited.