Windows Authentication Problems

paullynch
Member Posts: 27
Having problems trying to implement windows authentication.
Setup is NAV 5.0 SP1, Windows 2003 64bit, SQL2005, Security model standard.
Added myself as a windows logon in NAV with appropriate permissions.
Initially was getting "invalid username and password". Subsequently have added the extended stored procedures (xp_ndo_enumusersids and xp_ndo_enumusergroups) as per the installation and system management doc. and now get the following error
Does anyone have any suggestions?
Many thanks
Paul
Setup is NAV 5.0 SP1, Windows 2003 64bit, SQL2005, Security model standard.
Added myself as a windows logon in NAV with appropriate permissions.
Initially was getting "invalid username and password". Subsequently have added the extended stored procedures (xp_ndo_enumusersids and xp_ndo_enumusergroups) as per the installation and system management doc. and now get the following error
17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
SQL:
INSERT INTO [#$ndo$groups]EXEC [master]..[xp_ndo_enumusersids]
Does anyone have any suggestions?
Many thanks
Paul
0
Comments
-
Did you grant execute rights to public on the extended stored procedures?0
-
Have you followed these procedures http://msdn.microsoft.com/en-us/library/dd568724.aspx0
-
DenSter wrote:Did you grant execute rights to public on the extended stored procedures?fig wrote:Have you followed these procedures http://msdn.microsoft.com/en-us/library/dd568724.aspx
works a treat now
thanks
Paul0 -
If I had read your post after my morning coffee instead of before, I would have caught that
good to hear you found the solution and thanks for the feedback.
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions