Create new user 4

[JSMITH242B]

How do I create a new user within a database?

When I try saving the new user I'm trying to add I get the following:

Error 15007: The login <new user login> does not exist.

TIA

 

[gmmastros]

Create the login. Here's how.

Open Enterprise Manager
Drill down to server
click on Security
Click on Logins
Right Click Logins
Click New Login

Give it a name.
Got to the 'Database Access' tab and select the database that the login in permitted for.

Click OK


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[JohnBates]

First, create the Login (under the Security folder in Enterprise Manager). Then you can add the user to a database.

John

 

[SQLDenis]

T-SQl example

EXEC sp_addlogin 'Username', 'PassWord', 'DefaultDBName'
EXEC sp_adduser 'UserName'

example

EXEC sp_addlogin 'Albert', 'food', 'pubs'
EXEC sp_adduser 'Albert'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[JSMITH242B]

Thanks Guys!!

 

[Catadmin]

I've been able to add new users to databases if they are a part of a Windows Group that's been mapped to a SQL login. The easiest way to check who is on the groups you have mapped to SQL Server is to open a command window and, at the prompt, type:

net group <groupName> /domain

Just insert your group where it says <groupName> and type the rest as it is. It'll give you a list of the users in that group and you never have to worry about asking the network people who is a member of what group.

Catadmin

Catadmin - MCDBA, MCSA
"The only stupid question is the one you *didn't* ask.