?
Solved

remote access option in sql2005 configurations

Posted on 2013-02-04
1
Medium Priority
?
228 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 2000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 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