I just installed a named instance of SQL Server2000 along with my SQL7
service. The service names are Mymachine\SQLSrv2000 and MyMachine.
When I went to BDE and checked the connection as user 'sa', the SQL7 service
works fine. But when trying with SQL2000 service, I got these BDE Error
Messages:
-- BDE Error 10036: Unknown user name or password.
-- BDE Error 13059, Server Error 18452: Login failed for user 'sa'. Reason:
Not associated with a trusted SQL Server connection.
-- BDE Error 13059, Server Error 10003: Login incorrect.

The 'sa' user exists in both server groups. And the password is correct.

Anyone has some suggestion? Thank you very much in advance.

I just found that my Service security (authentication) mode was set up as
Windows NT Authentication Mode (Windows NT Authentication) . I changed it to
Mixed Mode (Windows NT Authentication and SQL Server Authentication) and it
works now.