How connect two server in the same Query
-
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
-
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
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 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
how can that?
-
how can that?
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
-
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
Isn't server2 configured to use only Windows Authentication?