Post reply

Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context

  • October 4, 2018 at 6:25 am

    #369021

    Hi Experts ,

    I have installed BCP utility in Linux server.
    when am executing below command it throwing error, any input to resolve this issue.

    /opt/mssql-tools/bin]$ ./bcp test.dbo.ACCOUNT in "u01/bcp/file/ACCOUNT.txt" -T -t, -c -U admin\\admin1-S 10.187.111.99,36686\\admin
    SQLState = S1000, NativeError = 851968
    Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]SSPI Provider: No Kerberos credentials available (default cache: KEYRING:persistent:23179318)
    SQLState = S1000, NativeError = 851968
    Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context

    Thanks,
    RR

  • October 4, 2018 at 6:55 am

    #2008032

    This is a duplicate post.   Please respond only in the original thread, here:

    https://www.sqlservercentral.com/Forums/Dialogs/PostDetails.aspx?PostID=1998574

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • October 4, 2018 at 6:56 am

    #2008033

    The error is telling you the problem here. You're trying to use Kerberos authentication on a Server that doesn't support it/doesn't have it configured. You need to configure Kerberos, or use SQL Authentication.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 4, 2018 at 7:51 am

    #2008057

    @thom-2 A: -

    You need to configure Kerberos, or use SQL Authentication.       
    Do you have any link or doc which i can refere to understand what are the things need to perform.

  • October 4, 2018 at 8:11 am

    #2008070

    SATYA R - Thursday, October 4, 2018 7:50 AM

    @thom-2 A: -

    You need to configure Kerberos, or use SQL Authentication.       
    Do you have any link or doc which i can refere to understand what are the things need to perform.

    I recommend Google, Bing, or DuckDuckGo; Try "Add Linux {Distribution} to Windows Domain" or "Use AD Authentication on Linux {Distribution}". I've never personally added a Linux Machine to a Domain,, and the way it'll work will (likely) differ from distribution to distribution, although I've read into it for Ubuntu. Be VERY careful though, I recommend noting your steps and take back ups. It doubt it'll be a quick or simple task.

    I am, of course, assuming your SQL Server is on a Windows Server, within a Domain. If it isn't, you're going to need to set up a domain, or use SQL Authentication. The former is far far too much to discuss in a forum environment; you should be getting your network Administrator to do that.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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