Creating Database Logins on SQL Server

The following example illustrates how to set up a superuser. You can use the same procedure to create the database logins for other users. Users that have been given a database login must use database authentication to gain access to the database.

Before you can give a user a database login, an administrator must give the user a login (using SQL Server Authentication) on the SQL Server that they will be using.

To Set Up a Superuser:

  1. Click Tools, Security, Database Logins and the Database Logins window appears.

  2. In the User ID field, enter the user ID - in this case SUPERUSER. You can type uppercase and lowercase letters as you like - the program will convert all letters to uppercase. You can later change the user ID in this field. Remember that this ID must be identical to the ID of the user's SQL Server login.

  3. In the Name field, enter the name of the user to whom this ID belongs.

  4. In the Expiration Date field, you can enter a final date on which a user will be able to log on to the program. As a security precaution, superusers should not be given a date limitation.

There is no need to enter a password here as that has already been done on SQL Server. When the user wishes to access a Navision database they will have to enter both their user ID and the password they entered on SQL Server.


The Navision security system is initiated when you create the first login. The first login should therefore be for a superuser who is given the SUPER role in Navision. The superuser then owns and administers all access to this database from within Navision. Until you create a superuser, any user with access to the system can carry out any transactions they want to in a Navision database.

One of the first things that the superuser should do is create user IDs, either Windows logins or database logins for the other people who will have access to the database and assign roles to these users. Permissions are allocated at company level in Navision.

For more information about security, see the manual Installation and System Management: Microsoft Business Solutions–Navision SQL Server Option.

Related Topics


Creating Database Logins on Navision Database Server

Creating Windows Logins

Giving Database Logins a Role