Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Setting up DSN and Connecting with ASP

    Hi all

    I am having serious problems with connecting to SQL Server via ASP.

    I have created a User DSN, however when I am asked if I want to use Windows Authentication or SQL Server authentication, I feel I am having problems. If I choose SQLServer authentication, I am asked to enter a username and password which I do (does this need to be a predefined username and password?). I do this and the connection fails with an error saying that the login is not associated with SQLServer. If I choose windows authentication its fine, but when I try to connect via asp using the username and password I login to get into the machine and the DSN name I set up during the DSN setup, the same error comes up. (for windows authentication does the asp code differ from SQL Server authentication?). I really need help here

  2. #2
    Join Date
    Aug 2002

Posting Permissions

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