Login failed for user "AVATOPIAian". Reason: Token-based server access validation failed with an infrastructure error. Kiểm tra for previous errors.

Log Name: ApplicationSource: MSSQLSERVEREvent ID: 18456Level: InformationUser: AVATOPIAianOpCode:Task Category: Logon

i can login khổng lồ the computer itself using Windows authentication. I can log into SQL server using the local Windows Administrator account.

We can connect to 8 other SQL Servers on the domain name using Windows Authentication. Just this one, whitch is the only one that is 2008 R2 is failing. So i assume it"s a bug with **2008 R2*.

Bạn đang xem: Đăng nhập sql server 2008

Note: i cannot logon locally, or remotely, using Windows authentication. I can login locally & remotely using SQL vps Authentication.

Update

Note: It"s not limited khổng lồ SQL server Management Studio, standalone applications that connect using Windows authentication:

*

fail:

*

Note: It"s not a client problem, as we can connect fine to lớn other (non-SQL hệ thống 2008 R2 machines):

*

i"m sure there"s a technote or knowledge base article describing why SQL vps 2008 R2 is broken by default, but i can"t find it.

Update 2

Matt figure out the change that Microsoft made so that SQL hệ thống 2008 R2 is broken by default:

Administrators are no longer administrators

*

All that remains is lớn figure out how khổng lồ make Administrators administrators.

One of these days i"m going to start a các mục of changes around Microsoft"s "broken by default" initiative.

Steps to lớn reproduce the problem

How vì i showroom a group lớn the sysadmin fixed vps role? Here"s the steps i try, that don"t work:

Click Add:

*

Click Object Types:

*

Ensure that you have no ability to địa chỉ groups:

*

and click OK.

Under Enter the object names to select, enter Administrators:

*

Click Check Names, và ensure that you are not allowed to showroom groups:

*

and click Cancel.

Click Browse...

Xem thêm: Những Game Mobile, Pc Của Garena Mới Nhất, Garena Free Fire: Khải Hoàn

, và ensure that you have no ability to địa chỉ cửa hàng groups:

*

You should now still not have added any group khổng lồ the sysadmin role.

Additional information

SQL vps Management Studio is being run as an administrator:

*

SQL hệ thống is set to lớn use Windows Authentication:

*

tried while logged into SQL with both sa và the only other sysadmin domain trương mục (screenshot can be supplied for those who don"t believe)