I can backup my logins but without passwords....using SQL 2005 , generate sql scripts...
any idea i can generate a SQL script with the passwords in cleartext i like to recreate them in my test database later.
backuping logins + passwords.
Hot Topic
SQL Server
- render page by month
- Altering (or recreating) a Stored Procedure "header"
- SmoApplication.EnumAvailableSqlServers does not list default instance if sqlexpress is in same machine
- Database Administration/Maintenance - Guidance Needed
- what hte use of SQL Native Client??
- Search with %t%y% => Error, %ty% => ok...
- JuneCTP Install Issue: WMI 0x80040154
- Wait for Recieve Fails to recieve message when called from .Net sqlClient
- xmla files
- SQL Mobile Server Tools
backuping logins + passwords.
Amy Greenwood
As MSSQL 2005 doesn't store passwords (it stores only password hashes), there is no way to get them in clear text. If you want to back up your logins, you should backup master database; if you want to thransfer them to another server, you should use the DTS "Transfer Login Task" (just don't know analogue in MSSQL 2005 SSIS, it is possible that task didn't change the name).
Anyway, maybe it would be useful : http://search.microsoft.com/results.aspx q=Transfer+Logins+and+Passwords+Between+Instances+of+SQL+Server&l=1&mkt=en-US&FORM=QBME1