Newbie security question

Results 1 to 2 of 2

Thread: Newbie security question

  1. #1
    Join Date
    Dec 1969

    Default Newbie security question

    Hello,<BR><BR>I&#039;ve got a sql server database and an .asp page accessing the data, conecting using a dsn. I&#039;ve set up the users in SQL server to allow IUSR_ComputerName read access. Now - when I set up the dsn, and I&#039;m asked how SQL Server should verify the authenticity of the Login ID - I use SQL Server Authentication - using IUSR_ComputerName as the Login ID and leave the password blank.. is this the best/correct way to do it???<BR><BR>A newbiew question I know but any help would be apreciated..<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Newbie security question

    you could create a new Login for you SQL server Database which only has read access to the database.<BR>then use that user and password in your DSN.

Posting Permissions

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