Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any?, What another scriptable process to modify it you do know?

share|improve this question
up vote 1 down vote accepted

You mean the "allow remote connections" setting in management studio? link text

I'm guessing you dont want this. This option turns on the sp_configure 'remote access' , 1 option, which is an old feature of SQL Server that pre-dates linked servers.

What you actually want is this: How to configure SQL Server 2005 to allow remote connections (the naming convention here isn't at all confusing!)

In which case, yes there's a registry key. Assuming you only have a default instance installed, then the registry path is:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

with a key for each protocol. eg. tcp, sm (shared memory) np (named pipes)

A value of enabled is set to 1 inside each key of tcp or np, depending on what you want enabled.

The easiest way (for me at least) is to script this with xp_regwrite which is an undocumented stored procedure, but does the job & means you can include it with your other sql server configuration scripts that run in sqlcmd/SSMS after an install is performed.

eg:

exec master..xp_regwrite
     'HKEY_LOCAL_MACHINE'
     ,'Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp'
     ,'Enabled'
     ,'REG_DWORD'
     ,1
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.