Checking if a SQL DB is configured with Mixed Mode Authentication

Products

• Workspace Streaming (formerly AppStream)

Issue/Introduction

 

Resolution

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 -

http://support.microsoft.com/kb/889615