Sometimes if you try to login to the sql server using sql server authentication you receive an error message saying "Not associated with trusted sql server connection". It means that the sql server authentication mode is not activated for this insatance of the sql server. To enable both windows authentication and sql server authentication modes for a particular instance of the sql server do the following:
1. Connect to the sql server using windows authentication mode i.e. Windows credentials
2. Open SQL Server Enterprise Manager
3. Expand SQL Server Group in the object explorer
4. Right click on the instance of the sql server for which you want to enable sql server authentication
5. Right click on the instance and then click properties
6. Click security tab on properties window
7. Now click "SQL Server and Windows authentication mode"
8. Click OK
9. Restart sql server
10. Login using SQL Server credentials
This is gonna work!
No comments:
Post a Comment