Knowledgebase

Answer / Solution

Open the "Microsoft SQL Server Management Studio" and create a new login at "Security > Logins" (right click > "New Login"). You can now decide to choose "SQL Server Authentication" (recommended) or "Windows Authentication" on the page "General" of the shown dialog:

1. "SQL Server Authentication": Enter a new "Login name" and a secure "Password" for the new account. Also deactivate the option "Enforce password expiration".
2. “Windows Authentication”: Enter an existing user account from your “Active Directory” as the “Login.” To do this, you can use the “Search” button next to the input field.
In both cases: Select your SpaceObServer database as the “Default Database.” On the “User Mapping” page: Select the SpaceObServer database and add the “db_owner” membership, or assign individual permissions. You can find the required permissions here..

Note: To enable access via “SQL Server Authentication,” select the “SQL Server and Windows Authentication Mode” in the “Security” tab of the MSSQL server properties (right-click on the SQL Server > Properties) in the upper section of the page.