Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    England
    Posts
    15

    Unanswered: SQL Server 2k Security Setup on Application Server

    Hi all

    If i wanted to set up my SQL Server DB to run in an Application Server environment (i.e. clients connecting to a remote server)
    would i be required to give every user a WINDOWS SERVER logon as well as a SQL Server logon or would i only need to setup just a SQL Server logon for them?
    (obviously using SQL Server Security opposed to NT Integrated Security)

    Thanks in advance for any help

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    you could give them a single sql login that all users can use
    or
    you could give each collection of users a single login defined by their organizaion
    or
    you could give each individual user a independent sql login
    the choice is yours.
    your best scenario would be to use windows authentication because you would have one user and one account through the os and auditing and the ability to use os groups as logins instead of individual users.

    the advantages of using windows authentication greatly outweigh almost any cons you might present.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Originally posted by Ruprect
    the advantages of using windows authentication greatly outweigh almost any cons you might present.
    The one con that trumps this (hands down) is having any non-windows clients!

    -PatP

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    let those bastards get their own database!!!


Posting Permissions

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