creating a login

16 Mar 2006 6:55 PM

mkiger

Is there a way to create a login and password, or change a login's password
in management studio (sql 2005) without using a sql script? Any wizard or
dialog box?

16 Mar 2006 6:59 PM

AndyP

In the Management Studio, open the Object Explorer and expand your Server,
then Security, then Logins and right-click on the login you want to change. A
dialog box will open and you can change the password in there, near the top.
Type in the password in the Password box, and the same password again in the
Confirm Password box.

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

Show quoteHide quote

"mkiger" wrote:

> Is there a way to create a login and password, or change a login's password
> in management studio (sql 2005) without using a sql script? Any wizard or
> dialog box?

16 Mar 2006 7:07 PM

mkiger

Thanks, that works for server logins, but what about database users?

Show quoteHide quote

"AndyP" wrote:

> In the Management Studio, open the Object Explorer and expand your Server,
> then Security, then Logins and right-click on the login you want to change. A
> dialog box will open and you can change the password in there, near the top.
> Type in the password in the Password box, and the same password again in the
> Confirm Password box.
>
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
>
> "mkiger" wrote:
>
> > Is there a way to create a login and password, or change a login's password
> > in management studio (sql 2005) without using a sql script? Any wizard or
> > dialog box?

16 Mar 2006 9:30 PM

AndyP

You can go to the database, then Security, then Users, and add/remove the
users to/from the database and affect their overall database access that way.
You can then grant or revoke permissions at that level. The database user
does not have a password property, but is linked to a login which does have a
password.

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

Show quoteHide quote

"mkiger" wrote:

> Thanks, that works for server logins, but what about database users?
>
> "AndyP" wrote:
>
> > In the Management Studio, open the Object Explorer and expand your Server,
> > then Security, then Logins and right-click on the login you want to change. A
> > dialog box will open and you can change the password in there, near the top.
> > Type in the password in the Password box, and the same password again in the
> > Confirm Password box.
> >
> >
> > --
> > AndyP,
> > Sr. Database Administrator,
> > MCDBA 2003
> >
> >
> > "mkiger" wrote:
> >
> > > Is there a way to create a login and password, or change a login's password
> > > in management studio (sql 2005) without using a sql script? Any wizard or
> > > dialog box?