SQL Server 2008 management tools

Question

question

ggoble asked Nov 11, '09

SQL Server 2008 management tools

Do you think it acceptable to point Business Analysts that need to use sql 2008 management tools to the management tools express download at http://www.microsoft.com/express/sql/download/ rather than give them the full iso for developer edition?

Thanks

sql-server-2008 ssms

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2009-11-11T18:48:52Z

Matt Whitfield answered Nov 11, '09

I think it entirely necessary, for two reasons:

Developer edition isn't free. Therefore you shouldn't be handing it out.
The Business Analyist use-case isn't covered by the license for developer edition - because developer edition is only for developers. You could argue that the license is really bothered about the database engine itself, rather than the management tools, but the law rarely has any sort of common sense to it.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2009-11-12T10:01:00Z

David 1 answered Nov 12, '09

If the BA's use of a (non-Express) server is properly licensed then he/she is entitled to use the full Management Studio product. So no need to use Express. As Matt says, the BA may not be covered by a Dev licence unless their role is purely development.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2009-11-12T11:46:00Z

Fatherjack answered Nov 12, '09

Absolutely, but they could use the tools from any install. We use the Developer iso to install management tools on lots of MI computers. Its the server where the data is maintained that needs the correct license.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question