Changing Authentication Mode for SQL

Changing Authentication Mode for SQL

To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use the following steps: 



  1. Open the Enterprise Manager. 

  2. Expand a Server group. 

  3. Right-click a server name, and then click Properties. 

  4. Click the Security tab. 

  5. Under Authentication, click the SQL Server and Windows option button. 

  6. Restart SQL Server in order for the change to take effect.


For more information, see this http://support.microsoft.com/kb/269587



    • Related Articles

    • Changing Authentication Mode for SQL

      To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use the following steps: Open the Enterprise Manager.  Expand a Server group.  Right-click a server name, and then click Properties.  Click the Security tab.  ...
    • How-To: Changing SQL User Credential for Cornerstone MFT Server

      Question How do I change the DB user credentials used for my Cornerstone MFT Server? Reasoning I recently migrated my Cornerstone MFT server from an older Operating System (OS) to a newer one. I also updated the user account used for the SQL ...
    • How To: Change the Database Connection for Titan Server

      How To: Change the Database Connection for Titan Server Question Can I change the database connection for my Titan Server? After setting up the server to use, for example, a local SQLite server, can I change the database connection to use, say, a ...
    • How To: Use Hybrid Authentication In Titan Nextgen

      Related To Titan Nextgen Enterprise Plus Builds 2.x and above. Question How can I use hybrid authentication in Titan Nextgen? Reasoning I would like to be able to manage native user accounts and windows user accounts under one server instance to ...
    • How To: Create a Server With Windows Authentication In Titan

      Question How do I create a server within Titan that utilizes Windows authentication? Reasoning I already have a database of users stored on a local windows server or an Active Directory server and would like to import these users into Titan and use ...