Dynamics NAV - Restore NAV company to a new SQL Server - Setup test instance on different domain

Related Errors:
The Microsoft Dynamics NAV server is currently not ready to serve requests. Try again later or contact your system administrator.

• After installing Nav, ensure that all service account information remains unchanged until you can successfully login to your restored database
• Backup and restore company database to new server
• Whatever account you install nav with, you must reset the sql security for that account
• The NT AUTHORITY\NETWORK SERVICE security info will be incorrect when coming from a restore
• If you are using the network service account for your install, you must go to SQL Manager>Security>Logins>NT Authority\NETWORK SERVICE 
• Remove the default user mapping (to remove old network user credentials)
• re-add the user mapping
• Add your new administrator account to sql
• Add it to the db_owner role
• 
  
• Ensure NAV services are configured to use new accounts
• Use the SQL full name and user full domain names, avoid using . or localhost
• Set new admin account as db_owner under Security>Logins>User>Properties>User Mapping
• Drop all users to allow you to login with new admin account

------------------------------------------------------------------------
USE [MyDB]

GO

delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]
---------------------------------------------------------------------------

• Grant full access to your new admin user

USE [master]

GO

CREATE LOGIN [navdemo1\cloudadmin] FROM WINDOWS 

CREATE USER [navdemo1\cloudadmin] FOR LOGIN [navdemo1\cloudadmin] 

GRANT SELECT ON [master].[dbo].[$ndo$srvproperty] TO [navdemo1\cloudadmin]

GO

USE [CRONUS]

GO

CREATE USER [navdemo1\cloudadmin] FOR LOGIN [navdemo1\cloudadmin]

ALTER ROLE [db_owner] ADD MEMBER [navdemo1\cloudadmin]

GRANT VIEW DATABASE STATE TO [navdemo1\cloudadmin]

• Restart SQL Service
• Restart NAV Services
•