October 4, 2018 at 6:25 am
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
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
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 8:11 am
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy