JonHarris

I am running my laptop separate from a domain with a local user that has the same username as password as my domain account.

Under Windows XP -> User Accounts -> Manage My Network Passwords I could passthrough my domain credentials to allow myself access to the SQL Server using windows authentication. This is confirmed to have worked with both SQL Server 2000 and SQL Server 2005 from Windows XP.

My current laptop is now running Windows Vista and this method seems to work fine for network access, but does not seem to work for SQL Server authentication using Windows authentication and I receive the following error.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452).

From documentation and other related posts it seems to be a LSA issue. Has anyone found the right Local Group Policy setting or registry setting to resolve this

Any assistance would be appreciated.



Re: Security for Applications in Windows Vista SQL Server Windows Authentication Passthrough problem

ZaDDaZ

I would like to confirm this issue, not being able to connect to any SQL Servers (2000 or 2005) via Windows Authentication from SSMS from Vista even though I have saved credentials for the server. This worked perfect under XP. Please, if anyone knows a solution, pass it on. This is really hurting!



Re: Security for Applications in Windows Vista SQL Server Windows Authentication Passthrough problem

EnvisionOne

Vista w/ SQL 2005 Native client (no sp2) -> Windows XP SP2 w/ SQL 2005 Server does not work using windows authentication. Even though the client is authenticated to the server and can browse shares, it cannot connect via pass-through authentication.

I also think this has something to do with Vista and how it handles credentials in the system.





Re: Security for Applications in Windows Vista SQL Server Windows Authentication Passthrough problem


Re: Security for Applications in Windows Vista SQL Server Windows Authentication Passthrough problem

TheOmnipresent

Hi Guys,
Its been a while someone added to this thread..

I was wondering if someone has been able to find a solution to this problem because it is really a pain to use SQL Server with all these restrictions.

What is a benefit of using Microsoft Technologies if they won't even sync with each other on Authentication