Microsoft Dynamics NAV (Archived)

Sql server error

(0) Share

Report

Posted on by vinod kp

540

Hello

While checking the web Service availability i am getting the following error :

The following SQL Server error or errors occurred: 17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL xp_ndo.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). SQL: INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}

Thanks in Advance,

Regards

Vinod

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Daniel Rimmelzwaan 3,485 on at

Like (0)

Report

You've asked about this before:

https://community.dynamics.com/forums/p/20785/32587.aspx

Was this reply helpful? Yes No
epernst 1,122 on at

Like (0)

Report

Sometimes asking it twice makes more people hear it. And in this case you never answered his first question, only the second!
But the better way, instead of asking the same question again, is to "bump" the question - but not until - like in this case - after one week!

Was this reply helpful? Yes No
Daniel Rimmelzwaan 3,485 on at

Like (0)

Report

I don't see two questions in there, the only problem he's describing is about the extended stored procedure. Once that problem is solved there should be no more error message, at least not about the extended SP.

Was this reply helpful? Yes No
Patrick Mwiandi 15 on at

Like (0)

Report

I am also experiencing the same error even after creating the two procedures. So he is asking two different questions.

Was this reply helpful? Yes No
Richie 5 on at

Like (0)

Report

I know that this thread is old but I found the same problem and after a lot of "solutions" I dropped both procedures and did them again. The problem was the path. DO NOT use any script to do it. Do it manually. Go to master database,Programmability,Extended Stored Procedures and create ne procedures. Write the name carefully.Select the xpo_ndoxxxx.dll file using the browser and then grant [public] with execute rights. Hope this helps cause it drove me nuts for a while.

Was this reply helpful? Yes No
Mouli Kaku 517 on at

Like (0)

Report

USE master

EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'

GO

USE master

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

GO

GRANT EXECUTE

ON [xp_ndo_enumusergroups]

TO PUBLIC

GO

GRANT EXECUTE

ON [xp_ndo_enumusersids]

TO PUBLIC

GO

******you know that you need to have xp_ndo.dll copied into MS SQL BIN folder******

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You have to setup the stored procedures in SQL and grant them public permissions.

Read this article for a step by step on how to do it correctly:

blogs.msdn.com/.../basic-sql-creating-extended-stored-procedure-xp-ndo-dll.aspx

Regards,

-Giancarlo

Was this reply helpful? Yes No
Renato Fajdiga 1,853 on at

Like (0)

Report

I have the same problem BUT when I enter the path to the xp_ndo_dll and then click OK (after I select public user and put 2 check marks) and come back to see is the path still there, it shows me blank line like I didn't select any path. Do you know how to solve this problem?

Was this reply helpful? Yes No
Mouli Kaku 517 on at

Like (0)

Report

Hi Renato Fajdiga ,

USE master

EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'

GO

USE master

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

GO

GRANT EXECUTE

ON [xp_ndo_enumusergroups]

TO PUBLIC

GO

GRANT EXECUTE

ON [xp_ndo_enumusersids]

TO PUBLIC

GO

******you know that you need to have xp_ndo.dll copied into MS SQL BIN folder******

and also if u r using Windows 8 or 2012 check for u r UAC settings and you need to be admin .

And u need to have read write permisions to the bin folder

MOULI KAKU

Was this reply helpful? Yes No