Migrate a Navision DB to another SQL Server

ta5

Hi
We are thinking about to migrate a Navision DB from one SQL server to another.

I have some doubts about the SQL server logins:

Windows-Logins:
I guess this should be alright because Navision sync. process will create the windows logins automatically. DB users that have special database roles should also still work, because the SIDS of the windows users are still the same. Would it also work if the new SQL Server is in a completely new domain?

DB-Logins:
I guess there would be some problems because first we have to create the new SQL server logins on the server. These new users will get different SIDS, so the datase users in the Navision database are kind of orphaned because they don't match the SID of the db login.

Any inputs on this topic would be very appreciated.
Thomas

jth

How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/kb/246133

kine

Of course, if you have new domain, you have new SIDs for the users...

ta5

No Problems with Windows-Logins (in same domain), is that right?