Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jeff06
Posting Yak Master
166 Posts |
Posted - 2007-05-17 : 13:36:42
|
machine A and B in the same network.A has dbs A1, A2,A3...B has dbs B1 B2 B3....I conect to B first using sql query analyzer. how I can access A1 in A? Thanks.Jeff |
|
Kristen
Test
22859 Posts |
Posted - 2007-05-17 : 13:38:41
|
On ServerB make a Linked Server for ServerAThen you can access TableA in DatabaseA as:SELECT * FROM ServerA.DatabaseA.dbo.TableAKristen |
|
|
jeff06
Posting Yak Master
166 Posts |
Posted - 2007-05-17 : 13:46:34
|
AFTER RUN SELECT * FROM ServerA.DatabaseA.dbo.TableAI got following msg:Server: Msg 7202, Level 11, State 2, Line 1Could not find server 'serverA' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.How can i fix this problem?Thanks |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-05-17 : 13:48:05
|
Doesn't the error message tell you exactly what to do? As did Kristen.Kristen:"On ServerB make a Linked Server for ServerA"Error Message:"Could not find server 'serverA' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
jeff06
Posting Yak Master
166 Posts |
Posted - 2007-05-17 : 14:01:34
|
Thank you for your response:When I do:EXEC sp_addlinkedserver @server='serverA'i got:User does not have permission to perform this action.I have read right to both database ( A and B). Do this mean I have to ask the DBA to give me some rights to run sp_addlinkedserver ?Thanks.JEff |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-17 : 14:07:35
|
The DBA will need to setup the linked server for you.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
jeff06
Posting Yak Master
166 Posts |
Posted - 2007-05-17 : 14:08:27
|
Thank you for your response:When I do:EXEC sp_addlinkedserver @server='serverA'i got:User does not have permission to perform this action.I have read right to both database ( A and B). Do this mean I have to ask the DBA to give me some rights to run sp_addlinkedserver ?Thanks.JEff |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-17 : 14:08:38
|
"Do this mean I have to ask the DBA to give me some rights to run sp_addlinkedserver"Yup, I expect you don't have permissions to create a linked server.Personally I don't think that:EXEC sp_addlinkedserver @server='serverA' is "rich" enough - in terms of what I consider to be the minimum requirements of a linked server.Kristen |
|
|
|
|
|