Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2003
    Posts
    5

    Unanswered: 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!

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Have u tried connecting to sql from same box with diff network usernames ?

    U prob running integrated security ?
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Feb 2003
    Posts
    5
    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.

  4. #4
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    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.
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try WINDOWS AUTHENTICATION on SQLSErver side.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Feb 2003
    Posts
    5
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •