Intermittent SQL 7 Login problem

Access 2000 application on client can log-in to SQL server using one of the SQL server logins.

Problem is that from certain clients you can log in using ANY id.

From other clients, the login attempt produces the SQL Server login box.

Any ideas why this might be ?

Client is Win2000.

All help would be appreciated!Have u tried connecting to sql from same box with diff network usernames ?

U prob running integrated security ?|||The login box should not come up at all ! That's the problem.

For the clients where it is the correct behaviour, you do not see the login box at all after starting the application.

However, when you start the application from some clients on the network, then the login box appears ...

Thanks.|||Sorry I'm not familiar with Access 2000 very much.

I was wondering wheter some clients are getting into sql via integrated security - taking the clients network login credentials by default - & if that fails the sql security login then the Login Box appears

Have u tried connecting to sql from same box with diff network usernames

Is it Box or user specific SQL Security Access problem.|||Try WINDOWS AUTHENTICATION on SQLSErver side.|||Originally posted by Satya
Try WINDOWS AUTHENTICATION on SQLSErver side.

Hi Satya -
I do not understand - could you please explain what you mean in more detail?

Many thanks.