Post reply

Adding a new user to 2005 Express Edition

  • 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

  • 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)

  • 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.)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply