Results 1 to 4 of 4

Thread: sql server's security mode

  1. Nov 8th, 2005, 11:09 AM #1
    elsc
    elsc is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2003
    Posts
    237

    sql server's security mode

    how to disable the windows authentication mode in sql server?

    user must have a password to login to the server

    is it possible to do that?
    Reply With Quote Reply With Quote
  2. Nov 8th, 2005, 11:23 AM #2
    Samurai Danny
    Samurai Danny is offline
    Lively Member
    Join Date
    Feb 2005
    Location
    California
    Posts
    97

    Re: sql server's security mode

    When I had to do that I had to re-install SQL server2000.
    Check out this site :
    http://www.codeproject.com/database/ConfigureMSDE.asp
    Reply With Quote Reply With Quote
  3. Nov 9th, 2005, 07:54 AM #3
    vb_dba
    vb_dba is offline
    Fanatic Member vb_dba's Avatar
    Join Date
    Jun 2001
    Location
    Somewhere aloft between the real world and insanity
    Posts
    1,016

    Re: sql server's security mode

    If your server configuration is for Mixed Mode, then you should be able to have both Windows Authentication and SQL Server Authentication. If that's the case, then you can revoke access to the Windows logins and create the SQL Server logins that are to be used for connecting.
    Chris

    Master Of My Domain
    Got A Question? Look Here First
    Reply With Quote Reply With Quote
  4. Nov 18th, 2005, 12:12 PM #4
    elsc
    elsc is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2003
    Posts
    237

    Re: sql server's security mode

    is it possible to make it even user logged in to windows, but must have a password to login to sql server?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width