Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create or alter a login
Select the Logins under the Server Security node in the Object Explorer.
Complete the fields as necessary. Review the following for additional information:
Authentication type |
Select one of the authentication types. |
Server Roles | Select True to associate login with selected server role. |
Note: Right-click the object to see additional actions and tasks available for it. For example you can enable or disable logins, change passwords, grant or deny access.
You can define mapping between database users and logins and set database access and roles in this page.
To define user mapping
Select the Logins under the Server Security node in the Object Explorer.
Complete the fields as necessary. Review the following for additional information:
Users mapped to this login |
Select the checkbox beside each database you want the login to access. Enter the user name associated with this login for the selected database. |
Database role membership for |
Select the checkbox beside each database role you want to assign to this login. |
Repeat the previous step for each database on which you want to set database roles.
To create or alter a credential
Select Credentials node under the Server Security node in the Object Explorer.
Complete the fields as necessary. Review the following for additional information:
Identity |
Click |
Note: You can create firewall rules on Azure servers to restrict access to the limited number of IPs. If you cannot connect to Azure server select Tools | Cloud Computing | SQL Azure Portal to login to Azure Portal.
To create or alter Azure firewall rule
Select the Firewall node under the Server Security node in the Object Explorer.
Right-click the node and select View Details.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center