August 17, 2010 at 10:18 am
I am trying to run below command
sp_configure 'remote access', 0
just wondering is there any issue with connecting sql server.
August 17, 2010 at 11:09 am
The 'remote access' sp_configure option doesn't affect the ability to connect to the SQL instance from a different computer, it affects the ability to execute remote stored procedures, or have remote linked servers execute local stored procedures as per the Books Online topic:
http://technet.microsoft.com/en-us/library/ms187660.aspx
If you are having trouble with getting Remote Connections into a SQL Server instance, make sure that you have TCP/IP configured in the instance Network Configuration. Full details of what is needed to do this can be found in the following KB Article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply