NAV 5.02 Stored Procedures SQL

fandersen

Hi,

I'm getting an error when i start my NAV Client:

17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL "C:\Program Files\Microsoft SQL Server\MSSQL.10.NAV\MSSQL\Binn\xp_ndo_x64.dll, or one of the DLLs it references. Reason: 126(failed to retrieve text for this error. Reason 15100).

SQL:
INSERT INTO [#$nd$groups] EXEC [master]..[xp_ndo_enumuserids]

I've executed the following query on my SQL server:
USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL10.NAV\MSSQL\Binn\xp_ndo_x64.dll'
GO
GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO
USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, '"C:\Program Files\Microsoft SQL Server\MSSQL10.NAV\MSSQL\Binn\xp_ndo_x64.dll'
GO
GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

I've checked that the dll path is correct, but i still get this error.

My server is running 2008 x64 and SQL 2008 x64.

Thanks in advice...

Best regards,
fandersen

stryk

Hi!

Check for type mismatches - in the error description you are referencing to "xp_ndo_enumuserids" (there's an "s" missing: xp_ndo_enumusersids).

Also, try to create the XP manually, by selecting the DLL.

Does this work?

fandersen

Hi,

I removed all my stored procedures and did the following:

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL10.NAV\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO
USE master
EXEC sp_addextendedproc xp_ndo_enumuserids, '"C:\Program Files\Microsoft SQL Server\MSSQL10.NAV\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE
ON [xp_ndo_enumuserids]
TO PUBLIC
GO

And i renamed the dll file to xp_ndo.dll

But now the NAV client says:
The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll, is not avilable on the SQL01 server.

Until this procedure and library have been added, it will not be possible to connect to this server from Microsoft Dynamics NAV with Windows Authentication, but you will still be able to connect with Database Server Authentication.

It seems it should be enumusersids

/fandersen

DenSter

You shouldn't have to rename the dll, just use the right one and set the proper path and filename. On a SQL Server cluster you will need to put a copy of the dll on both nodes.

stryk

DenSter wrote:

...and set the proper path and filename.

That's why I suggested to select the file with the GUI in SSMS, just to avoid any mismatches ...

DenSter

stryk wrote:

just to avoid any mismatches ...

Exactly why I generally don't use scripts to install the esp's

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]