Connect to SQL Server from Windows Vista

[このドキュメントはプレビューのみを目的にしており、今後のリリースでは変更される場合があります。空のトピックはプレースホルダーとして記載されています。]

This topic describes how to The Windows Vista operating system provides a new security feature named User Account Control (UAC). in Microsoft SQL Server 2012 リリース候補 0 (RC 0) by using SQL Server Management Studio, Transact-SQL, or PowerShell. User Account Control lets users perform common tasks as non-Administrators. Windows user accounts that are members of the local Administrators group can run most applications as if they using the Standard User account.

Using the Standard User account helps protect the system because all applications that are run by administrators in Windows Vista do not have full administrator permissions. Programs that do require administrator permissions, such as tools to administer the system, are started with administrator permissions after the user provides consent.

SQL Server installs with the BUILTIN\Administrators group as the default system administration group. By default, users on Windows Vista that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically granted SQL Server administrator privileges. On Windows Vista, when a user tries to connect to SQL Server, a message is returned that states that the account does not have rights to log in to SQL Server.

When a user in the Administrators account runs SQL Server Management Studio, the User Account Control feature strips the membership token for that group and passes only the user account information to SQL Server. A message is returned that states that the account does not have rights to log in to SQL Server. To let members of the Windows Vista Administrators group log in, you must explicitly add the account to the SQL Server logins.

In This Topic

• Before you begin:

  Limitations and Restrictions

  Prerequisites

  Recommendations

  Security

• To ReplaceThisText, using:

  SQL Server Management Studio

  Transact-SQL

  PowerShell

• Follow Up:  After ReplaceThisText

• Replace this text.

• Replace this text.

• Replace this text.

[Top]

1. Log on to the computer using the credentials for the machinename\Administrator account.

2. Click the Start button, point to All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.

3. Connect to an instance of SQL Server.

4. Click Security, right-click Logins, and then click New Login.

5. In the Login name box, enter the user name.

6. In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.

1. Log on to the computer using the credentials for the domainname\username account.

2. Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run as administrator.

   注意

   The Run as administrator option elevates the user permissions.

3. In the User Access Control dialog box, click Continue.

4. In SQL Server Management Studio, connect to an instance of SQL Server.

5. Click Security, right-click Logins, and then click New Login.

6. In the Login name box, enter the user name.

7. In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.

[Top]

To ReplaceThisText

1. Connect to ReplaceThisText.

2. Use the ReplaceThisText statement, as follows:

   ReplaceThisText

   where ReplaceThisText .

   The following example ReplaceThisText.

   ReplaceThisText ;
   

[Top]

To ReplaceThisText

1. CD to ReplaceThisText.

2. Use the ReplaceThisText cmdlet, as follows:

   ReplaceThisText

   where ReplaceThisText .

   The following example ReplaceThisText .

   ReplaceThisText
   

1. Open a ReplaceThisText and connect to an instance of the データベース エンジン.

2. Use the ReplaceThisText object to ReplaceThisText.

3. The following example ReplaceThisText.

   ReplaceThisText
   

The following example ReplaceThisText.

ReplaceThisText

[Top]

[Top]

データベース ユーザーの作成