Win7 & (SQL2005 / SQL2008) Integrated Security issue / across domains

Discussion in 'Windows 64bit' started by Martin Knauer, Jul 7, 2009.

  1. Hi,

    installed Windows 7 last weekend. The client is not member in a domain.
    Installed SQL 2008 (DEV). SQL-Server is running fine (it seems) on local
    machine.

    Tried to connect at customer-side to their SQL 2008 (OS: Windows Server
    2008) via my SSMS with Integrated Security
    => "Login failed. The login is from an untrusted domain and cannot be used
    with Windows authentication. (Microsoft SQL Server, Error: 18452)"

    Tried to connect at customer-side to their SQL 2005 (OS: Windows Server
    2003) via my SSMS with Integrated Security
    => "Login failed for user ''. Reason: Not associated with a trusted SQL
    Server connection."

    I know these (esp. the last) messages are due to not being authenticated
    within the domain.

    BTW: both SQL-Servers have entries in Application Eventlog "SSPI handshake
    failed with error code 0x8009030c while establishing a connection with
    integrated security; the connection has been closed. [CLIENT: <ipadress>]"


    Previously with Windows XP I opened Windows Explorer, connected to a share
    on the SQL-Server-Computer (supplied and saved my customer credentials).
    After that I was able to connect to SQL 2005 and SQL 2008 via my SSMS with
    Integrated Security successful.

    Tried this "workaround" on Windows 7 also, but without success.

    Any ideas what security settings are blocking me?

    Any hint greatly appreciated.

    ---
    Martin
     
    Martin Knauer, Jul 7, 2009
    #1
    1. Advertising

  2. Seems I'm not alone...

    Found a workaround here:
    http://www.jasonfollas.com/wiki/(X(...Studio on Vista&AspxAutoDetectCookieSupport=1


    --
    ---
    Martin Knauer

    "Martin Knauer" <> wrote in message
    news:udzdXZw$...
    > Hi,
    >
    > installed Windows 7 last weekend. The client is not member in a domain.
    > Installed SQL 2008 (DEV). SQL-Server is running fine (it seems) on local
    > machine.
    >
    > Tried to connect at customer-side to their SQL 2008 (OS: Windows Server
    > 2008) via my SSMS with Integrated Security
    > => "Login failed. The login is from an untrusted domain and cannot be used
    > with Windows authentication. (Microsoft SQL Server, Error: 18452)"
    >
    > Tried to connect at customer-side to their SQL 2005 (OS: Windows Server
    > 2003) via my SSMS with Integrated Security
    > => "Login failed for user ''. Reason: Not associated with a trusted SQL
    > Server connection."
    >
    > I know these (esp. the last) messages are due to not being authenticated
    > within the domain.
    >
    > BTW: both SQL-Servers have entries in Application Eventlog "SSPI handshake
    > failed with error code 0x8009030c while establishing a connection with
    > integrated security; the connection has been closed. [CLIENT: <ipadress>]"
    >
    >
    > Previously with Windows XP I opened Windows Explorer, connected to a share
    > on the SQL-Server-Computer (supplied and saved my customer credentials).
    > After that I was able to connect to SQL 2005 and SQL 2008 via my SSMS with
    > Integrated Security successful.
    >
    > Tried this "workaround" on Windows 7 also, but without success.
    >
    > Any ideas what security settings are blocking me?
    >
    > Any hint greatly appreciated.
    >
    > ---
    > Martin
     
    Martin Knauer, Jul 7, 2009
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ec
    Replies:
    2
    Views:
    467
    Barry Margolin
    May 26, 2004
  2. Andrew != andrew

    net use and dos printing across domains

    Andrew != andrew, Jul 12, 2003, in forum: MCSE
    Replies:
    1
    Views:
    8,695
    licknlabia
    Jul 12, 2003
  3. bill
    Replies:
    11
    Views:
    979
    Charlie Russel - MVP
    Feb 28, 2006
  4. Tarvirdi
    Replies:
    2
    Views:
    963
    Doug Forster
    Nov 10, 2008
  5. Warren Postma
    Replies:
    6
    Views:
    1,589
    FlopShot
    Nov 20, 2009
Loading...

Share This Page