Re: SSMS to Administer Express - Licence Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Brendon,

SQL Server 2005 Express Edition is a free of charge version of SQL Server 2005.

So yes, you can administer this instance of SQL Server using SQL Server Management Studio or SQL Server Management Studio Express legally.

There is no a limitation of administering SQL Server instances using SSMS\SSMSE. However, SSMS should be installed on a computer that has a valid SQL Server license.

--
Ekrem Önsoy



"Brendon" <brendon@xxxxxxxxxxxxxxxxxx> wrote in message news:71201E34-D75F-45D7-82B1-419D24273C3D@xxxxxxxxxxxxxxxx
Assuming I have 5 per server licences for SQL 2005 Standard Edition servers and I had and 50 clients with SQL CALs I believe I can install SQL Server Management Studio on any of these 50 client PCs to administer any of the 5 SQL 2005 Standard Edition servers.

If I then install SQL Server 2005 Express on a new server am I legally allowed to administer this new server with SSMS?

Thanks in advance

Brendon

.

Relevant Pages

  • Re: Windows Authentication, Which Accounts? (newbie)
    ... sysadmin rights. ... login.Also make sure the SQL Service account (and SQL Agent Service account ... Jasper Smith (SQL Server MVP) ... When I say administer I mean use the SQL Server Enterprize Manger. ...
    (microsoft.public.sqlserver.security)
  • VS2005 + SQL 2005 Beta2
    ... Edition habe ich SQL Server 2005 Developer Edition von der zweiten DVD ... Jetzt wollte ich über "Administer Webpage" Einstellungen vornehmen, ... Next by Date: ...
    (microsoft.public.de.german.entwickler.dotnet.asp)
  • Re: What is Logon Process Name:DCOMSCM
    ... DCOMSCM - The COM-component, is used to manage / administer an SQL Server ... dcomscm - The dcomscm utility is ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Is UserLevel Security Really Necessary?
    ... the server DBs have better security. ... easy to learn and administer. ... Please note that you can get Microsoft SQL Server 2005 Express Edition ... as a free download from Microsoft. ...
    (comp.databases.ms-access)
  • Re: How to configuring SQL 2K & connect to it.
    ... After the installtion of SQL server, You can use the user friendly utility ... Enterprise manager to administer the ... Assign the required role the login created. ... Once you create the Login and database you can use the other utility named ...
    (microsoft.public.sqlserver.connect)