Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rowter
Yak Posting Veteran
76 Posts |
 Posted - 2011-01-14 : 13:10:40
|
| Hi,When i tried to add a new user for the database i am having problems.Under security, I clicked a new user.What is login Name here?WHen i click on the button next to the text box, the Select Login window will open. Here when i hit on browse, i see several logins likeBUILTIN\Administrators, BUILTIN\Users, sa, MyPc\Me etc...Which one should i select here?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-14 : 13:27:52
|
| Create the login first. Then the database user.In fact, if you're doing it from the GUI, create the login, then move to the user mapping tab in the login screen, and check the boxes for the database(s) and role(s) you want to grant access for. |
 |
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2011-01-14 : 13:39:15
|
| Hi russell,Where do you create the login?I do ot see any option there for creating a login.I am using sql server 2005 express editionThanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-14 : 14:09:21
|
| In the object explorer, under the server, expand the security node. NOT the security node inside the database. |
|
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2011-01-14 : 14:38:58
|
| Found it. Thanks Rusell. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-14 : 14:42:52
|
| You're welcome. Glad to help :) |
|
|
|
|
|
|
|
|
Create a New User - Database