Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

IPCC Historical Reporting - Scheduler Exporting Error

We are running IPCC 4.5(2.1) with MSDE SQL. For the CRS Historical Reporting we ran into the login error which is documented by cisco. Switch SQL authentication mode from Mixed-Mode to Windows-Only, but we can´t. Our IPCC Monitor doesn´t work in this mode.

"Failed to login to database. Ask your administrator to check the database user id and password that is dynamically obtained from the application server"

I found a workaround in editing the "hrcConfig.ini"

;AUTH specifies the authentication mode to use while connecting to the database. 
;Use one of the following values:
;1 - Windows NT Authentication
;2 - Mixed Mode Authentication
AUTH=1

Now we are able to log in via AD users onto the crs server and manualy create, view and export Historical Reports. No problems, but if we´re using the CRS Scheduler, we get the following error in the "CiscoSchPrintExport.log"

[VERSION=4.5(2.014)]
[SeqID]   [Type]   [TimeStamp]     [Description]
0 INFO_VERBOSE  Oct 22 2010|16:00:22 CCrystalReportExport 0 object creation threadID = 3980
1 INFORMATIONAL Oct 22 2010|16:00:23 3920:ReportName=ICD_Agent_Login_Logout_Activity_Chart_de_DE
2 INFORMATIONAL Oct 22 2010|16:00:23 3920:Recurrence=DAILY
3 INFO_VERBOSE  Oct 22 2010|16:00:23 3920:[Connect database using TCP/IP - dbmssocn library]
4 ERROR  Oct 22 2010|16:00:24 3920:Exception occurred while creating HistoricalDBConn - using dbmssocn library.
5 INFORMATIONAL Oct 22 2010|16:00:24 3920:Provider=MSDASQL;Persist Security Info=False;DRIVER={SQL Server};NETWORK=dbmssocn;SERVER=10.144.***.*** \CRSSQL,4433;DATABASE=db_cra;UID=db_cra;****************;Trusted_Connection=No;APP=ReportExporter
6 ERROR  Oct 22 2010|16:00:24 3920:LogComError: the error is = Code= 80040e4d, Code Meaning = IDispatch error #3149

7 ERROR  Oct 22 2010|16:00:24 3920:Source=Microsoft OLE DB Provider for ODBC Drivers
8 ERROR  Oct 22 2010|16:00:24 3920:Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'db_cra'.
9 ERROR  Oct 22 2010|16:00:24 3920:LogProviderError:Dumping ADO Error 1 of 1
10 ERROR  Oct 22 2010|16:00:24 3920:   Number = -2147217843
11 ERROR  Oct 22 2010|16:00:24 3920:   Source      = Microsoft OLE DB Provider for ODBC Drivers
12 ERROR  Oct 22 2010|16:00:24 3920:   Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'db_cra'.
13 ERROR  Oct 22 2010|16:00:24 3920:   HelpFile    = (null)
14 ERROR  Oct 22 2010|16:00:24 3920:   HelpContext = 0
15 ERROR  Oct 22 2010|16:00:24 3920:   SQLState    = 28000
16 ERROR  Oct 22 2010|16:00:24 3920:   HelpContext = 0
17 ERROR  Oct 22 2010|16:00:24 3920:   NativeError = 18456
18 INFORMATIONAL Oct 22 2010|16:00:24 3920:[Try connecting database using dbnmpntw - Named Pipes library]
19 INFO_VERBOSE  Oct 22 2010|16:00:24 3920:Connection String = Network=dbnmpntw
20 ERROR  Oct 22 2010|16:00:24 3920:PrintDBConnectionString:pwd not found in Connection String
21 ERROR  Oct 22 2010|16:00:24 3920:Exception occurred while creating HistoricalDBConn, for checking user priveleges
22 ERROR  Oct 22 2010|16:00:24 3920:LogComError: the error is = Code= 80004005, Code Meaning = Unbekannter Fehler

23 ERROR  Oct 22 2010|16:00:24 3920:Source=Microsoft OLE DB Provider for ODBC Drivers
24 ERROR  Oct 22 2010|16:00:24 3920:Description=[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
25 ERROR  Oct 22 2010|16:00:24 3920:LogProviderError:Dumping ADO Error 1 of 1
26 ERROR  Oct 22 2010|16:00:24 3920:   Number = -2147467259
27 ERROR  Oct 22 2010|16:00:24 3920:   Source      = Microsoft OLE DB Provider for ODBC Drivers
28 ERROR  Oct 22 2010|16:00:24 3920:   Description = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
29 ERROR  Oct 22 2010|16:00:24 3920:   HelpFile    = (null)
30 ERROR  Oct 22 2010|16:00:24 3920:   HelpContext = 0
31 ERROR  Oct 22 2010|16:00:24 3920:   SQLState    = IM002
32 ERROR  Oct 22 2010|16:00:24 3920:   HelpContext = 0
33 ERROR  Oct 22 2010|16:00:24 3920:   NativeError = 0
34 ERROR  Oct 22 2010|16:00:24 3920:-------------------------------------------------------------------------------
35 ERROR  Oct 22 2010|16:00:24 3920:==> Exporting/Printing Report ICD_Agent_Login_Logout_Activity_Chart_de_DE,Created On 10222010150411,Type=DAILY by user ##ADUSER### FAILED.
36 ERROR  Oct 22 2010|16:00:24 3920:-------------------------------------------------------------------------------


Is it not possible to run Historical Reportin in SQL mixed mode? Thx for help.

1517
Views
0
Helpful
0
Replies
CreatePlease to create content