locked
Discovery failed on SQL 2012/2014 RRS feed

  • Question

  • Hello All,

    Enviroment: Windows Server 2016 running Ops Manager 2016; Some SQL Server 2012, 2014, 2015

    On my 2012 and 2014 (not yet on 2016) i'm getting all the Time "Discovery Failed" messages cointaining:

    Event ID: 7103. Management Group: xxxx. Script: DiscoverSQL2012DB.vbs. 
    Version: 6.7.7.0. Instance: P65 : SQL Database discovery script 
    'DiscoverSQL2012DB.vbs' for instance 'P65' failed.The next errors 
    occured:Cannot connect to the target Sql Server instance. Connection 
    log:Connection to data source 'lpc:xxx\P65' failed: [Microsoft][SQL 
    Server Native Client 11.0][SQL Server]Login failed for user 
    'xxx\XXX.Connection to data source 'xxxx,1433' failed: 
    [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 
    'xxx\XXX'.

    A runas windows account for xxx\xxx is created and configured within the needed profiles. Also this user has sysadmin rights on any sql-server and also is SQL Server and Windows Authentication mode activted.

    I dont get, that issue solved and cannot explain me the "login failed"...maybe some hints to go far on this?

    Cheers

    Oliver

    =========================================

    Someothers, similars:

    Event ID: 4001. Management Group: SWICA_SCOM. Script: Main Module: 
    CPUUsagePercentDataSource.ps1 Version: 6.7.7.0 : Error occured during CPU 
    Usage for SQL Instances data source executing.Computer:xxxx 
    Reason: Cannot connect to the target Sql Server instance.Connection 
    log:Failed to connect to data source 'xxxx': Exception calling 
    "Open" with "0" argument(s): "Login failed for user 
    'xxxx'."Failed to connect to data source 
    'xxx,1433': Exception calling "Open" with "0" argument(s): "Login failed 
    for user 'xxxx'." Position:768 Offset:7 
    Instance:P65Event ID: 7104. Management Group: xxxx. Script: DiscoverSQL2014DB.vbs. 
    Version: 6.7.7.0. Instance: D32 : Database discovery script 
    'DiscoverSQL2014DB.vbs' for instance 'D32' failed.The next errors 
    occured:Cannot connect to the target Sql Server instance. Connection 
    log:Connection to data source 'lpc:xxx' failed: [Microsoft][ODBC 
    Driver 11 for SQL Server][SQL Server]Login failed for user 
    'xxxx'.Connection to data source 'xxx,59837' 
    failed: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for 
    user 'xxxxx'.

    Thursday, November 17, 2016 2:58 PM

All replies