CCX SQL Server - Mixed Mode Authentication

bpepper · ‎03-18-2009

I would like to use Business Objects with the CRSServer. Are there any issues with changing to allow both Windows and SQL Server Authentication?

htluo · ‎03-19-2009

Technically, there's no problem doing that.

But it's not officially supported by Cisco TAC.

Michael

http://htluo.blogspot.com/

Aaron Harrison · ‎03-20-2009

There's also no real need to enable it... normally!

To get auth'd to the SQL server for dev purposes, without using SQL auth:

1) Create a local user account on the CCX server, with the same user name as you have in your normal domain or local PC (i.e. aaron.harrison for me)

2) Make sure you set your same, current password on the account (yes, it needs updating whenever you change yours)

3) Go into SQL Ent Manager, and grant the new local account DBO permissions on db_cra

You can now authenticate using windows auth to the DB.

CCX 5+ seems more picky about how you auth to the DB and what method you use to connect (i.e. 'ADO for ODBC drivers' using TCP/IP) so I try not to meddle at all so as to ensure compatibility with customer setups.

SQL Auth is considered weaker, and therefore bad.

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!