Knowledgebase
Portal Home > Knowledgebase > Windows Hosting > MsSql database > error:Login Failed for User 'testSQL', Not Associated with a trusted SQL Server Connection
error:Login Failed for User 'testSQL', Not Associated with a trusted SQL Server Connection
|
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.
|
|
 Add to Favourites
 Print this Article
|
Powered by WHMCompleteSolution
