Hi all,
When I try to open the database in finsql , I am getting a error as shown below.
"The extended stored procedure xp_ndo_enumusergroups" in the library xp_ndo.dll is not available on the database server CHANDRU.
until this procedure and library have beed added, you cannot connect to this server from Microsoft Dynamics Classic or Microsoft Dynamics Server with windows authentication.You can still connect to database authentication using Microsoft Dynamics NAV Classic.
If anybody knows the solution to overcome this error, Kindly suggest.
Thanks in advance.
Regards,
chandru.
0
Comments
RIS Plus, LLC
this is very common question. Here's a solution:
http://www.mibuso.com/forum/viewtopic.php?t=23575&highlight=
it is all in the manuals and on Mibuso and DynamicsUser.net. And if you are not comfortable with SQL, please let an administrator do it for you.
But here is a short description what you need to do
1. Add the extended stored procedure "xp_ndo_enumusergroups" to the master database
2. Add the extended stored procedure "xp_ndo_enumuserids" to the master database
3. Grant execute rights to public for both stored procedures.
4. Enable traceflag 4616 and restart your sql service.
then you will be able to log on using your windows login.
Hope this helps,
Regards,
Willy
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!