Web service calls have randomly stopped working

Toddy_Boy

Calls to my web services from VB.NET and ASP.NET have just stopped working with the following error

You do not have permission to read the Company table

I'm at a loss ... any help much appreciated as these services have been running great for a year

I've restarted the services rebooted the middle tier to no avail, seriously stuck ](*,)

Using SQL Server 2008 nav

kine

Are you sure, that the appropriate accounts are in NAV and have correct roles? What about possible password change of the account? Or may be someone changed the account on the service (NAV or SQL) or name of the server (NAV or SQL) and the SPNs are not correct anymore...

Toddy_Boy

Hi Kine

This account has been fine for over a year, nothing to my knowledge has changed in Nav, the account has SUPER privileges in Nav and is also used by the NAS which is still running fine.

No-one would have changed the SPN as no-one knows how we had our partner set the SPNs up as I couldn't make it work.

Is there a way you know of to check the SPNs?

In addition, the account was working fine on our test database, this gets refreshed overnight as a backup/restore of the live database, as of this morning I get the same error ](*,)

Steve

kine

Try to sync permissions in NAV first, may be some problem here. The SPNs may be are not the problem, mainly if the RTC clients are working without problems (and in most situation when there is problem with SPNs, it ends with Error 500 or 401). Was there some change in NAV objects? Like Codeunit 1...

Toddy_Boy

Hi Kine

I tried to sync the permission on friday with no joy .

Steve

kine

Found this: viewtopic.php?t=55469

Looks similar.

Looks at KB 2623055 here> http://mibuso.com/blogs/waldo

Looks like connected problem too.

SImilar described here> http://navigateintosuccess.com/blog/bug ... services-4

Toddy_Boy

Hi Kine

I've looked at the topics briefly before posting, I've had another look;

Found this: viewtopic.php?t=55469

Deleting users seems a little extreme

Looks at KB 2623055 here> http://mibuso.com/blogs/waldo

We are not setup on customer source so I can't access the links in the blog

SImilar described here> http://navigateintosuccess.com/blog/bug ... services-4

Don't really follow what this is saying

Further info, if I log onto the middle tier as myself and run the url below I get a list of web services, however if I log as the failing account i get an error page "The website cannot display the page"

http://localhost:7047/DynamicsNAV/WS/Services

kine

Question is if the ROLES assigned to the account used to connect to webservices are to specific company, or the company name filed is empty... (Role could be associated to user for specific company only or for all companies if nothing is entered).

Toddy_Boy

I've tried again with the url for company specific and get the same result as above i.e. No Error for my Login, and error for the failing account login.

http://localhost:7047/DynamicsNAV/WS/myCompanyName/Services

The failing account has SUPER role for the one company accessed by the web service i.e. myCompanyName in the above example

Steve

kine

It is not about the URL, but about the permissions settings inside NAV. The assignment of Permission Roles to the specific user...

Toddy_Boy

Hi Kine

I've just managed to resolve it.

Delete the user from Navision Add the user back into Navision Assign the correct role in Navision Change the user default schema in SQL Server back to $ndo$navlistener Restart services

One of the articles you pointed to Delete Users held the answer.

Many thanks for the pointers

Steve