Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

My VPS has limited space, and was trying a few times to install SQL Server 2008 R2 with SSMS; but installation has failed due to hard drive free space (there only 2.5 GB). Now my plan is to install only SQL Server 2008 R2. It can be administered remotely, but on every link found about how to enable remote access there step that involves local SSMS:

  • check "Allow remote connections to this server"

    My question is can it be done without SSMS installed?

share|improve this question
What version? Express is the only version that has remote connections off by default, Standard, Dev and Enterprise allow them by default. – Zypher Jul 2 '12 at 17:46
Mine is SQL Server 2008 R2 Express – volody Jul 2 '12 at 17:48
up vote 4 down vote accepted

You can do that using T-SQL our sister (mother?) site already has the answer:

Simply log in the sql command line and issue:

EXEC sys.sp_configure N'remote access', N'1'
share|improve this answer
Damn, beat me by a couple of mouse clicks! – Brent Pabst Jul 2 '12 at 17:54

Your Answer


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.