Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 10 Jun 2010 4:49 PM
  • Last revision by (fMicrosoft Partne)
  • When: 15 Sep 2013 9:40 PM
  • Revisions: 6
  • Comments: 1
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Create a User for SQL Server 2008 Express Edition

Create a User for SQL Server 2008 Express Edition

Create a User for SQL Server 2008 Express Edition

How to set a user to access on a db:

  1. Open Management Studio
  2. Go on properties of the server ex: SRV-2008\SQLEXPRESS
  3. Select mixed mode (SQL Server and Windows Authentication). Click OK.
  4. Always in Studio Management, add a new connexion ( unroll security)
  5. In general, enter a name for the account and click on "SQL Server authentication". Enter a password and uncheck "Keep the password policy".
  6. Assign roles.

You can now use this user in a connection string or in credentials to remote a instance SQL.

, , [Edit tags]
Leave a Comment
  • Please add 2 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (1 items)