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

Source: Internet
Author: User
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?
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.