Sql2k8 (x64) fails on PassPidBackFromComponentUpdate 0x80070006 (E_HANDLE)

We were trying to install sql server 2008 from an MSDN subscription and we got an error message 0x80070006 (E_HANDLE). After some googling we found that is a MSDN bug and the solution to the problem was in the product key selection to simply select the "Specify a free edition" radio button without changing the shown PID, then reselect the "Enter the product key" radio button (again without changing the PID). That was crazy... The original post of the solution can be found here.

How to setup xp_ndo.dll

If you need to setup xp_ndo.dll on 32bit machines for Microsoft Dynamics Nav 5 - 6, follow the steps bellow:

1. Copy xp_ndo.dll to binn folder of sqlserver (ex. C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSERVER2008\MSSQL\Binn)

2. Run the following commands in management studio:

USE master

EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSERVER2008\MSSQL\Binn\xp_ndo.dll'

GO

GRANT EXECUTE

ON [xp_ndo_enumusergroups]

TO PUBLIC

GO

EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Archivos de programa (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\xp_ndo.dll'

GO

GRANT EXECUTE

ON [xp_ndo_enumusersids]

TO PUBLIC

GO

Strange Navision Problem

Last week I encountered with the following bizarre problem. In purchase orders I made a post of receipt and immediately I made a post of invoice. Because I forgot to put the related document no. of vendor the invoice throws an error (thats normal). Navision made a rollback of the transaction but the strange thing was that it rollback the receipt as well. At first I thought it was something wrong with our custom code but after an extensive examination I found that the problem was that after the post of receipt the transaction was not closed and when the invoice failed to post the rollback was made to the point before the post of receipt. I tried the same thing but I closed the purchase order form after the receipt, I opened it and then I made the invoice. Now it worked! For the record I used Navision 5.0 sp1 with sql server 2008 developer edition on windows xp sp3. In order to bypass the problem, I made an fbk backup and restore to a new database (the sql backup replicated the problem)