can a non-administrator user run the SQL Server Management Studio Express ?

If i install the SQL Server Express and the Management Studio in my computer with an administrator account... can a non-administrator user run the SQL Server Management Studio Express ?

When the non-administrator user tries run the SSEMS, he gets an error, something like "Cannot load the SQL Management Studio Package".

Can i set several permissions to let non-administrator users run the SSEMS ?

Hi Jamie,

Any user can run Managment Studio Express, but you need permissions to use SQL Express. By default, only members of the Administrators group have permissions to do any tasks in SQL Express. For non-administrative users, you will need to explicitely create Logins and Users in SQL Server for those users. You can only create Logins and Users when you are an SA, so you'll need to log in as an adminstrator and setup the appropriate permissions.

I'd recommend you read the Books Online topics related to security.

Mike