You cannot use user names and passwords that are stored on a Windows Vista-based or Windows Server 2008-based client computer to connect to a server application that is hosted in a domain
Considering the following scenario:
- On a Windows Vista-based or Windows Server 2008-based computer, you are running a client application that must connect to a server application. For example, you are running a Microsoft SQL Server client, a Microsoft Internet Security and Acceleration (ISA) Server client, or a Microsoft Office Excel client.
- The computer that hosts the client application is in a workgroup or in a different domain from the domain that hosts the server application.
- On the client computer, you have stored the domain credentials in Credential Manager.
Note: You can use the Stored User Names and Passwords feature in Control Panel to store credentials.
In this case, the client application that has to obtain domain credentials from Credential Manager cannot connect to the server application in the domain.
For example, assume that you store the domain credentials of an authenticated user in Domain A on a Windows Vista-based computer. This computer is in a workgroup. In this example, when you open SQL Server Management Studio, and you try to connect to a SQL Server installation in Domain A, 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.
For more information on this issue, including potential causes, workarounds, and resolutions, see: Microsoft KB Article KB954545.