The SQL Server login does <sqluser> not exist on the <servername> server

Hello,

The server for a  Nav 5 implementation that I am working on crashed about a month ago. A new windows 2012 r2 server was created and NAV restored. Several hundred users were added by an administrator, about 700 I think - users dating from 10+  years ago, even if they aren't there now - at that time the syncing worked fine he said. 

However, as of two days ago they are getting the message mentioned in the subject - but the fact is that the user does actually exist on the sql server.

It happens when either a) the admin goes and adds a new user in NAV / database user and also adds the matching user in SSMS, and then goes to "Sync All'

or b) it seems to be happening starting with users beginning with 'a' - in other words I think it is not finding ANY user that is listed in NAV database user list in SQL Server, even though they are in SQL Server.

NAV is a published Citrix app, I don't know if that is relevant. 

Windows security update kb4493446 was installed 5 days ago - doubt it's relevant but just mentioning it.

Parents
  • The server for a  Nav 5 implementation that I am working on crashed about a month ago. A new windows 2012 r2 server was created and NAV restored. Several hundred users were added by an administrator, about 700 I think - users dating from 10+  years ago, even if they aren't there now - at that time the syncing worked fine he said. 

    Sorry, but did you create the symcronization for all users? look like your admin miss this step. If I remember correctly you need to create SQL users (we did movements by script), restore NAV and do syncro. The MAIN point - SAME users (domain, "setup", etc) should exist in SQL.

    Based on your information "2 day ago" someone did Syncro and users gone (because was moved non-correctly)

Reply
  • Thank you for your replies. we are talking about SQL users, not windows users. 

    I was not there for the original restore - was brought in later to look into SQL Server issues specifically, but I don't have that much NAV experience personally. The thing is, the admin says that this all worked 3 weeks ago when he did the initial sync, but stopped working now. Most people have said the problem occurs when the user is in NAV list of database users but not in sql, but the user is in SQL. I've heard that it helps/may help to remove the SQL user and add them back - but so far that didn't help - I think (will double check)

    This is under "standard" security". Would it help (or hurt) to go to enhanced?  The admin doesn't remember whether it was ever under enhanced. Would it hurt to set to enhanced and then back to standard? 

    I noticed, for example, that things are out of sync "on both sides", meaning that there are some users in sql that are not in nav, and vice versa. Is it problematic to have users in sql that are not in nav - there are many of those.

Children
No Data
Related
Recommended