CCM4 SQL Mixed mode

[Sascha Monteiro]

Hi,

I know that in CM4 the Authintication is set to Windows only. It looks like a better practice.

But when you install Extended Services (for TAPS) on the Publisher it sets it back to Mixed mode...

Can it be set back to Windows only?

And the CDR definition doc still talks about SQL authentication and gives usernames/passwords for it to use...but default is Win only...

Is it supported to set it back to mixed for the CDR application, if they cannot use Win-auth???

thanks for thinking

[Aaron Harrison]

Windows only authentication is more secure and a better practice in general - however enabling mixed mode doesn't restrict anything or alter SQLs behaviour in any way other than allowing use of accounts defined directly in SQL (i.e. not relating to a windows account).

I believe there are quite a few other programs that still require mixed mode... and if a Cisco app (TAPS) sets it automatically then it must be a supported configuration.

[amansharma]

Hi,

I am not sure how Taps is changing the database authentication Level ,IT should not because Tac only supports windows authentication as when you change it to sql or mixed ,You might run into issues while upgrading or running a patch.

Thanks

Aman

[maharris]

We had the same thing happen on a co-resident CRA 3.5 install, here is from the install guide(p48):

If you are installing Cisco CRA on a stand-alone server (a server on which Cisco CallManager is not installed), the Welcome to the Cisco Customer

Response Applications Installation pane appears. Continue to step to Step 2.

If you are installing Cisco CRA on the same server on which Cisco CallManager is installed (creating a creating a co-resident configuration), a dialog box appears that contains this prompt:

Local SQL Server/MSDE Login Mode must be changed to Mixed Mode. Do you want to change it to Mixed Mode Now?

In this case:

• Click Yes to continue.

• A dialog box appears prompting you to restart SQL Server to change the SQL Login Mode. Click Yes to continue.

Mary Beth

[maharris]

Actually, further down in the install guide, they get to the CTI Manager Locations section, even when the CM is a different server, you have this -

Step 26 When the system prompts you to enter a new SA account password, enter and confirm the SA account password, and then click OK.

This password should not consist of only the space character.

Note For a co-resident configuration, enter the same Administrator and SA account passwords that are used for your OS and Cisco CallManager configuration.

Step 27 If a dialog box appears confirming a new SA password, click OK.

Step 28 Click Yes to reboot the system.

After the server reboots, the Customer Response Applications Administration login window appears.

You are now ready to log in to the Cisco CRA 3.5 Administration web interface.

This implies that if the CM you are integrating with is not mixed mode to start, it either won't work, or it will be mixed mode when you are done!

Mary Beth