Microsoft SQL Server Security Questions

Source: Internet
Author: User

The ORACLE tutorial is about Microsoft SQL Server Security.
Microsoft SQL Server 7.0 security questions

Microsoft Corporation

[Microsoft SQL Server 7.0, hereinafter referred to as "SQL Server 7.0 」]

Which security modes are available for SQL Server 7.0?

Two types: SQL Server and Windows NT (hybrid) and Windows NT only. SQL Server and Windows NT are equivalent to the hybrid mode of SQL Server 6.5. Windows NT only is equivalent to the trust mode of SQL Server 6.5. The standard mode equivalent to SQL Server 7.0 is not provided in SQL Server 6.5.

Why does the SQL Security Manager (Security Manger) of SQL Server 6.5 disappear in SQL Server 7.0? What is the alternative tool?

SQL Server 7.0 provides the Security Wizard to replace the Security manager ).

What are the advantages of SQL Server and Windows NT (hybrid) security mode?

You can also log on to an Internet client other than a Windows NT client.
Provides multi-layer protection.
What are the advantages of Windows NT only security mode?

You can log on to SQLServer more quickly without having to remember another password.
Use the password setting function provided by NT, such as the minimum password length (minimum password length ),..
You only need to set accounts and groups for the NT group.
How to set the Security Mode of SQL Server?

Start SQL Server Enterprise Manager ).
In the console tree, expand Microsoft SQL Servers, expand SQL Server Group or the Group you set, and click Select the SQL Server to be set.
Right-click Properties and select Security tab.
In the Security Section, select "SQL Server and Windows NT" or "Windows NT only ".
In SQL Server Enterprise Manager, how does one set to allow a Windows NT group or user to log on to SQL Server?

In SQL Server Enterprise Manager, expand the SQL Server to be added to the Windows NT group or user account, expand the Security folder, select login, right-click, and select new login from the shortcut menu.
Select the "General" tab and enter "domain \ account" or "domain \ group" in the Name field ".
In the Authentication section, select Windows NT Authentication (Windows NT Authentication), and then select domain ).
In the Default section, select the Default database and language.
Click OK.
How to Use the SQL Server stored procedure to enable a Windows NT group or user to log on to SQL Server?

Sp_grantlogin {login}
Login contains a domain, a group, or a user account, and cannot exceed 128 characters.

When setting a Windows NT group or logging on to SQL Server, what should I pay attention?

If the SQL Server logon id corresponds to a Windows NT group, you do not need to create a new SQL Server logon id to add or delete Windows NT groups.
If the logon id of SQL Server corresponds to a Windows NT group or user, deleting this Windows NT group or user does not delete the logon id of this SQL Server.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.