Adding a new user to 2005 Express Edition

• David Weld

  SSC Enthusiast

  Points: 110

  More actions

  May 30, 2006 at 3:10 pm

  #113821

  Hi. We're developing a .NET application that makes use of a SQL Server 2005 Express Edition database. We're using Windows authentication, but so far we've had only one user (me!) The question is: How do I add a new user?

  In the field, we will run the front-end application and the database back end together on the same Windows XP machine, but we plan on allowing different users to log on separately. For example, the "Administrator" will log on with full administrative privileges and be able to configure the application, whereas the "Operator" will log on as a Power User and be able to carry out only limited tasks. Both, however, will need to hit the database.

  (I'm using the SQL Server Management Studio Express for database configuration.)

  Thanks much.

  Dave

• Salvador Manzo

  SSC Enthusiast

  Points: 101

  More actions

  May 31, 2006 at 10:39 am

  #641002

  Security : Logins : Add New Login

  Then assign the login permissions to a database either via it's properties or by going to the database and setting it there. That's the GUI way , at least. (login = user OR group, by the way)

• David Weld

  SSC Enthusiast

  Points: 110

  More actions

  May 31, 2006 at 11:00 am

  #641006

  I see. Thanks.

  (I ended up adding the "Operator" to the "\SQLServer2005MSSQLUser$$SQLEXPRESS" group which appears in my list of logins, all of which were apparently installed during the installation of SQL Server. This did the trick.)