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?

Thanks,

TV

not to mention, set the new, SQLCONNECTION within the web.config file

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:

http://blogs.snapsis.com/PermaLink,guid,87c379cc-c700-4eb8-a48d-e778aeef65fa.aspx

 

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

TV

If you are talking about links you entered into an HTML/Text module to point to other pages on your DNN site, then they still point to the original sites URL.  You need to update these references as well (just like you did the alias in the database) so they resolve to the correct pages.  This is a known "issue" and I know that is has been put on a list to see if links entered into the HTML/Text module can be dynamic and not have to be changed when the site moves to a different server / DNS name.  Cannot say at this time when this new feature will be included.

Thanks for that information.  Unfortunately, I'm unable to find this value.  Would you know what table this resides in?  Thanks

 

TV

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.