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: