Admin-Ahead Community
Windows => General Windows => Topic started by: jominj on December 31, 2013, 10:20:08 pm
-
Sometime while connecting MSSQL 2008 Remotely OR locally using MSSQL Management Studio (using user as SA) it throw following Error
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
This Error occurs when SQL Server doesn’t support SQL Server Authentication Mode. This issue can be fixed using following Steps:
1) Connect the MSSQL server using Windows Authentication of the server.
(http://www.codeproject.com/KB/database/NorthwindAndPubs_2008/NorthwindAndPubs_2008_fig1.jpg)
2) Right Click on the server name in the tree on the left and go to properties.
(http://i1.wp.com/eitwebguru.com/wp-content/uploads/2009/07/mssql21.png?resize=500%2C267)
3) Click the Security Option. Now under Server authentication Select “SQL Server and Windows Authentication Mode” and press OK.
(http://i2.wp.com/eitwebguru.com/wp-content/uploads/2009/07/mssql31.png?resize=500%2C375)
Now try to connect MSSQL using SA user.