Question 1: User 'SA' Failed. Cause: Not associated with trusted SQL Server connections.

xiaoxiao2021-04-04  232

Create a new DEWDB data source today, but it has been tested unsuccessful. Later, I found out that I didn't have SQL Server registration.

Problem brief: User 'sa' failed. Cause: Not associated with trusted SQL Server connections. Solution: This problem is generally caused by SQL Server not integrating Windows authentication, so the solution is: 1 Open the SQL Server Enterprise Manager. 2 Select the server name on the right button to select "Edit SQL Server Registration Properties" (unregistered must first be registered first), then select "Use Windows Authentication" in the dialog. 3 Try a try, no. To look at the security setting 4, right click, select Properties, and open the Security tab. 5 On the tab, select Authentication as "SQL Server and Windows", others constant

转载请注明原文地址:https://www.9cbs.com/read-131870.html

New Post(0)