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.
- Under Authentication, click the SQL Server and Windows option button.
- 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 ...