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
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
WebServices NavDatabasePasswordException
blackc2004
Member Posts: 16
Hello all,
I'm having a very frustrating time getting web services to work on separate servers. We're running NAV 2009R2 on a MSSQL Server on 2008R2. We also have a separate IIS/Web service box running Windows 2008R2.
I have worked with our partner and read a lot of forums regarding the navdatabasepassword exception and I've got it almost working. Here are the steps I am taking currently to reproduce my error:
1) Reboot all servers, SQL, IIS, etc
2) Log into the IIS Server and access the WS URL: http://localhost:7047/DynamicsNAV/WS/Services
2a) I receive a list of the WS
3) Go to my desktop, access the WS URL: http://calax-iisdev-01:7047/DynamicsNAV/WS/Services
3a) I get a NAVDatabasepasswordexception error
4) Go back to the IIS server and access the same URL: http://calax-iisdev-01:7047/DynamicsNAV/WS/Services
4a) I receive a list of my webservices
5) Go back to my desktop and refresh the URL. I now get my list of services.
This is very frustrating because once you access it locally, it will then work from any other desktop computer. Does anyone have any more suggestions or have you seen this happen before? I need to get this to a point where it's stable and reliable as we would really like to start working on some apps which will consume the WS.
I'm having a very frustrating time getting web services to work on separate servers. We're running NAV 2009R2 on a MSSQL Server on 2008R2. We also have a separate IIS/Web service box running Windows 2008R2.
I have worked with our partner and read a lot of forums regarding the navdatabasepassword exception and I've got it almost working. Here are the steps I am taking currently to reproduce my error:
1) Reboot all servers, SQL, IIS, etc
2) Log into the IIS Server and access the WS URL: http://localhost:7047/DynamicsNAV/WS/Services
2a) I receive a list of the WS
3) Go to my desktop, access the WS URL: http://calax-iisdev-01:7047/DynamicsNAV/WS/Services
3a) I get a NAVDatabasepasswordexception error
4) Go back to the IIS server and access the same URL: http://calax-iisdev-01:7047/DynamicsNAV/WS/Services
4a) I receive a list of my webservices
5) Go back to my desktop and refresh the URL. I now get my list of services.
This is very frustrating because once you access it locally, it will then work from any other desktop computer. Does anyone have any more suggestions or have you seen this happen before? I need to get this to a point where it's stable and reliable as we would really like to start working on some apps which will consume the WS.
0
Comments
This indeed is frustrating. We've been through this parallel to you, i.e. the last days, and got it working. Reading your list and matching it to our experience it's all about the delagations you need to set. Did you get that done already?
Have a look here for details: Walkthrough: Installing the Three Tiers on Three Computers.
Indeed, this was very "funny".
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
I've attached screenshots of my SPN's and URLACL's
Shouldn't they be able to just auto create this stuff when you install the service? All my services (MSSQL, IIS, NAV WS server) are all running under the same AD username.
These are in general terms the spn's we have with the commands to set them.
Notes
* I am working on a more extensive description; will follow later
* using ADSI Edit tool can do all things much better; will also pay attention to that later
* the post, Troubleshooting multi-machine installations of NAV 2009, is also very useful
* before performing netsh http add urlacl ... make sure to delete the urlacl first; see also httpcfg - problem
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
fingers crossed!