Post reply

Possible locking problem with Sysadmin login?

  • November 12, 2014 at 3:52 am

    #397632

    Hi all,

    We have an 3rd party backup software that requires Sysadmin rights (I know - I don't like it but that's what they bought, grrr!), however when the backup server logs in we notice that our ODBC is unable to connect to the db...

    Connection failed:

    SQLState: '08001'

    SQL Server Error:0

    [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection

    I have web-searched the error message and run through remedial steps (check Remote Timeout, ensure client tools installed server-side etc) to no effect. The backup software is well-established.

    Any ideas what the problem could be and how to investigate? I'm thinking of locking but this is 2012, I'm grabbing at straws.

  • November 12, 2014 at 3:55 am

    #1757890

    Does anything interesting turn up in the connectivity ring buffer?

    See this article for reference:

    http://www.johnsansom.com/using-sys-dm_os_ring_buffers-troubleshoot-connectivity-issues/

    -- Gianluca Sartori

  • November 12, 2014 at 12:49 pm

    #1758075

    Jake Shelton (11/12/2014)

    Hi all,

    We have an 3rd party backup software that requires Sysadmin rights (I know - I don't like it but that's what they bought, grrr!), however when the backup server logs in we notice that our ODBC is unable to connect to the db...

    Connection failed:

    SQLState: '08001'

    SQL Server Error:0

    [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection

    I have web-searched the error message and run through remedial steps (check Remote Timeout, ensure client tools installed server-side etc) to no effect. The backup software is well-established.

    Any ideas what the problem could be and how to investigate? I'm thinking of locking but this is 2012, I'm grabbing at straws.

    My recommendation would be to put the onus on the 3rd party backup software company and ask them for a solution. They're probably already charging you for support in some manner. Make them do it. Being a bit of a BSFH on these types of things, I'd make the person the insisted on buying the 3rd party software do it so they can learn the lesson. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

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