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.  ...
    • Migrating from Registry to SQL Database (Titan 7 MFT to Cornerstone 8)

      NOTE: This process does not require a restart. However, it does require you to install a local instance of SQL Express if you will be using SQL authentication instead of Windows Authentication. SQL Express installer can be found under C:\Program ...
    • ADDGROUP and ADDUSER command limitations with non-native authentication

      SRXConfig allows you to make changes to your server settings via the command line. However, settings related to Users and Groups will only go into effect for servers using native authentication. Using the srxcfg ADDUSER command shows success on the ...
    • Backup Cornerstone SQL Server Data

      Cornerstone creates a database in Microsoft SQL Server to store configuration information for each server and its users and groups. This is ideal for scaled environments where multiple Cornerstone servers on different computers are connected on the ...
    • Changing Server IP Address

      After changing IP address of server Highlight the Server, go the Server General tab, On the IP Address field, change it to Any Available IP address, then click Apply This will force Titan/Cornerstone to bind to the new address. Restart the Server to ...