Error 15007 when trying to add a new user

Why? This is a silly error, I know the user doesn't because I am trying to
add them but this is the error I get when trying to add any user to the
database. What the heck am I doing wrong?
Thanks in advance!
Chris> Why? This is a silly error, I know the user doesn't because I am
> trying to add them but this is the error I get when trying to add any
> user to the database. What the heck am I doing wrong?
Go to Security\Logins in EM and add a _login_ that maps to a user in the
database.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
It seems you are trying to add a database user with out creating Login.
What is a SQL server Login:
An account that gives a user permission to connect to SQL Server 2000
What is a SQLserver User
SQL Server security account that is specific to access the database.
So to access a database , we need to authenticate to SQL server using a
Login and to access the database you need to create a Use.
* Login - For Server level
* User - Database Level
So to overcome this first you craete the login and then create the user
assocoated to the login
sp_addlogin 'login_name','password'
go
use <database name>
go
sp_adduser 'user_name','login name create in the above step'
Thanks
Hari
MCDBA
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:#GkSOUhEEHA.4084@.TK2MSFTNGP11.phx.gbl...
> Why? This is a silly error, I know the user doesn't because I am trying
to
> add them but this is the error I get when trying to add any user to the
> database. What the heck am I doing wrong?
> Thanks in advance!
> Chris
>|||Thank you - I will give it a try. I'm learning
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uwVvQrkEEHA.580@.TK2MSFTNGP11.phx.gbl...
> Hi,
> It seems you are trying to add a database user with out creating Login.
> What is a SQL server Login:
> An account that gives a user permission to connect to SQL Server 2000
> What is a SQLserver User
> SQL Server security account that is specific to access the database.
> So to access a database , we need to authenticate to SQL server using a
> Login and to access the database you need to create a Use.
> * Login - For Server level
> * User - Database Level
> So to overcome this first you craete the login and then create the user
> assocoated to the login
> sp_addlogin 'login_name','password'
> go
> use <database name>
> go
> sp_adduser 'user_name','login name create in the above step'
> Thanks
> Hari
> MCDBA
>
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:#GkSOUhEEHA.4084@.TK2MSFTNGP11.phx.gbl...
> to
>|||thank you!
"Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
in message news:eBl48FkEEHA.624@.TK2MSFTNGP10.phx.gbl...
> Go to Security\Logins in EM and add a _login_ that maps to a user in the
> database.
> sincerely,
> --
> Sebastian K. Zaklada
> Skilled Software
> http://www.skilledsoftware.com
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>sql