Solved

remote access option in sql2005 configurations

Posted on 2013-02-04
1
223 Views
Last Modified: 2013-02-07
I wonder how this option will effect our connectivity to sql2005? if I set this disable, will it impact our connection to SQL2005 using any client tool such ssms,sqlcmd or any other program that run by application ?
0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 10

Accepted Solution

by:
deviprasadg earned 500 total points
ID: 38853854
According to MSDN:
Set remote access to 1 (default) to grant permission to run local stored procedures from remote servers or remote stored procedures from the local server.

The remote access option only applies to servers added using sp_addserver and is included for backward compatibility

Refer: http://msdn.microsoft.com/en-us/library/ms187660(v=sql.90).aspx

Looks like your connectivity will not impact, but would impact execution of stored procedures on the servers added using  sp_addserver.


This link has details on the remote connectivity: http://support.microsoft.com/kb/914277
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question