Expand the Server details for the SDW server and login using a superuser or administrator account.
Expand the Login Roles to show the entries.
Right-click on the user you have just created and select Properties.
Select the Role membership tab.
Select the relevant role in the Not Member box and click >> to add to the Member box. For restricted read-only access a user requires the restricted schema viewer role. For read/write access a user requires the restricted schema editor role.