My XP Client doesn't access SQL Server 2000

Hi,

I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients don’t connect to database thru my application. It gives error as follows.

Runtime error

Login Failed for user ‘(null)’ . Reason: Not associated with a trusted SQL Connection.

Can anyone help me?

Regards

Ahmed Sahib

the server needs an nt login

you are connecting with an expectation to connect to a server in mixed server mode

to do:

1. configure the system to use mixed authentication

right click the server in the enterprise manager>click on properties> security

in the authentication option choose sql server and windows

or

2. change your connection string to use an nt login

|||

What kind of login is used by your application to connect to the database? Are all your clients within the same domain?

Thanks
Laurentiu

|||

Thanks Mr.Joe for your promp reply. My Server has mixed authentication.

I can ping; browse the server from my XP client. So there is no trouble in my network connection settings.

|||

Thanks Mr. Laurentiu Cristofor

Yes, My All clients are in the same domain. Kindly read my previous post.

Thanks

Ahmed Sahib

|||

Are your clients in the same domain as the server? Are you sure that they are attempting to connect using SQL Authentication and not using Windows authentication?

Thanks
Laurentiu