configure a server to allow remote connections?

Question

 

For some unknown reason, the surface area configuruation tool isn't allowing me to configure my local server to allow remote connections, so, I need to do this manually.  My understanding is that I can use the sp_configure stored procedure to do this.  Is this correct?  If so, how can I use this store procedure to configure my local server to allow remote connections?  An example would be helpful.

 

Thanks in advance.

Answer 1

These articles should help you.

 

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

 

 

Answer 2

Arnie Rowland wrote:

These articles should help you.   Configuration -Configure SQL Server 2005 to allow remote connections http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuration -Connect to SQL Express from "downlevel clients" http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Thanks, but these links don't help me.  I'm running SQL Server 2005 Standard on Win2k SP2 and windows firewall disabled.

Answer 3

does anyone know how to do this using sp_configure (if possible)?

Answer 4

microsoft? anyone?

Answer 5

Hi Douglas,
                I found this link,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=107318&SiteID=1  pls refer the quote from one of the moderator

For remote connections, you have to use SMO to do it. Doing it from TSQL directly is not possible since it requires manipulation of registry values and please don't use the undocumented XPs for registry manipulation.

Regards
Deepak

Answer 6

Yes Mr. Duane you can achive it using  sp_configure option.

Below is the query to achieve it.

sp_configure 'remote access', 1

 

Regards,

Venkatesan Prabu. J

Provide me your feedback duane.

Answer 7

Venkatesan Prabu wrote:

Yes Mr. Duane you can achive it using  sp_configure option. Below is the query to achieve it. sp_configure 'remote access', 1   Regards, Venkatesan Prabu. J Provide me your feedback duane.

 

Venkat.. Remote Connection and Remote Access are two separate setting. I could not figure out a way to enable Remote Connection using SP_Configure

 

 

Madhu

 

Answer 8

 

I can second that you will have to enable remote connections, You can call the commandline tool which can be downloaded from my site (RemoteConnectionsEnabler). If you have any problems with that or need more information about this (which uses SMO) feel free to contact me.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---

Answer 9

Hi Duane,
 Just an update pls refer this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2402474&SiteID=1 there is no built in way using sp_configure as already mentioned  but  you can write your own sp to perform it as shown in the above link....pls check if it helps !

- Deepak

Answer 10

Hi,

Refer the below link, I think this may help you
Enable Disable Remote connections Via DOS or T-SQL