I cannot check remote access in Connections of the SQL instance I am running, Sharepoint SQL Instance, because I am getting: The specified option 'remote access' is not supported by this edition of SQL Server and cannot be changed using sp_configure. (Microsoft SQL Server, Error: 15392)
Is there a way I can configure the remote access value to 1 so that I can remote connect to the SQL Server Instance?
I have not worked on Shared Point yet, but I hope the below connection string could help you out
which I find out in below links
There are some more options in the latter one.
answered Jan 04, 2012 at 07:46 AM