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

Discussion in 'Windows 64 Bit' 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 Knauer, Jul 7, 2009
    #1
    1. Advertisements

  2. Martin Knauer, Jul 7, 2009
    #2
    1. Advertisements

  3. Martin Knauer

    mithos

    Joined:
    Apr 5, 2013
    Messages:
    1
    Likes Received:
    0
    Yay! That worked for me to!

    Using this method, i just allowed my windows 7 starter laptops to use integrated-security access 2007 database with is tables stored on sql 2012 in domain as a back-end. Fantastic!

    Many thanks to you and sir Jason Follas, you saved my day!
     
    mithos, Apr 5, 2013
    #3
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.