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
For more information on this issue, including potential causes, workarounds, and resolutions, see: Microsoft KB Article KB942003.

Start
About
FAQ
Blogroll
Shop
Tips and Tricks
Windows Updates
Hotfixes
Keyboard Shortcuts
Vista's Services
Vista's Commands
Product Reviews
Glossary
Videos
Web Links

Comments
There are no comments yet...Come on, share your thoughts!
Leave a Comment