Copy from one DB to Other

Question

Copy from one DB to Other

Mohammad-289145

Grasshopper

Points: 14
More actions
December 27, 2005 at 10:34 am

#188758

HI,
I am new to SQl server
I have tow SQl 2005 servers
1: Test -- Database ==> ACC01
2: Dev -- Database ==> ACC02
So I am on server test and like to select from the database table account which is on dev. How I can do that .
==> Select name, amount from DEV.ACC02.ACCOUNT;
====
Now I am geting an error to run -- Sp_ADDlinkserver . CAn any one explain me what is the proper way to run that.

Thanks
M

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Scott Rankin Ten Centuries Points: 1217 More actions · Answer 1

In Server management Studio under the server you want to run your query from... open each tree until you find "Linked Servers." Add the second server as a linked server. Once you do this the first server is "Aware" of the second server.

Mohammad-289145 Grasshopper Points: 14 More actions · Answer 2

Hi,

Under server objects I found Linked server

1: Create New Linked server

2: add "dev1" server name and SQl server option and then I click ok.

Then I ran ===>

select

count(*) from "dev1"."daa-net"."dbo"."account"

I am getting following error.

OLE DB provider "SQLNCLI" for linked server "dev1" returned message "Invalid authorization specification".

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "SQLNCLI" for linked server "dev1" reported an error. Authentication failed.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "dev1".

Please can you explain what I need to do.

Thanks

M

James Gar Newbie Points: 1 More actions · Answer 3

I am having the same problem. Can anyone tell me what to do?

Thanks,

DB