Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: SQL Server Security - Questions

    I have created logins and user accounts in SQL Server.
    How come, when I open SQL Server, it did not prompt for passwords ?
    How can I make it to do so ?


    ********************************************
    *** Thank you very much in advance, security gurus ***
    ********************************************

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    are they sql server logins? or windows?

    go to enterpise manager and right click on the registered server and press 'edit sql server registration', then tick the box that says 'always prompt for user name and password'

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    A connection using Windows Authentication actually uses your Windows credentials to establish security (just like when you reference a UNC). No password needs to be exchenged because you provided your password to Windows when you logged onto your machine.

    Passwords are used to authenticate SQL Logins, since SQL Authenication exists completely outside of Window.

    -PatP

Posting Permissions

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