Remote Access checkbox causing error in SQL Server 2005 SP3

Question

question

Noonies asked Nov 30, '11

Remote Access checkbox causing error in SQL Server 2005 SP3

Hello everyone! 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?

sql-server-2005 access remote

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton commented · Jan 04, 2012 at 12:29 PM

Have you followed these steps: http://support.microsoft.com/kb/914277

0 ·

Noonies commented · Jan 04, 2012 at 02:45 PM

I'm running SQL Server 2008 R2 but the database is a SQL Server 9.0.4035. (SQL 2005). The SSMS info I pull from the server while connected to the Sharepoint DB is Microsoft SQL Server Management Studio 10.50.1600.1 I do not have any of the SQL 2005 tools installed.

0 ·

Answer 1 · 2012-01-04T07:46:13Z

Usman Butt answered Jan 4, '12

I have not worked on Shared Point yet, but I hope the below connection string could help you out \\.\pipe\mssql$microsoft##ssee\sql\query which I find out in below links http://sharepointthing.wordpress.com/2011/01/23/how-to-connect-to-the-sharepoint-services-integrated-database-with-sql-server-management-studio-express/ http://channel9.msdn.com/Forums/TechOff/255490-How-to-connect-MICROSOFTSSEE There are some more options in the latter one.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question