SQL Server Database log in in Navision

Business Central/NAV Technical Forum
1

Hi Navision,

I can not able to access to the dynamics NAV , though my database pops up in the Database name I cant able to connect to navision. My SERVER is in client computer that I installed the Sql server 2008 in that single computer. So My question is can I able to connect to my compute which is both as client and server ? If tried to connect to with windows authentication it displays a message of …The extended stored procedure xp_ndo_enumusergroups in the library file xp_ndo.dll, is not available on the server…

I can not either login with the sql server login Id…

I appreciate for any help

Thanks

2

There are lot of posts available to fix xp_ndo_enumusergroups issue

http://dynamicsuser.net/blogs/stefanetti/archive/2011/08/31/install-amp-config-quot-xp-ndo-enumusergroups-quot-quot-xp-ndo-enumusersids-quot-nav-sql-extended-stored-procedures.aspx

http://blogs.msdn.com/b/nav_developer/archive/2008/11/05/basic-sql-creating-extended-stored-procedure-xp-ndo-dll.aspx

3

thanks Mohan …

It WORKS…