How connect two server in the same Query

[Rami Said Abd Alhalim]

i used sql server 2005 1- create new query on server 1 2- add exec sp_addlinkedserver server2,'Sql Server' 3- add exec sp_addlinkedsrvlogin 'Server2','false','domain\user','user','password' 4- after that execute for query 5- this Error:(Msg 18452, Level 14, State 1, Line 11 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ) Rami Abdalhalim

[Paul Conrad]

Rami Said Abd Alhalim wrote:

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

Sounds like you need to make the other server, Server2, allow trusted connections. Have you configured it to allow other connections outside of it's machine?

"If you divide your text into sentences, it might be possible to understand what you are trying to say." - Guffa

[Rami Said Abd Alhalim]

how can that?

[Paul Conrad]

Go into the Surface Area Configuration Manager and tweak with it.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

[Marek Grzenkowicz]

Isn't server2 configured to use only Windows Authentication?