Move NAV 5.0 Database to another SQL server

duranmcneal

I need to move the NAV 5.0 database to another SQL server. What are the initial preps to make this transition?
I have copied a backup of the NAV database and restored it to the new server. The trace flag 4616 has been added to the startup parameter. On the client, when I attempt to connect to the database, an error message reads...
The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll is not available....

Not sure how to resolve this issue and if other modifications are necessary.
Your assistance is most welcome!
Regards,
Duran

DenSter

This has been discussed before, and I know that someone shared a script to put that together. Search this forum for the term "enumusersids" and you should get plenty of posts that will help you.