Howdy, Stranger!
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
- 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
- 304 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Please Help- Noobie attempting web services with C/Side DB
Mike237548
Member Posts: 8
Hello mibuso forum!
I am not a microsoft partner... i am the CIO at a small textile company which uses Navision 4. We are currently in the midst of upgrading to NAV 2009 classic client through our Microsoft Certified partner. While upgrading, i found out about Nav2009's web services and i attempted to set it up with help from our certified partner. In doing so i ran into some issues and i hope someone on here can give me some advice or really any clue on how to fix it because i am SURE that our certified partner DOESNT HAVE A CLUE.
My first question is: Does web services work on NAV2009 classic using c/side database?
The problem i run into is: I have started/restarted web services and published a few services to get me started. But when i go to http://ip-address:7047/DynamicsNAV/WS/Services and login, i get the following error:
"<s:Envelope><s:Body><s:Fault><faultcode>a:Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLChangeListenerConnectionFailedException</faultcode><faultstring xml:lang="en-US">The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Cannot open database "E:\NAV\Database\Company.fdb" requested by the login. The login failed.
Login failed for user 'COMPANY\Administrator'.</faultstring><detail><string>The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Cannot open database "E:\NAV\Database\Company.fdb" requested by the login. The login failed.
Login failed for user 'COMPANY\Administrator'.</string></detail></s:Fault></s:Body></s:Envelope>"
Any suggestions? We dont use SQL here... yet it says it cannot connect to the SQL database. Can this be done with C/Side?
I am not a microsoft partner... i am the CIO at a small textile company which uses Navision 4. We are currently in the midst of upgrading to NAV 2009 classic client through our Microsoft Certified partner. While upgrading, i found out about Nav2009's web services and i attempted to set it up with help from our certified partner. In doing so i ran into some issues and i hope someone on here can give me some advice or really any clue on how to fix it because i am SURE that our certified partner DOESNT HAVE A CLUE.
My first question is: Does web services work on NAV2009 classic using c/side database?
The problem i run into is: I have started/restarted web services and published a few services to get me started. But when i go to http://ip-address:7047/DynamicsNAV/WS/Services and login, i get the following error:
"<s:Envelope><s:Body><s:Fault><faultcode>a:Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLChangeListenerConnectionFailedException</faultcode><faultstring xml:lang="en-US">The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Cannot open database "E:\NAV\Database\Company.fdb" requested by the login. The login failed.
Login failed for user 'COMPANY\Administrator'.</faultstring><detail><string>The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Cannot open database "E:\NAV\Database\Company.fdb" requested by the login. The login failed.
Login failed for user 'COMPANY\Administrator'.</string></detail></s:Fault></s:Body></s:Envelope>"
Any suggestions? We dont use SQL here... yet it says it cannot connect to the SQL database. Can this be done with C/Side?
0
Comments
No.
Sorry.
At the time that the middle tier as introduced
Microsoft knew that eventually C/SIDE (native) database would be retired, so they made the logical decision to not extend its use in anything new.
You need either to move to SQL or to manually implement web services using NAS.
Thank you so much for your assistance!
If we switch to SQL or use NAS... would we have to switch to the Role Tailored Client as well or could we stay with the classic client?
First of all I would NOT recommend going the NAS route, it can be done, its quite a bit of work, but in the long run you would be going down a dead end with no future prospects. BUT if you can not move to SQL then it really is your only decent option.
If you go to SQL, then the users can stay on Classic, and you can run the middle tier just for Web Services.
Your the best! Thank you so much!
Admin: please mark as closed
Knowing that eventually you would need to take the plunge and go full RTC from the next version on anyways?
Isn't that what I just said 8)
:oops: