SQL2005 4SP2 Client & 3.70A database converted from 2000 and WORKING

There are various post on this forum addressing SQL2005 and its issues. I mainly had problems with security and windows logins. Here, in brief, are the steps I followed to make it work:

Before: SQL 2000, Navision Client v4 SP2 4.0.2.22611, Navision 3.70A database

After: SQL2005, Navision Client v4 SP2 4.02.23099, Navision 3.70A database

Steps:

  1. Upgrade the Navision Client to 4.02.23099. This has the Security Model "Enhanced" & "Standard", I chose "Standard" (much better for Active Directory Groups = quick synchronise).
  2. Install xp_ndo.dll on SQL2005 box. Note: Follow the help file it is good enough. Note: You must set the permissions of "xp_ndo_enumusergroups" & "xp_ndo_enumusersids" to Public execute grant. (Databases -> System Databases -> Master -> Programmability -> Extended Stored Procedures). If you do not do this then you will get errors like "User Name and Password invalid" etc.
  3. Do a SQL backup (BAK) of the SQL2000 Navision database and restore it to SQL2005.
  4. Connect to Navision database with client and Syncrhonise All (you may have to use SA first). Do not try add the users via SQL use navision to add windows logins (I am not refering to SQL database logins in these steps!)
  5. Last step: Via SQL go to the Navision Database -> Views -> dbo.Session and add Permission for Public Execute Grant. This will allow windows logins to connect without making them SYSADMIN
  6. Should now be able to connect to the Navision with windows login.

The above steps are just a summary and believe me I went through a lot of hardship to come to this conclusion. So some of you may have done it first time but others may still be trying to figure it out. Hopefully this helps. Seems pretty straight forward now that I read it Surprise

Nic

 

Parents
  • Hi again ,

    After thanking in my last post , now I am having questions ... really i am still trying sqlsever 2005 with Navision on a local computer

    when you say install xp-ndo.dll  in sql 2005 box .... where in which folder ..?

    I ve gone to dbo.sesssions of database and trey to see Execute ... i couldn't seee else insert, update ,alter ,session ... so what do you mean exactly by execute grant ....

    Thank you again to post all you efforts in this summary ... hoping for me to finalize it also soon

     

     

Reply Children
Related
Recommended