Error Occurred at the time of RTC Open

hi Experts,

i am using NAV 6 and SQL Server 2008 R2. When I want to open RTC the following SQL Server error(s) occurred:

17750,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:\Program Files\Microsoft SQL Server\MSSQL\Binn\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,

Sourav Dutta

try with this

http://blog.wibeck.org/2009/05/installing-store-procedures-for-dynamics-nav-2009-manually/

Hi Sourav,

Try by coping the xp_ndo.dll file from navision setup dvd to the location of the error and check if your rtc opens.

This file is required casue RTC runs on Windows Login only.

thanks mohana and manish