creating new user login - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

creating new user login

Author

Topic

slimjen
Yak Posting Veteran

61 Posts

Posted - 2006-07-05 : 16:17:27

I am just learning Sql 2000. I need to give access specific databases on a server to new users. When I right click on the database to create a new users,in Enterprise manager, only the server I am on shows up. The new users are not yet in the server. The dropdown doesn't give me access to browse to a company server that users are on. Am I missing something? How can I give users access when I can't find the company server or how to choose a user on the network. Please help
Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-05 : 16:23:25

Do you mean for windows authentication?

They should know their login id...just ask them then add them.

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-05 : 16:26:47

For Windows Authentication, specify DomainName\UserName. You can also click on the ... in Enterprise Manager to navigate to it.

Tara Kizer
aka tduggan

slimjen
Yak Posting Veteran

61 Posts

Posted - 2006-07-05 : 16:30:06

No, I don't think so. I am trying to add users or grant them access to a database on a sql server. I can't find a drop down to select the user. No users appear only administrator etc.

slimjen
Yak Posting Veteran

61 Posts

Posted - 2006-07-05 : 16:32:26

tkizer. I don't understand what you are trying to tell me. Where do I go in Enterprise manager. I clicked on the database and right clicked to new user.

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-05 : 16:32:33

Are we talking about mixed mode or sql server only security?

If it's sql server only, you need to add them as logins first....

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

EDIT: And Tara I did not know that....of course it takes forever when you have 10's of thousands of logins...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-05 : 16:42:27

quote:
Originally posted by slimjen

tkizer. I don't understand what you are trying to tell me. Where do I go in Enterprise manager. I clicked on the database and right clicked to new user.

You need to add a login first. Go to Security then Logins once you connect to the server. After you add the login, you can then add this user to the database.

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources