• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

Connecting to SQL Server 2000

I have tried to connec tto my SQL database both from a client machine and through an ODBC connection on the server itself.

The ODBC connection gives the following error message

SQL State 28000 SQLServer Error 18452 ODBC SQL Server Driver - Login Failed for 'sa' - Not associated with a trusted connection.


Through the program on the client machine I get the error, Login failed for Demon - Not associated with a trusted connection
0
rocky050371
Asked:
rocky050371
1 Solution
 
MOA81Commented:
Dear rocky050371

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".


check the below links for more details


http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=805050&SiteID=1
http://support.microsoft.com/kb/555332
0
 
rmaranhaoCommented:
Try to connect using Query Analyzer with the same username/password and see what happens.

Also, the client machine should have the client connectivity tools.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now