DotNetNuke - tips when copying existing Dnn to another server

You want to copy database and DNN folder to another web server and SQL server.
If you think you fixed conn. string and DNN keeps showing Install wizard make sure to do bellow steps.
SQL:
1. Drop user that is used for conn. string and recreate it on SQL server with DBO rights. Assign it to your database
2. Add in table PortalAlias your new domain because it probably changed.

Web.config
1. Use IIS section Conn.string & AppSettings to change conn.strings. Use  .   for local SQL and DON'T use integrated security since IIS does not work under them.ms

Verify in web.config did IIS designer screwed up conn string section.