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.

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

1 Answer 1

up vote 4 down vote accepted

You can do that using T-SQL our sister (mother?) site already has the answer: http://stackoverflow.com/questions/1975780/sql-server-enable-remote-connections-without-ssms

Simply log in the sql command line and issue:

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

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.