none
Connection Failed

    Pregunta

  • Hello

    I have SCOM2012 with 2 Management server and seprated db server when i want to install ACS in sql server login step return error ! connection failed :

    martes, 12 de junio de 2018 6:08

Todas las respuestas

  • Hi! Have you made sure that your current account has permissions to the database? Is the database located locally or remotely? Best regards, Leon

    Blog: https://thesystemcenterblog.com  LinkedIn:   

    martes, 12 de junio de 2018 6:15
  • Hi

    my database is remotly both windows and sql connect return error!

    my user is admin and  i created sql user where is sysadmin but return error

    martes, 12 de junio de 2018 6:24
  • Make sure the 'DOMAIN\SCOMSERVER' account exists in AD. And also make sure you have selected "SQL Server Authentication" mode for user you created from Server -> Security -> Logins option.

    If you get a failure like Login failed for user 'DOMAIN\MACHINENAME$' it means that a process running as NETWORK SERVICE or as LocalSystem has accessed a remote resource, has authenticated itself as the machine account and was denied authorization.

    Try granting the login privileges to the account "domain\machinename$” in the remote SQL Server. For more information, refer to the following link:

    https://blogs.msdn.microsoft.com/sql_protocols/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections/


    Blog: https://thesystemcenterblog.com  LinkedIn:   

    martes, 12 de junio de 2018 6:39
  • AD ? means what?
    martes, 12 de junio de 2018 7:10
  • AD = Active Directory, in your domain.

    Blog: https://thesystemcenterblog.com  LinkedIn:   

    martes, 12 de junio de 2018 7:12
  • Hi,

    Is it just me or there's no error message in the question?

    Can you please post the error message as text please.

    Cheers


    Sam (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" wherever applicable. Thanks!) Blog:AnalyticOps Insights Twitter:Sameer Mhaisekar

    martes, 12 de junio de 2018 7:53
  • Hi,

    Is it just me or there's no error message in the question?

    Can you please post the error message as text please.

    Cheers


    Sam (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" wherever applicable. Thanks!) Blog:AnalyticOps Insights Twitter:Sameer Mhaisekar

    Hi , I create sql user and test login both windows and sql athenticate

    I can login with sql user to sql server from other server!!! but due install acs couldn't 

    error message:

    connection failed:
    sql state:'01000'
    sql server error:67
    [microsoft] [ODBC sql server driver][DBNETLIB]connection open (connect())
    connection failed:
    sql state:'08001'
    sql server error:17
    [microsoft] [ODBC sql server driver][DBNETLIB]sql server does not exist or access denied


    • Editado Y_mrs miércoles, 13 de junio de 2018 4:20
    miércoles, 13 de junio de 2018 4:17
  • Hi,

    Can we know what article are you following for installing?

    Install ACS SCOM 2012

    Cheers


    Sam (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" wherever applicable. Thanks!) Blog:AnalyticOps Insights Twitter:Sameer Mhaisekar

    miércoles, 13 de junio de 2018 4:47

  • error message:

    connection failed:
    sql state:'01000'
    sql server error:67
    [microsoft] [ODBC sql server driver][DBNETLIB]connection open (connect())
    connection failed:
    sql state:'08001'
    sql server error:17
    [microsoft] [ODBC sql server driver][DBNETLIB]sql server does not exist or access denied


    The error message shows there are no sql server with this name, which you are using. Suggest you to use windows authentication using ad account and give the privilege to same account as a sysadmin over server. Now check and revert with outcomes. 

    Cheers, Gourav Please remember to mark the replies as answers if it helped.

    • Propuesto como respuesta GouravIN miércoles, 13 de junio de 2018 14:12
    miércoles, 13 de junio de 2018 5:35
  • Also make sure you did choose "Remote database server", since you mentioned the database was remote.
    If you did choose the correct choice, how did you enter the "Remote database server machine name" ?

    Blog: https://thesystemcenterblog.com  LinkedIn:   

    miércoles, 13 de junio de 2018 6:33
  • Also make sure you did choose "Remote database server", since you mentioned the database was remote.
    If you did choose the correct choice, how did you enter the "Remote database server machine name" ?

    Blog: https://thesystemcenterblog.com  LinkedIn:   


    yes i am sure
    miércoles, 13 de junio de 2018 8:41
  • error message:

    connection failed:
    sql state:'01000'
    sql server error:67
    [microsoft] [ODBC sql server driver][DBNETLIB]connection open (connect())
    connection failed:
    sql state:'08001'
    sql server error:17
    [microsoft] [ODBC sql server driver][DBNETLIB]sql server does not exist or access denied

    As GouravIN mentioned, the error 67 indicates that the server cannot find the machine.

    Since it's trying to connect to a named instance, make sure the SQL Server Browser service is started on the SQL Server computer.



    Blog: https://thesystemcenterblog.com  LinkedIn:   


    • Editado Leon Laude miércoles, 13 de junio de 2018 13:14
    miércoles, 13 de junio de 2018 13:13
  • error message:

    connection failed:
    sql state:'01000'
    sql server error:67
    [microsoft] [ODBC sql server driver][DBNETLIB]connection open (connect())
    connection failed:
    sql state:'08001'
    sql server error:17
    [microsoft] [ODBC sql server driver][DBNETLIB]sql server does not exist or access denied

    As GouravIN mentioned, the error 67 indicates that the server cannot find the machine.

    Since it's trying to connect to a named instance, make sure the SQL Server Browser service is started on the SQL Server computer.



    Blog: https://thesystemcenterblog.com  LinkedIn:   


    Hi

    My sql server Browser service is up but i don't know why didnot connect to db server

    Ms can connect to operationmanagerdb and DW but cannot create and connect for auditdb!

    I have ping from that servers

    martes, 19 de junio de 2018 7:21
  • Are all the servers in same domain?

    Cheers, Gourav Please remember to mark the replies as answers if it helped.

    martes, 19 de junio de 2018 7:24
  • yse all are in same domain
    martes, 19 de junio de 2018 7:31