RPC vs. RPC Out for Linked Servers

When configuring a Linked Server the Server Options tab has check boxes for 
RPC and RPC OUT.  Can someone explain why you would or wouldn't need to 
enable either of these options?  Thanks!
2/11/2010 9:34:16 PM
sqlserver.server 1327 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 54

Tom Ashby - Panam (Tom Ashby - Panam@discussions.microsoft.com) writes:
> When configuring a Linked Server the Server Options tab has check boxes
> for RPC and RPC OUT.  Can someone explain why you would or wouldn't need
> to enable either of these options?  
One of them, has no function at all, as far as I know. The other controls
whether you are permitted to make Remote Procedure Calls over the linked
server. That is, call remote stored procedures or EXEC() AT. I don't
remember which is which, but I think RPC OUT is the useful one.

As for why you would not enable a server for RPC. Hm, beats me. Well, some
data sources may not support RPC, but you need to have a server option to
turn somthing off which does not work anyway. But, OK, if you turn off
RPC OUT, you do reduce what is possible to do on the other side. Or at
least make some thing like updating more difficult.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

2/11/2010 10:52:43 PM

Similar Artilces:

ignore that last message, accidently posted to the wrong group. ...

Excel links broken by server migration
Hello, I have a question regarding links between Excel files that has been lingering in my mind for days. The IT department will migrate my directories and files to a new directory on another server, so the path of my many Excel files will be changed, braking the links between these files. Since I have over 100 Excel files with several links within each file, it would take me too much time to open them all and change the links. Could somebody tell me whether there is a way to tackle this problem ? I'd imagine that something needs to be done in the copying process (in the server ...

Exchange Server Name on Emails
We use an internal domain, so our 2003 Exchange Server is server1.domainname.local. Our email addresses are user@realdomain.com. When we send out email, the recipient sees the server as server1.domainname.local, and on occasion our mail is rejected because "reverse DNS failed." Is there anyway for our Exchange Server to show the server name to be servername.realdomain.com on the address that accompanies the email message? You can change this in the properties of the SMTP Virtual Server in Exchange System Manager. 1. Right click on the SMTP Virtual Server. Choose Propertie...

When I try to open the Report Launcher I got this error message "Great Plains - SQL Server\MSDE - Accounting system is not registered" Please help! FRX Ver. 6.5 SP7 Thanks, -- Omar Ale Well, is it? If you go to Admin...Organization are the registration keys valid? "OmarAle" <OmarAle@discussions.microsoft.com> wrote in message news:5A0BDDB9-C370-4247-83D5-F7CD1F679FB9@microsoft.com... > When I try to open the Report Launcher I got this error message > "Great Plains - SQL Server\MSDE - Accounting system is not registered" > > Please help! &...

Exchange Server Quota Message Service
I'm testing ExQMS.exe, file version, in our Ex2k3 environment. Client is OLK2K3. Has anyone worked with this ad-on for Exchange ? Are their any unknowns, or gotchas that one should be aware of this add-on? In one test environment I have this product working..but in another test environment, I'm getting RPC errors and in the app event log it shows... "Faulting Application QuotaService.exe version 6.5.7830.0 faulting module unknown, version fault address 0x616e346e " Any information that can be provided would be most helpful. SRP How best to put th...

Reconnecting to exchange server
I have users that are connected via VPN tunnel, running Outlook 2003 in cached mode, multiple times during the day a window will appear stating that it is reconnecting to the exchange server. The option is set to download headers when a slow connection has been detected. It does not state that it has been detected only that it is trying to reconnect. I am wanting to make sure that the clients are connected and if are disconnected that is shows they are disconnected. Also, how to get rid of the popup window? Any help is greatly appreciated. ...

linked pictures in Excel
I have a problem, I open an HTML page in excel which has an <img> tag, when i open the page it looks fine but when i save as xlsthe document, the image is not saved with the document, instead every time i open the document the image is fetched from the webserver again. I had the same problem with the word but in word I had the option of break the links which solved the problem ...

does IIS server effect the Outlook working
My outlook is working for incoming emails but not for outgoing emails. incoming= POP3 = port:110 Outgoing= SMTP = port: 80 iis server is using the same port no. 80 is it a problem Currently i am having .NET in my system does it affect Outlook work. I am using Godaddy server, incoming: mail.cybersoftdesigns.com outgoing: smtpout.securesrver.net Help me. Did you activate SMTP relay on your GoDaddy account? By the way, the ports GoDaddy supports is 25, 80, and 3535 for smtpout.secureserver.net. If the above question is a yes, give 3535 a shot. (By the way, I took this from http://help.g...

logging inmicrosoft exchange server for the first time
want to use outlook for aol mail but cannot figure it out need help Try this: Select Tools | Accounts from the menu in Outlook or Outlook Express. Click Add, choose Mail, enter your name, click Next. Enter your AOL email address, click Next. Select IMAP under "My incoming mail server is ...". Enter "imap.aol.com" in the Incoming mail server field. Enter "smtp.aol.com" under Outgoing mail server, click Next. Type your AOL screen name under Account name, and your AOL password in the Password field, and click Next, then Finish. Highlight imap.aol.com in the Interne...

Can Not Connect to Exchange Server after Mailbox Move
I have 2 exchange servers. While logged into the domain, and at the location, I can log into the email system just fine. While remote VPN in, I can not access the server. I can ping the server, I can see all shares, and I can even access the printer and print from the exchange server. But I can not get to it with email. Any Ideas? Oh.. both exchange 5.5, both in the same site. Exchange Admin shows both sites just fine. is there a firewall with rules configured, in between the users vpn connection and the internal network? kmelillo@gmail.com wrote: > Oh.. both exchange 5.5, bot...

How to share outlook 2003 calendars without and Exchange server
I have a few outlook 2003 users with pop mail accounts that are on a domain, however are not on an exchange server that want to share calendars. Can this be done and how? Thanks No with an MS product. There may be products out there that will provide this functionality however I'd suggest you just give them an Exchange account for calendaring purposes. Nue "ghutnick" <ghutnick@discussions.microsoft.com> wrote in message news:2CC3EDA7-FBC8-4D79-BEEB-89E654EB261A@microsoft.com... >I have a few outlook 2003 users with pop mail accounts that are on a >domain, &g...

Excel Changes Links Improperly
We are having a problem where Excel changes links to other workbooks and breaks them. This comes up in the following scenario. Different users have access rights to different directories and have their drives mapped differently (i.e. to the directories they have access to). Sometimes a user modifies data in a file that has links to directories that don't exist for them. Of course the links don't work for them, but that's ok. What isn't ok is that when they save the file, Excel changes the links (apparently trying to make the links relative to drive where this use...

Heading Row in a linked list
Hi, From MS Word, I linked an Excel list, which is containing more than 200 records. Now that list is visible as a table in Word. But the field names (i.e. Heading Row) are visible only on the first page of the printout in Word. Is it possible to display the Heading Row in all the pages? - Krisunela Yes. In MS Word 2002, the "Heading Rows Repeat" command under Table menu is disabled. - Krisunela "Frank Kabel" <frank.kabel@freenet.de> wrote in message news:uiMyMRjREHA.1392@TK2MSFTNGP09.phx.gbl... > Hi > not sure but have you tried in MS Word: 'Tabel - Hea...

Emailed HTML Links Sometimes Work, Sometimes don't
Am autogenerating email messages using .ASP. When the message I'm sending contains an http link, most of the user's receiving it can open it, but some cannot. The http address displays as part of the normal text. A good number of my users have no technical expertise -- cut and paste is foreign to them. Asking them to cut and paste these links into their browsers if they can't open the link would turn them off big time. Is there a way I can.... 1) Assure that the links will be active for anyone receiving them? 2) Auto-open the links so that the user doesn't have ...

#NAME? error on links
Hi All I've copied range [workbook1]worksheet1!D26:K37 and Edit>PasteSpecial>Paste Link in workbook3. I've then copied range [workbook2]worksheet1!D26:K37 and also Paste Linked to workbook3. When I've re-opened workbook3 and updated the links, the range linked to workbook1 is updated correctly, however, ranges D33:E37 and J33:K37 from workbook2 return #NAME? errors (D26:K32 and F33:I37 are correct). If I open workbook2, the errors are resolved and the correct values returned but close workbook2 and update the links produces the #NAME? error again. Any ideas? Regards St...

ComboBox and Linked Tables
Not sure where the best place for this topic but here it goes.. How can I have a combobox populate itself with a list of all the linked tables in the DB? Specifically tables that are linked to other MDBs. I have ODBC connections to an Oracle box that I don't need to worry about. Any ideas? Set its RowSource to SELECT Name FROM MSysObjects WHERE Type = 4 ORDER BY Name -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "David Mulholland" <DavidMulholland@discussions.microsoft.com> wrote in message news:6169DF4F-DA35-40F0-8F46-C322A926...

link of saved views
Hi, Is there a way to catch link of saved views. I create view (lost Opportunities) and I need to put it in workplace area using sitemap or isv.confg thanks, In CRM 4.0 it is available from the view's toolbar (Copy Shortcut/Send Shortcut menus). In CRM 3.0 you can use a tool like Fiddler (www.fiddlertool.com) to see what's requested. -- Michael H�hne, Microsoft Dynamics CRM MVP Web: http://www.stunnware.com/crm2 Feed: http://www.stunnware.com/crm2/atom.aspx Custom Lookup Dialog: http://www.stunnware.com/crm2/?area=customLookup The JavaScript Snippets Directory: http://www.stu...

Duplicate emails after changing POP3 server name
This might be a similar problem to the "Emails over and over," below. We run an Exchange 2000 server (W2K/SP4) in our office, and allow users in a remote office to get their email by POP3. To make a long story short - we had to change the name of the POP server in Outlook from a valid DNS name to a local network name. Now, one of the users (Outlook 2002) who leaves his email on the server is getting duplicate emails of everything that's already in his in-box. It was very handy - he left a copy of messages on the server so that he could use Outlook Web Access and have a backu...

Problems with exchange 2003 server viewing public folder perimisions and MFBPublish
X-No-Archive: yes Since we have migrated from Exchange Server 5.5 to 2003, we are getting MFBPublish errors in the event log every 25 minutes. (Error initialising session for virtual machine mailserver. The error number is 0x80040111. Make sure Microsoft Exchange Store is running - eventid 8197). The Microsoft Exchange Store is running. Advice from Technet has made no change. We also get a MAPI 1.0 error (The Information store could not be opened. The logon to the Microsoft Exchange server computer failed) when trying to view client permissions on public folders locally on our mail se...

Linked Tables
Hello All, Any suggestions would be greatly appreciated. This problem has been bothering me for a week now. I have a make table query which takes data from a linked Excel table and creates a new 'Combine' table. When it creates the Combine table I also add another field called 'Source' to the Combine table. I then have several append queries which I link to additional Excel linked tables. I take this data and add it to the Combine table along with a 'Source' field. I created the source field because I needed to have a field which would tell me which linked tabl...

remove exchange 5.5 server without uninstalling
Currently I have exchange 5.5 running along with exchange 2003. The emails are routed from internet to 5.5 and then send over to 2003, and vice versa. Currently I do not have a mx record for exch 2003 server, I have one mx record only for 5.5. Now before completely removing exchange 5.5, is there anyway that I can stop the exchange services on 5.5 and see if everything will still function properly in the network. i.e. I should be able to send to external users outside my org and also receive emal successfully.I dont want to have any problems creep up later. If things dont work well on t...

Disable Copy & Paste files but not text for Windows Server 2008 R2
I have a windows server 2008 r2 and am running remote desktop services. I want to disable cut/paste of files via clipboard/clipbook, while at the same time enabling cut/paste of text via clipboard/clipbook. This is working in earlier version of Windows. Any suggestion is much appreciated. -- Hannkwang ------------------------------------------------------------------------ Hannkwang's Profile: http://forums.techarena.in/members/199146.htm View this thread: http://forums.techarena.in/windows-server-help/1319418.htm http://forums.techarena.in ...

RPC over HTTP in domain vs. not in a domain
I have noticed an interesting peculiarity in Outlook 2003 using RPC over HTTP. I have Outlook 2003 on two different computers. One computer is in a office and is in a domain (not the same domain as the Exchange server), the other computer is in a home and is not in a domain. Both are running XP Pro and have same service packs and Q331320. Both are set to connect to the same remote Exchange 2003 server (2K3 SBS) using RPC over HTTP. Here's the big difference, the Outlook 2003 on the computer in a domain (again, a different domain than the remote Exchange server) has the ability to see the ...

Second Exchange Server #2
Can anyone tell me if it is possible to add a second 2003 exchange server to a domain and have them geographically separate. Is there some step by step guide to setting this up? How do users in the domain get there email from there local exchange server? Possible, as long as you have a local Global Catalog you shouldn't have any issues. Make sure name resolution (DNS) is working across sites. Install Exchange and add server to the Exchange Org. Message routing should work between the sites out of the box (Exchange assumes all servers are installed in one Routing Group - servers w...

SQL Server verses Sharepoint
I am converting a big Access 2000 Database to Access 2007. Since Access 2007 no longer has workgroup security, I will also need either SQL Server or Sharepoint. I have not worked in either before. Is Sharepoint able to handle large tables and dozens of users the way SQL Server is? I also will require Replication. Which one is easier to set up for replication? Should I first use SQL Server and then use Sharepoint from SQL Server? Which would be the easiest way to go? Thank you gmg <gmg@discussions.microsoft.com> wrote: >I am converting a big Access 2000 Database...