Sqlserver uses Windows authentication on the LAN to connect to another SQL server in the LAN (not a domain environment)

Sqlserver uses Windows authentication on the LAN to connect to another SQL server in the LAN (not a domain environment)

Previously, even msdn said that connecting to another SQL server in the LAN must be"Domain environment"

However, today I found that using Windows authentication can connect to another SQL server in the LAN without a domain environment.

Description on msdn:

Address:Http://msdn.microsoft.com/zh-cn/library/ms144284.aspx

Http://msdn.microsoft.com/zh-cn/library/ms143705 (V = SQL .90). aspx

"

• SQL Server is allowed to support environments with hybrid operating systems. In such environments, not all users are verified by the Windows domain.

"

In fact, someone in a post on the msdn Forum tried and found out that I would like to take the following steps: My test environment: Host A: windows7 sql2005 computer name: Joe B: windows 8 sql2008r2 computer name: joehomepc condition: the Windows Account Name of machine a is the same as the Windows Account Name of machine B, and the password is the same (no password is allowed) Step 1: For example, the Windows account of my machine A is administrator, and the windows account of my machine B is also Administrator. The passwords of both accounts are empty.

Machine a IP Address: 192.168.1.100
Machine B IP: 192.168.1.102

 

Step 2:

Open SSMs on machine A, enter the IP address of machine B, and use Windows authentication.

 

Connect directly to sql2008r2

Step 3:

Query data on sql2008r2. If you open the table in object Resource Manager->, an error is returned.

 

However, the query editor does not report an error because sql2008 does not support the "Open Table" command in sql2005. Summary: Is it Microsoft's vulnerability? Or do we not know this feature?