Post reply

When I started job , It is working but I got following errors in SQL SERVER 2012

  • June 26, 2012 at 1:46 pm

    #262891

    hello everybody,

    [382] Logon to server 'DBNAME' failed(ConnLogJobHistory)

    [165] ODBC Error: 0, Invalid connection string attribute [SQLSTATE 01S00]

    Log On As : NT Service\SQLSERVERAGENT (In SQLServer Configuration Manager)

    how to fix ?

    Thanks in advance...

  • June 26, 2012 at 1:49 pm

    #1505825

    Not a lot to work with. Have you checked your SQL Server logs for additional error messages that may help?

  • June 26, 2012 at 8:48 pm

    #1505940

    What exactly does the job do?


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • June 26, 2012 at 11:57 pm

    #1505977

    Hii,

    When I started job, I got SQLServerAgent Error Log following

    .

    .

    .

    .

    Reloading agent settings

    Reloading agent settings

    Reloading agent settings

    Reloading agent settings

    [382] Logon to server 'MYDBNAME' failed (ConnLogJobHistory)

    [165] ODBC Error: 0, Invalid connection string attribute [SQLSTATE 01S00]

    [382] Logon to server 'MYDBNAME' failed (ConnSetJobCompletionState)

    [165] ODBC Error: 0, Invalid connection string attribute [SQLSTATE 01S00]

    [382] Logon to server 'MYDBNAME' failed (ConnAttemptCachableOp)

    [165] ODBC Error: 0, Invalid connection string attribute [SQLSTATE 01S00]

    [382] Logon to server 'MYDBNAME' failed (ConnLogJobHistory)

    [165] ODBC Error: 0, Invalid connection string attribute [SQLSTATE 01S00]

    This job is a DB-back up job.

    In EventViewer Error Log

    The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    Severity: 16 Error:0, OS: 0 [Microsoft][SQL Server Native Client 11.0]Invalid connection string attribute

    the message resource is present but the message is not found in the string/message table

  • June 27, 2012 at 3:53 am

    #1506036

    What type of server is MYDBNAME?

    My guess is the SQL Server Agent account doesn't have the necessary permissions. Use a proxy to circumvent this issue.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 27, 2012 at 6:08 am

    #1506070

    Hii,

    SQL SERVER 2012 Entp.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply