Post reply

Export Data - The login is from an untrusted domain and cannot be used with Windows authentication..

  • December 17, 2010 at 3:05 am

    #244488

    I have installed SQLServer2008 R2 recently on Windows XP machine with Mixed Mode Authentication. And I have SQLServer2005 on the same machine.

    I have added my windows domain account in the SysAdmin role during installation.

    I can logon to SQL2008R2 using the windows account without any problems. But when I try to Export Data from 2008 to 2005 both on the same machine I am getting this error.

    I am in sysadmin role therefore I should be able to export data and do anything without any problem. I googled extensively but none of them have found a solution for this problem yet.

    Can anyone please help me to resolve this?

    Many thanks in Advance.

    ----------------------------------

    Actual Error:

    Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server Native Client 10.0)

    ----------------------------------

    Event Viewer Error:

    Event Type:Error

    Event Source:MSSQL$SQLSERVER2008R2

    Event Category:Logon

    Event ID:17806

    Date:17/12/2010

    Time:09:26:24

    User:N/A

    Computer:GBHOHE7134

    Description:

    SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: <local machine>].

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 8e 45 00 00 14 00 00 00 ŽE......

    0008: 1b 00 00 00 47 00 42 00 ....G.B.

    0010: 48 00 4f 00 48 00 45 00 H.O.H.E.

  • December 17, 2010 at 3:33 am

    #1263972

    Thanks for your reply and time.

    Okay, my domain account has got sa privileges on both 2008/2005 for sure.

    I am logged into the pc using the same domain account therefore its not locked out, if I understand it right or are you referring to something else being locked out.

    And the other thing is when I am trying to export data using Import Export Wizard its not even going past the first screen - 'Choose your DataSource' when I choose my 'Sever name' and 'database' and then click 'Next', that's when I am getting this error...

    P.S: I even reinstalled the SQL2008R2, but it didn't work..

  • December 17, 2010 at 4:11 am

    #1263990

    Thanks.

    This machine is on the network, so I logged into my pc at work using my domain account

    for eg. domain\accountname.

    If you are referring to domain controller, then no I do not have access to it.

  • December 17, 2010 at 4:47 am

    #1264001

    Any more ideas? Thanks.

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

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