Post reply

SQL Authentication

  • April 26, 2004 at 8:26 am

    #101983

    We setup a login on SQL Server…a client account….added permissions to tables in the dB.

    When we try to connect through an asp script we get the error:

    Not a trusted SQL Server connection….any ideas?

  • April 26, 2004 at 8:55 am

    #504240

    1. What type of Authentication is your database server set to? Use Enterprise Manager, right click on the server, select Properties, go to the Security tab.

    2. What type of Authentication did you set your client login for?

    Are the two settings compatible?

    If both are set for Windows Authentication, is the client machine on the same domain?

    -SQLBill

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply