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 184.108.40.20611, Navision 3.70A database
After: SQL2005, Navision Client v4 SP2 4.02.23099, Navision 3.70A database
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
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
You need to store it in your SQL bin folder. In SQL 2005 it is the bin.1 folder or something like that, but I cannot check at the moment.
After that you need to add it as an extended stored procedure to the master database.