8

I was wondering if the SQL Server Management Studio Express (mainly for Microsoft SQL Server) be installed on a standalone machine (without any of the SQL Services and stuff) to connect to a remote database?

I run a SQL Server 2012; I have been told by one of my managers that they wish me to create a web UI for specified users to run queries / update the database; this is within my ability of PHP; but I was thinking for ease, I could make a proposition to scrap the need for the Web UI because this will cost a lot of time for our server administrators, but install SMSE on our network machines to connect to/manage our databases?

Is this possible? or would I have to go through the painful task of creating a WebUI which displays schemas, tables etc.

Aaron Bertrand
  • 181,950
  • 28
  • 405
  • 624
Daryl Gill
  • 185
  • 1
  • 1
  • 7

3 Answers3

10

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:

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

Community
  • 1
Aaron Bertrand
  • 181,950
  • 28
  • 405
  • 624
4

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

SQL Server Management Studio Express (Tools only)

bummi
  • 713
  • 1
  • 8
  • 16
2

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.

mrdenny
  • 27,106
  • 2
  • 44
  • 81