Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to connect to a SQL Server 2005 from a Windows 7 machine that is not joined to the domain. This has always worked on XP but on Win7 I get the following error (when connecting via TCP/IP):

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

The eventlog on the server has the errors:

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: (myip)]

Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: (myip)]

The error stays the same if I use the short or FQ server name. I also entered a Windows Credential for the server (since I am not connected to the domain). The connection to the server is OK (I can access network shares).

I spent a few hours trying to solve this but so far I have only found two workarounds:

  • "runas.exe /netonly /user:user@company.dom QueryExpress.exe" This will allow me to connect with the correct user using TCP/IP.
  • or using Named Pipes instead of TCP/IP.

Both options are not ideal (also not all servers have Named Pipes enabled).

Is it possible to get the authentication to work using TCP/IP without runas?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

You'll either have to add the computername/logonid to SQL server or change it from Windows Authentication Mode to SQL Server and Windows Authentication Mode.

share|improve this answer
1  
Thank you but this doesn't help as it would be impossible to administer for all clients/servers. –  hcris Sep 24 '09 at 10:06
    
Unfortunately, you can't have the perks of Integrated Authentication without being on a domain - either create/join a domain or use SQL Authentication. –  CJM Sep 29 '09 at 9:36
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.