Enable Remote Access to SQL Server 2008 R2 (no SSMS)

remote-accesssql-server-2008

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?

Best Answer

You can do that using T-SQL our sister (mother?) site already has the answer: https://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