Failed to log on to the server in SQL Server 2008 R2 Management Studio

Question

I have an instance of SQL Server 2008 R2 and you can log in using a user sa. But I want to define another user ( administrator) to log into SQL Server Management Studio, so I did the following:

• Login to the server in Management Studio as sa.
• Right-click the database name.
• Click on properties.
• Then, under permission, I select the required username ( administrator).
• And I give him all the permissions.

But when I tried to log in using administrator, I got the following error:

Login failed for user "administator" Error 18456.

Can anyone tell what could be the problem?

Answer 1

You need to add the server login:

• Connect to your SQL Server with SSMS like sa.
• Check the server security folder in the SSMS Object Explorer pane.
• Right-click the Security> Logins folder, which appears in the Object Browser.
• Click on the new entry ... in the popup menu.
• " " ​​- , , " " " " (). ( .)

, SQL Server Windows SQL Server (, sa login). ( " Login" - " " ) , , ; .

SO .

- ( )

SQL Server

Windows

- ( )

- ( )

SQL Server

Windows

Answer 2

, , .

Msg 18456, Level 14, State 1, Server <server name>, Line 1
Login failed for user '<user name>'

• , , : 18456.
• eventID 1, , 1, .
• Microsoft , , .

: SQL Server UserID , . , userID , (, )

: . , .

: . Windows SQL ( Windows. SSMS, ). , , , ....

18456 state 1 : Microsoft SQL Server 1, , 18456. 1 , , , . . " " ​​( 18456) SQL Server 2005

SQL : SQL Login SQL Server, 18456, ( ) Windows ().

, - SQL Server Management Studio, Object Explorer ( , ). - , . . - . " ".

, SQL.

Windows Server SQL Server

, SQL Server 2005.

• , SQL Server 2008 .
• SQL Server , DatabaseNode → → → - Windows Authentication. - Windows, .
• SQL Server 2008 SQL Server 2005 Windows .

? SQL Server Windows Authentication Mode.