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 |
|
actsql
Starting Member
34 Posts |
 Posted - 2010-05-14 : 10:37:22
|
| I feel compelled to apologize in advance for my ignorance, however, I am not a trained administrator and am learning as I go with regard to writing code in SQL Server (we are on 2005). I have a query from Access that referred to 2 different SQL servers. I am trying now to code it into SQL, however, when I log into the one database, I cannot access the other and vice versa.My online research has revealed sp_addlinkedserver as the solution, however, when I try to run that command I get an error that I dont have permission.Can anyone recommend a book or other training media I can use to get up to speed on what I need to do? I need to know where to look at my permissions, what needs to change, what database I need to have permissions on, etc. Basically everything from the ground up.Thank you.A.C. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-14 : 10:43:20
|
| Start with SQL DOCs - "Book online" that you can download / install on your PC (if you don't already have it).That may answer your specific question on sp_addlinkedserver (the DOCs are "online" too on Microsoft's site if you just want to check that command first) |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-14 : 13:04:14
|
| " no amount of reading is going to help you"Although the DOCs do say what level of permissions you need - so the O/P, armed with that info, could request the necessary permissions perhaps? |
|
|
|
actsql
Starting Member
34 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-15 : 04:10:09
|
| "Am I correct in understanding you have to be sysadmin to use sp_addlinkedserver?"Don't think so (although SYSADMIN can certainly do this task!!!), this is from the link you posted:PermissionsRequires ALTER ANY LINKED SERVER permission.(Note that link is for SQL2008, there is a back-link to SQL2005 if you are on an earlier version - in case it is different [I have SYSADMIN on all DBs here, so its not something I have committed to memory!] |
|
|
|
actsql
Starting Member
34 Posts |
Posted - 2010-05-15 : 11:27:58
|
| Thankyou. I will investigate the link back to 2005. That's what we are on still. |
|
|
|
|
|
|
|
|
sp_addlinkedserver