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
"
"
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?