Move NAV 5.0 Database to another SQL server

duranmcnealduranmcneal Member Posts: 2
edited 2011-05-27 in SQL General
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

Comments

  • DenSterDenSter Member Posts: 8,307
    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.
Sign In or Register to comment.