install xp_ndo.dll on SQL SERVER

santabat

Hi everybody,

I'm try to setup NAS for SQL 2005 server.
I´ve installed both procedures xp_ndo_enumusersids and xp_ndo_enumusergroups executing this query,

USE master
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

no problem at all.

but whem i´m trying to run the 'Microsoft Dynamics NAV Application Server SERVSQL-SQL' service I get this alert in the application event viewer:


"...the extended stored procedure xp_ndo_enumusergroups in the library file xp_ndo.dll, is not available on the SERVSQL server...."

what con i do??

thanks a lot for ur help
regards,

PS: Nav 5.01
SQL server 2005
windows 2003 server R2

santabat,,

kine

You need to install the SP with name xp_ndo_enumusergroups as well (with same script, only replace xp_ndo_enumusersids by xp_ndo_enumusergroups), it is part of same DLL...

santabat

thanks a lot,,, solved

kine

santabat wrote:

thanks a lot,,, solved

If solved, please, change the satus of your first post to "Solved".


and...


you are welcome... 8)

David_Singleton

santabat wrote:

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

:?:

Are you running 32 bit SQL on a 64bit OS?

DenSter

Looks like it is x64, in which case you need to use the x64 version of xp_ndo.dll. Read the readme.txt file in the esp_sql folder for detailed instructions. It's basically the same procedure, but with a different dll

Mammo

As Den Said for 64 bit it is different dll file which is xp_ndo_x64.dll. It has to be copied manually at virtual SQL in Binn directory of SQL. And has SP to be resigter same way as described earlier

kine wrote:

You need to install the SP with name xp_ndo_enumusergroups as well (with same script, only replace xp_ndo_enumusersids by xp_ndo_enumusergroups), it is part of same DLL...

If we create database and transactionlog on same partition or drive letter then it work fine but there is one problem if we have 2 drive letters assigned by Virtual SQL on cluster and you try to save Transaction log on different partition it gives attached error does any one have idea to resolve this error?

Regards,

DenSter

Put the dll on both physical clusters, in the same folder, and then it should work.

Mammo

Hi Den,

The error which is sent in the picture in my last post is not related to xp_ndo_x64.dll. I already copied this file to both the nodes of cluster but error is still the same. I think this error is related with clustering or SQL itself. I dont know and still looking for solution.

Regards

DenSter

Mammo wrote:

The error which is sent in the picture in my last post is not related to xp_ndo_x64.dll

Then don't post it in a thread about xp_ndo, and start your own topic.