Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: authentication with mssql server

    Currently all of our MS SQL Server databases have been installed so as once an administrator connects to the server they can get access to the SQL Server database. We would like to change this to ensure that no matter who you are you have to enter a valid username and password in SQL Server to connect to the database. I cannot seem to find out how to do this. All help will be greatly appreciated.


  2. #2
    Join Date
    Aug 2002
    Refer to books online for AUTHENTICATION MODES & other related topics which covers what you're looking for. Adopt Mixed mode authentication if you would like to enter user/password during the connection.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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