migrating Navision database from SQL 2000 to SQL 2005 !

snehanshu

Hi
I am moving my Navision 4.0 SP3 database from an SQL 2000 server to a SQL 2005 server.

on my new server I have created the same logins in SQL 2005 that exist in my navision database.

after moving the database I have sync'd the user logins from within Navision (Tools->Security-Syncronize All)

I am now able to open the database from my Navision SQL client and work.

However the change password option fails....from the Navision client....returning an SQL error that "user does not have permission to change the password"

what settings do i need to do in SQL 2005 ? to allow a navision SQL client user to change his/her password ?
or
does anyone who has done a migration of a navision database from SQL2000 to SQL 2005 can advise on the best possible way to do this ?

thanks...........

kine

1) If you did just detach/attach, there is one additional step you need - set correct permissions on the database - see http://dynamicsuser.net/blogs/kine/arch ... -2005.aspx

2) To be able to change password users must have permissions for function sp_password if I remember correctly.

kine

And one additional thing - Standard or Extended security model?