Can SQL Server Management Studio Express be installed standalone?

Yes, you can install Management Studio (or Management Studio Express) on a workstation that doesn't have SQL Server services. Just pick Management Tools - Complete and Management Tools - Basic during setup. You should be able to do this with any edition of SQL Server you have except for the most basic Express editions - just be aware that technically you need to possess at least one license when using it to manage production instances (though that may have loosened up over the years).

If you don't have an edition of SQL Server that comes with client tools, or you don't have a license to use the full version of Management Studio, you can always download Management Studio Express. @Bummi recommended the RTM release of SQL Server 2012 Express, but the Service Pack 2 version is a better option - since it provides a full version of Management Studio that no longer has feature limitations or licensing requirements:

• http://www.microsoft.com/en-us/download/details.aspx?id=43351

I have more thorough download/install instructions in this answer:

• https://dba.stackexchange.com/a/73919/1186

This is possible You can get it from here and just choose to install.

SQL Server Management Studio Express (Tools only)

Yes you can install SQL Server Management on as many machines as you want. The user just connects to the remote SQL Server instances using their domain username and password.

When going through the installer. When you get to the list of stuff to install select only the management tools.