SQL 2005 and Passwords

dabel
dabel Member Posts: 44
edited 2007-11-15 in NAV/Navision Classic Client
I am getting the following message after setting up a user login under SQL 2005 and granting public acess to the database. Under SQL 2000, this is all that I needed to do. However, there must be something else that needs to be configured becauase no users can change their passwords having Super User access within the database. Synchronization has been run and all users can login in to the system. They just cannot change their passwords. Any help would be much appreciated.

Message:

15151, "42000", [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter the login 'Dave', because it does not exist or you do not have permission.

SQL:

{CALL [sp_password](?, ?)}

Thanks

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Which version of Navision do you have?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • kine
    kine Member Posts: 12,562
    To be able to synchronize users on SQL 2005 you need to be sysadmin or have enough rights to set permissions. It is given by tighter security on MS SQL 2005 server.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • urpok
    urpok Member Posts: 23
    kine wrote:
    To be able to synchronize users on SQL 2005 you need to be sysadmin or have enough rights to set permissions. It is given by tighter security on MS SQL 2005 server.

    If you have any further knowledge of these permissions on SQL server 2005, could you please point me into right direction.
    I have been looking for a document comparable to "Navision (Security Hardening Guide 2005-08).pdf" document, but so far have been unable to find one.

    regards urpo kotipalo
    "There is no spoon."
    --Matrix

    https://navurpo.blogspot.com/?view=classic
  • Waldo
    Waldo Member Posts: 3,412
    Have you tried using the "standard" security model?
    What is exact your problem?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • easy-navi
    easy-navi Member Posts: 31
    edited 2015-12-29
    Sorry to answer after such a long time. But I have the same problem - and the solution is very trivial :)
    If during changing passwd user gets such an error:
    15151, "42000", [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter the login 'XYZ', because it does not exist or you do not have permission.
    SQL:
    {CALL [sp_password](?, ?)}


    Chceck if the user puts the CORRECT OLD PASSWORD. If not you will get exactly such an error :)
    p.s.
    my enviroment = Nav 4.03, sql2005.
    http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.

Categories