Problem with setting up NAS with SQL Server

ajaybabuCh

Hi

The following is the problem while trying to connect SQL server through NAS.

The description for Event ID ( 20010 ) in Source ( 018CC43AB7704F2-SQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: The extended stored procedure xp_ndo_enumusergroups in the library file xp_ndo.dll, is not available on the 018CC43AB7704F2 server.


I got setup everything, including xp_ndo.dll in the Binn file.


I didn't put any messages in my single instance codeunit. I wrote some code which will write create a text file in the specified drive to test the connection.

But its failed to connect to SQL db and throwing the above message.

anything else do I need to setup for SQL Server to work with NAs.

regards
ajay

ara3n

Hello ajay
Nas requires windows authenication to login. So the xp_ndo.dll file needs to be put in binn folder, and from query analyzer you need to "register" the stored procedure. In the installation CD. there is readme.txt file that explains on how to install this. it's in SQL_ESP folder if I remember correctly.

Also from navision you need to add the windows user that the service is login in as and give it correction permission roles.

ajaybabuCh

thanq rashed its working now

ara3n

great!!