SQL 2005 and Passwords

dabel

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

kriki

Which version of Navision do you have?

kine

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.

urpok

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

Waldo

Have you tried using the "standard" security model?
What is exact your problem?

easy-navi

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.