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 |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-07-13 : 03:20:08
|
| Hi,When I try to retrive data from another server using the following query,SELECT MAX(column) FROM SVR01.DB.DBO.table I get the error"Server 'SVR01' is not configured for DATA ACCESS."Can you please explain me how to configure this?Regards. |
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-07-13 : 05:26:11
|
| OK. I got it. I didn't give the value for @provider parameter in sp_addlinkedserver.I got the result now. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-13 : 10:49:43
|
| You might also needexec sp_serveroption 'MyRemoteServer', 'data access', 'true'Kristen |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-07-14 : 06:11:33
|
| Thanks for the information, Kristen. I am adding this step also in my notes.But when I gave 'SQLOLEDB.1' for the @provider parameter, it started working. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-14 : 07:47:05
|
| Yup, I spotted that you had it working, so it was only for reference (possibly for the next person searching for answers).Heck, what am I thinking, no one searches before posting do they? :-)Kristen |
|
|
|
|
|
|
Server 'SVR01' is not configured for DATA ACCESS.