Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer

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
add comment

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.