Q. How can I add a new user in SQL Server Management Studio (SSMS)?

A. When installing the SQL Server embedded in the NaviEdit installer, the user running the installation is automatically added as a SQL Server user.

If the user is not added as an SQL Server user, the user must be added as shown below:

  • Create a login for the domain user within the SQL Server and grant domain users access to the SQL Server.
  • Give the user a login:

  • Give the user administrative rights to the SQL Server: