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: