10 May 2005
SQL Server 2000 Authentication Problem
Posted by Mikhail Esteves under: Tips; Windows .
If your ASP.NET or ASP pages scream “Not Associated with a trusted SQL Server Connection” error, it’s simply because the default SQL Server 2000 installation comes with Windows Authentication Only checked by default. To get rid of this problem, do this:
- Open the SQL Server Enterprise Manager
- Right-click on the server name, say (local) and choose Properties.
- Navigate to the Security tab and under Authentication, choose SQL Server and Windows.
Click OK, restart SQL Server as prompted and your problem disappears.
