Online Members

i want to access records from different server in sql server 2005. Pls help me out

Posted Date: 20 Nov 2007 Posted By:: Rajesh Member Level: Silver Member Rank: 0 Points: 2 Responses: 4

i want to access records from different server in sql server 2005

Suppose i am in server1.

I need access the records from server2.

How to do it.

Now i am in server1.
select * from server2.DB_data.dbo.tblparticipants1

it says login failed for sa

Responses

#164847 Author: Gunarathinam.M Member Level: Gold Member Rank: 0 Date: 20/Nov/2007 Rating: Points: 2
Hi, U need to use Linked Server concept in SQL server 2005. U just add the Server2 in linked server group and then query as u mentioned above. Thanks, Guna.

#164850 Author: Rajesh Member Level: Silver Member Rank: 0 Date: 20/Nov/2007 Rating: Points: 2
Here i have used EXEC sp_addlinkedserver 'Server2' Again its sayings -Error login failed for sa Please help me

#164852 Author: Rajesh Member Level: Silver Member Rank: 0 Date: 20/Nov/2007 Rating: Points: 2
Here i have used EXEC sp_addlinkedserver 'Server2' Again its sayings -Error login failed for sa Please help me

#164853 Author: Rajesh Member Level: Silver Member Rank: 0 Date: 20/Nov/2007 Rating: Points: 2
Here i have used EXEC sp_addlinkedserver 'Server2' Again its sayings -Error login failed for sa Please help me

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : i want to access records from different server in sql server 2005. Pls help me out
	Previous : Pls help me- i want to access records from different server in sql server 2005(Error login failed)
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John