I am trying to configure cisco Unified Service Monitor. When I try to add a new CM to the CUSM, it asks for CDR DB user and pass, we create a new user on CM for CDR access on SQL server, but we cannot succesfully pass verification, when we try the same user on CM to connect SQL server we get following error.
---------------------------
SQL Query Analyzer
---------------------------
Unable to connect to server TEKCCM1:
Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'testuser1'. Reason: Not associated with a trusted SQL Server connection.
---------------------------
OK
---------------------------