Re: sql2k5/w2k3 Changing sql login password?

zz12
You can generate simple script for user like ALTER LOGIN .. WITH
PASSWORD=.....
I'm not aware of any tools , but do a search on internet



"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:e2SfeOFaIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
Hello, is there a tool, utility or an easy method in allowing users to
change their sql login passwords from upgrading our sql2k to now sql2k5?
It seems great that sql2k5 can now utilize the w2k3 (that we have it
running on) password policies to enforce the sql login's I believe but
were wondering how the users can do this if their machine's are on
different operating systems (Windows XP, Windows 2000, etc...). Mainly
they use MS Access table links through odbc to our now sql2k5 database
server but doesn't seem like they can do it on their own from there end.
Would like creating a small intranet/web interface and point them to it
that allows them to login and change their sql passwords be the way? Was
kind of hoping that w2k3/sql2k5 in working together would or could somehow
push out a popup on their end to do this?

Thanks in advance.



.

Relevant Pages

  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: How to restrict access our DB on SQL server.
    ... Don't give out the passwords and they won't be able to login. ... Andrew J. Kelly SQL MVP ... Excel & even Enterprise manager? ...
    (microsoft.public.sqlserver.tools)
  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • RE: Getting Challenged when using SQL connection on .aspx page
    ... What would happen if i removed integrated security=sspi from the connection ... Just want the login token to be passed, ... Have webpage with following connection in the ... I have account to the database on the SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)