"Chris Marsh" <cmarsh@synergy-intl.com> wrote in message
news:%2345isUhEEHA.3872@tk2msftngp13.phx.gbl...
> I am getting error 15007 when trying to create 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
>
>

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:uyxasLiEEHA.3576@TK2MSFTNGP12.phx.gbl...
> Before you add a user to a database, you need to first add the login. For
> example:
>
> --SQL authentication
> EXEC sp_addlogin 'MyLogin', 'Mypassword'
> USE MyDatabase
> EXEC sp_adduser 'MyLogin'
>
> --Windows authentication
> EXEC sp_grantlogin 'MyDomain\Mylogin'
> USE MyDatabase
> EXEC sp_grantdbaccess 'MyDomain\Mylogin'
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Chris Marsh" <cmarsh@synergy-intl.com> wrote in message
> news:%2345isUhEEHA.3872@tk2msftngp13.phx.gbl...
> > I am getting error 15007 when trying to create 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
> >
> >
>
>