Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers 3

up vote 7 down vote accepted

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

Just download SQLManagementStudio_x64_ENU.exe or, if you are unfortunate enough to be on a 32-bit operating system, SQLManagementStudio_x86_ENU.exe. The download is quite large (almost 1 GB). There is no shortcut.

share|improve this answer
add comment

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

SQL Server Management Studio Express (Tools only)

share|improve this answer
    
So this is possible to connect to a SQL Server using SMSE on a machine which has no services? –  Daryl Gill Feb 5 '13 at 19:56
    
@Daryl yes, you can install Management Studio (or Management Studio Express) on a machine that doesn't have a SQL Server Engine. Just choose Management Tools - Complete and Management Tools - Basic during setup. –  Aaron Bertrand Feb 5 '13 at 23:11
    
An even better link would be SQL Server 2012 Service Pack 1 Express - since this version of Management Studio Express is the first one that doesn't have any limitations (basically full parity with the proper editions). –  Aaron Bertrand Feb 5 '13 at 23:13
add comment

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.

share|improve this answer
add comment

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.