ITsVISTA
Information that makes life easier when it comes to installing, managing, and using Windows Vista.
Start About FAQ Blogroll Shop

ITsVISTA KB-Link: KB942003

Error message on a Windows Vista-based computer when you try to connect to Microsoft SQL Server Management Studio by using a VPN connection: “The user is not associated with a trusted SQL Server Connection”

On a Windows Vista-based computer, when you try to connect to Microsoft SQL Server Management Studio by using a virtual private network (VPN) connection, you receive an error message that resembles the following:

The user is not associated with a trusted SQL Server Connection

Note: This issue does not occur on a Windows XP Service Pack 2 (SP2)-based computer in the same environment.

On the computer that hosts the SQL Server role, the following events are logged:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17806
Date: Date
Time: Time
User: N/A
Computer: Computer
Description: SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: ClientIPAdress]
For more information, see Help and Support Center at go.microsoft.com/fwlink/events.asp.

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18452
Date: Date
Time: Time
User: N/A
Computer: Computer
Description: Login failed for user. The user is not associated with a trusted SQL Server connection. [CLIENT:ClientIPAdress]
For more information, see Help and Support Center at go.microsoft.com/fwlink/events.asp.

If you enable debug logging for the Netlogon service on the authenticating server, the following entry is logged in the in the Netlogon.log file:

[LOGON] SamLogon: Network logon of Computer\User from Computer Entered
[CRITICAL] NlPrintRpcDebug: Could not get EEInfo for I_NetLogonSamLogonEx: 1761 (may be legitimate for 0xc0000064) (err 0xc0000064 = STATUS_NO_SUCH_USER)
[LOGON] SamLogon: Network logon of Computer\User from Computer Returns 0xC000006A (err 0xC000006A= STATUS_WRONG_PASSWORD)

Note: Computer is a placeholder for the name of the Windows Vista-based computer. Also, User is a placeholder for the user account that you use to log on to the computer.

This entry indicates that Windows Vista uses the Windows Vista-based computer credentials for authentication instead of using the domain credentials.

Note: In different network environments, the following servers can be authenticating servers:

  • A Routing and Remote Access server
  • An Internet Authentication Service (IAS) server
There is a download that resolves this issue. See Hotfixes for details. This issue is resolved in SP1.

For more information on this issue, including potential causes, workarounds, and resolutions, see: Microsoft KB Article KB942003.

Get notified of new posts for FREE via RSS or E-mail

Subscribe to ITsVISTA!

Comments

  • There are no comments yet...Come on, share your thoughts!

Leave a Comment