{"id":42759,"date":"2008-11-08T04:36:00","date_gmt":"2008-11-08T04:36:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/nav\/2008\/11\/08\/basic-sql-creating-users-in-nav-on-sql\/"},"modified":"2023-05-31T15:35:09","modified_gmt":"2023-05-31T22:35:09","slug":"basic-sql-creating-users-in-nav-on-sql","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/no-audience\/2008\/11\/08\/basic-sql-creating-users-in-nav-on-sql\/","title":{"rendered":"Basic SQL – Creating users in NAV on SQL"},"content":{"rendered":"
This post is part of “Overview of NAV-specific SQL features for application consultants”.<\/p>\n
Before you can set up a user in Microsoft Dynamics NAV on SQL Server, you must create the user on SQL Server first. If you try to create a user which does not exist on SQL Server, you will get this error message:<\/p>\n
The Microsoft Dynamics NAV Classic and SQL Server security systems have not been successfully synchronized.\u00a0 The SQL Server login MYUSER does not exist on the LARS-PC server.<\/p>\n
To create this user on SQL Server follow these steps: 7)\u00a0\u00a0\u00a0\u00a0 If you want this user to access more than one database, then click on \u201cUser Mapping\u201d, and select the databases that you want to give the user access to. Otherwise just click on OK, and the user is ready to be used.<\/p>\n<\/a><\/p>\n
\n1)\u00a0\u00a0\u00a0\u00a0 Open SQL Server Management Studio and expand the group Security -> Logins.
\n2)\u00a0\u00a0\u00a0 Right click on \u201cLogins\u201d and select \u201cNew Login\u201d. Type in the name of the user.
\n3)\u00a0\u00a0\u00a0 Change from \u201cWindows Authentication\u201d to \u201cSQL Server authentication\u201d, and then type in (and remember) a password.
\n4)\u00a0\u00a0\u00a0 If you leave the checkmark \u201cEnforce Password Policy\u201d enabled, then the password you select must be complex enough to live up to the policy. If you disable this checkmark you can choose any password you like, or even leave it blank.
\n5)\u00a0\u00a0\u00a0 Un-tick \u201cUser must change password at next login\u201d. Otherwise the user will not be able to log into NAV at all.
\n6)\u00a0\u00a0\u00a0 Under \u201cDefault Database\u201d, select the NAV database that you want the user to access.<\/p>\n<\/a><\/p>\n