|
Is using SQL 2000, you
might get the following error:
Microsoft OLE DB
Provider for SQL Server error
'80004005'
Login failed for user
'BanManProSQL'. Reason: Not associated with a trusted SQL Server
connection.
/dbconnect.asp, line
19
This error occurs
because by default SQL 2000 does not support SQL Server authentication and
supports only Windows authentication. To overcome this limitation:
-
Enter SQL Enterprise
Manager.
-
Find your server name
in the tree on the left.
-
Right mouse click on
the server name and select properties.
-
Click the Security
folder. You should now see the screen below with "Windows
Only" set as the default authentication.
-
Check SQL Server and
Windows as the Authentication.
-
Click OK.
-
Click Yes to restart
SQL.
|
