03-18-2009 02:29 PM - edited 03-18-2019 10:42 PM
I would like to use Business Objects with the CRSServer. Are there any issues with changing to allow both Windows and SQL Server Authentication?
03-19-2009 01:19 PM
Technically, there's no problem doing that.
But it's not officially supported by Cisco TAC.
Michael
03-20-2009 12:07 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide