Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
navision sql proc xp_ndo.dll
mpudja
Member Posts: 32
Hi,
When I trying to connect with windows authentication I get error for xp_ndo.dll .
I have executed this code for enumusergroups and enumusersids
USE master
GO
EXEC dbo.sp_addextendedproc N'xp_ndo_enumusergroups',
'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll'
GO
GRANT EXECUTE ON "xp_ndo_enumusergroups" TO PUBLIC
GO
EXEC dbo.sp_addextendedproc N'xp_ndo_enumusersids',
'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll'
GO
GRANT EXECUTE ON "xp_ndo_enumusersids" TO PUBLIC
GO
This folder C:\Program Files (x86)\CSIDE Client\xp_ndo.dll, here is CSIDE Client and as I see the Client isn't installed properly, someone just copied client folder on server
Also I saw that we have 64-bit operating system and we using NAV 5.0 SP1.
When I trying to connect with windows authentication I get error for xp_ndo.dll .
I have executed this code for enumusergroups and enumusersids
USE master
GO
EXEC dbo.sp_addextendedproc N'xp_ndo_enumusergroups',
'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll'
GO
GRANT EXECUTE ON "xp_ndo_enumusergroups" TO PUBLIC
GO
EXEC dbo.sp_addextendedproc N'xp_ndo_enumusersids',
'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll'
GO
GRANT EXECUTE ON "xp_ndo_enumusersids" TO PUBLIC
GO
This folder C:\Program Files (x86)\CSIDE Client\xp_ndo.dll, here is CSIDE Client and as I see the Client isn't installed properly, someone just copied client folder on server
Also I saw that we have 64-bit operating system and we using NAV 5.0 SP1.
0
Answers
C:\Program Files (x86)\CSIDE Client
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Also, I check xp_ndo_enumusergroups, xp_ndo_enumusersids extendnd proc and all seems fine.
http://blog.wibeck.org/2009/09/changing-stored-procedure-to-64-bit-in-nav-2009/
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
RIS Plus, LLC
MVP - Business Apps
I have add dll in folder but the problem is still there.
I remeber that I have the same situation one year ago and I didn't have a problem with this. I just choose root from CSIDE Client root directory, select dll and the end give permission to PUBLIC.
I just replace old dll with new one from instalation folder....