creating a login

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?
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?
|||Thanks, that works for server logins, but what about database users?
"AndyP" wrote:
[vbcol=seagreen]
> 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:
|||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
"mkiger" wrote:
[vbcol=seagreen]
> Thanks, that works for server logins, but what about database users?
> "AndyP" wrote:

Created logins

They're under Security>Logins in Management Studio Object Explorer
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"robert salazar" <robert salazar@.discussions.microsoft.com> wrote in message
news:406F979C-5E66-48FA-BF8D-06ECF466F6ED@.microsoft.com...
> In sql 2000 the logins were displayed under "Security" In sql 2005 I
> sucessfully create the login but I cant find them?
> Where have they moved themI looked, there not. But the logins created succesfully
"Jasper Smith" wrote:

> They're under Security>Logins in Management Studio Object Explorer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "robert salazar" <robert salazar@.discussions.microsoft.com> wrote in messa
ge
> news:406F979C-5E66-48FA-BF8D-06ECF466F6ED@.microsoft.com...
>
>|||In sql 2000 the logins were displayed under "Security" In sql 2005 I
sucessfully create the login but I cant find them?
Where have they moved them|||They're under Security>Logins in Management Studio Object Explorer
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"robert salazar" <robert salazar@.discussions.microsoft.com> wrote in message
news:406F979C-5E66-48FA-BF8D-06ECF466F6ED@.microsoft.com...
> In sql 2000 the logins were displayed under "Security" In sql 2005 I
> sucessfully create the login but I cant find them?
> Where have they moved them|||I looked, there not. But the logins created succesfully
"Jasper Smith" wrote:

> They're under Security>Logins in Management Studio Object Explorer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "robert salazar" <robert salazar@.discussions.microsoft.com> wrote in messa
ge
> news:406F979C-5E66-48FA-BF8D-06ECF466F6ED@.microsoft.com...
>
>|||Did you refresh?
Hope this helps.
Dan Guzman
SQL Server MVP
"robert salazar" <robertsalazar@.discussions.microsoft.com> wrote in message
news:AE163B15-7538-41F4-AC25-48C377DBB76C@.microsoft.com...[vbcol=seagreen]
>I looked, there not. But the logins created succesfully
> "Jasper Smith" wrote:
>|||Did you refresh?
Hope this helps.
Dan Guzman
SQL Server MVP
"robert salazar" <robertsalazar@.discussions.microsoft.com> wrote in message
news:AE163B15-7538-41F4-AC25-48C377DBB76C@.microsoft.com...[vbcol=seagreen]
>I looked, there not. But the logins created succesfully
> "Jasper Smith" wrote:
>