Checking if a SQL DB is configured with Mixed Mode Authentication

Article:HOWTO10937  |  Created: 2009-12-10  |  Updated: 2012-04-24  |  Article URL http://www.symantec.com/docs/HOWTO10937
Article Type
How To



Question
How can a user check to see if SQL 2000 is configured with Mixed Mode?

Answer
When connecting a Symantec Workspace Streaming to a SQL DB, 'Mixed Mode' authentication needs to be selected. To verify that 'Mixed Mode' authentication is selected, follow these steps:


1. Start Enterprise Manager.
2. Expand Microsoft SQL Servers and then expand SQL Server Group.
3. Right-click the server that you want to check that SQL Server and Windows authentication is selected on, and then click Properties.
4. In the SQL Server Properties dialog box, click the Security tab. Verify that 'SQL Server and Windows' is selected.
 
More information can be found at -

Legacy ID



50552


Article URL http://www.symantec.com/docs/HOWTO10937


Terms of use for this information are found in Legal Notices