remote access option in sql2005 configurations

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 ?
motioneyeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
deviprasadgConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.