Login failed for user

Solution1.Set server authentication

  1.Login database with other user.

  2.After login,right click on the server,select Properties.

  3.On the popup page,select Security,select SQL Server and Windows authentication mode.

  4.Click ok.

  5.Right click on SQL Server,Restart.

原文地址:https://www.cnblogs.com/jinxinhelloworld/p/3438304.html