To move a MS-SQL database to another server for DotNetNuke installation, you can follow this steps :

• Make sure to backup SQL(MS-SQL) server data and DNN(dotnetnuke) files before moving.
• Copy DNN files to the new server, restore the SQL data into the new SQL server.
• Delete the default DNN user login after you restore the SQL backup on the new server, I had experience that the old DNN user cannot login to the new SQL server and return a page is unavailable when you load the web pages.
• The SQL server may not let you delete the old user so easily, following are the steps I used.  First, delete the old user from the Security thread on the SQL server.  Then locate the DNN database and looks for the old user on the security thread within the DNN database.  You cannot delete the old user now, you must go to the roles, and locate the database roles thread, under this thread, there are several items with the word aspnet in the beginning.  Click its property and look for its owner, most likely it will be the old user name, change all these aspnet items owner to dbo.  After you made these changes, you can delete the old user from security thread.
• After fully deleted all old user items, you can create a new user login in the Security thread (not that one on the DNN database), map the new user to the DNN database and with db_owner right.
• After you created the new user, go to DNN database -> roles -> database roles, locate all aspnet items and change the owner to the new user you just created.
• After these changes, your SQL should be okay.

Best DotNetNuke Hosting Recommendation

ASPHostPortal.com provides its customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. ASPHostPortal.com offers DotNetNuke hosting starts from $5. We also guarantees 30 days money back and guarantee 99.9% uptime. If you need a reliable affordable DotNetNuke Hosting, we should be your best choice.