Recently I have got two desktop computers at home and both of them are very powerful machine.
Machine 1 : Windows Vista SP1 with SQL Server 2008
Machine 2 : Windows 2003 with SQL Server 2005 with SP2
When I was trying to connect from SQL Server 2008 to SQL Server 2005 using Windows Authentication I was getting following error.
Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection.
To resolve this error follow the steps below on computer with SQL Server 2005.
- Create new user with Administrator privilege with same username and password as of SQL Server 2008 in operating system.
- On SQL Server database create new user by expanding DatabaseNode >> Security >> Login >> Create New User and add this new user with Windows Authentication radio button selected. This user can be only added by selected Windows Authentication it is Operating system’s User Login.
Once above two steps are completed when connected from SQL Server 2008 to SQL Server 2005 using Windows Authentication it will connect successfully.
Reference : Pinal Dave (http://www.SQLAuthority.com)