Security Synchronisation (Navision 4.0 with SQL Server 2000)

Comments

• Mauddib Member Posts: 269

  2005-10-25

  The only time I have had Navision crash out in that way was when the Role didnt have permission to do something at the time.
  
  For example remove the permission for a user to register time. Then try and change from one company to another in the same database. Rather than give you a message saying you dont have permission, the whole program crashes out.
  
  So there is probably a permission you need to add to your role to be allowed use that sync option. What permission it is I dont know.

  0
• bbrown Member Posts: 3,268

  2005-10-26

  The user doing the sychronize must be a member of the SQL Security Administrators role or higher.

  There are no bugs - only undocumented features.

  0
• ta5 Member Posts: 1,164

  2005-10-26

  Hi
  The issue is (partly) solved. It works on an other SQL Server 2000 with SP3 without problem. I therefore guess its a problem with Service Packs.
  Regards
  Thomas

  0
• ta5 Member Posts: 1,164

  2005-10-26

  Hi
  I found another interesting fact.
  If the db user who has created the db (now the dbo) is added to the database logins in navision, synchronisation is not possible anymore. The Synchronisation stops with the ffw message: The Microsoft Business Solutions-Navision and SQL Server security have not been synchronized successfully. The database user xy does not exist in the database xyz."
  
  Has somebody similar experiences?
  Thomas

  0
• itspeter Member Posts: 105

  2005-10-26

  Yeah, I got that problem before.
  
  I had to change the database owner using SQL Query Analyzer.

  sp_changedbowner 'todatabaseid'
  

  Regards,
  Peter Ng

  0
• ta5 Member Posts: 1,164

  2007-01-11

  Hi everybody
  
  Funny stuff, I had the same problem today again (as stated in the first message of the thread) with a customer installation. ](*,)
  
  Technical upgrade is not an option at the moment.
  
  Any input on this will be highly appreciated.
  Thanks
  
  Thomas

  0
• ta5 Member Posts: 1,164

  2007-01-15

  Nobody? :?

  0
• DenSter Member Posts: 8,307

  2007-01-15

  answer from MS tech support: upgrade first and then we'll talk.

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• ta5 Member Posts: 1,164

  2007-01-16

  Hi Daniel
  You mean a technical upgrade to 4.03?
  
  Thomas

  0
• DenSter Member Posts: 8,307

  2007-01-16

  Correct, yes, sorry... Technical upgrade to SP3 first, then come back.
  
  It's like the doctor saying 'take an aspirin and call me in the morning'

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• ta5 Member Posts: 1,164

  2007-01-16

  Thanks for the info.
  
  OK then, I'll tell to the customer:
  "'We'll give you an aspirin and call you in the morning"

  0