Problem regarding webservices

marvinqvist
Member Posts: 53
Hi,
I have created some webservices which works perfectly on my computer when calling localhost:7047 from either browser og Visual Studio. Everything is as it is suppose to. Locally it is running on a SQL server with database name "Demo Database NAV (6-0)". I could not see that would change anything when developing.
But now the problem appears. I have made a full backup from Nav2009, and restored it on the actual server. The database name on the server is "NavDB". Everything works perfectly in Nav2009, but when I want to call my webservice in a browser ("http://localhost:7047/DynamicsNAV/WS/Companyname/Services") to see if the connection is up and running (I have checked that the service on the server is started), then I get an error message which says:
<faultcode xmlns:a="urn:microsoft-dynamics-schemas/error">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 due to the following error: Cannot open database "Demo Database NAV (6-0)" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.</faultstring>
- <detail>
<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server due to the following error: Cannot open database "Demo Database NAV (6-0)" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.</string>
</detail>
First of all I do not understand why I get a response that the database "Demo Database NAV (6-0)" is not available. This database never existed on that server. How do I change the code such that it looks for "NavDB" instead of this default database.
Secondly it seems that the problem has to do with some security rights at the SQL server. I am running SQL Server 2008. How can I change the security so that the webservice is allowed ?? I have tried to adjust the rights, but what works locally at my pc does not work on the server.
I am lost here...
Looking forward to get some response
/MHQ
I have created some webservices which works perfectly on my computer when calling localhost:7047 from either browser og Visual Studio. Everything is as it is suppose to. Locally it is running on a SQL server with database name "Demo Database NAV (6-0)". I could not see that would change anything when developing.
But now the problem appears. I have made a full backup from Nav2009, and restored it on the actual server. The database name on the server is "NavDB". Everything works perfectly in Nav2009, but when I want to call my webservice in a browser ("http://localhost:7047/DynamicsNAV/WS/Companyname/Services") to see if the connection is up and running (I have checked that the service on the server is started), then I get an error message which says:
<faultcode xmlns:a="urn:microsoft-dynamics-schemas/error">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 due to the following error: Cannot open database "Demo Database NAV (6-0)" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.</faultstring>
- <detail>
<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server due to the following error: Cannot open database "Demo Database NAV (6-0)" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.</string>
</detail>
First of all I do not understand why I get a response that the database "Demo Database NAV (6-0)" is not available. This database never existed on that server. How do I change the code such that it looks for "NavDB" instead of this default database.
Secondly it seems that the problem has to do with some security rights at the SQL server. I am running SQL Server 2008. How can I change the security so that the webservice is allowed ?? I have tried to adjust the rights, but what works locally at my pc does not work on the server.
I am lost here...
Looking forward to get some response
/MHQ
0
Comments
-
Your problem doesn't seem to be related to Web Services, and you probably would have the same problem if you try to connect to a Service Tier with a Role Tailored Client.
http://www.mibuso.com/forum/viewtopic.php?f=32&t=30001
explains how to get rid of the problemFreddy Kristiansen
Group Program Manager, Client
Microsoft Dynamics NAV
http://blogs.msdn.com/freddyk
The information in this post is provided "AS IS" with no warranties, and confers no rights. This post does not represent the thoughts, intentions, plans or strategies of my employer. It is solely my opinion.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