Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Query to change SQL server agent authentication

Author  Topic  mikep Starting Member 3 Posts Posted - 2005-10-07 : 16:52:33 IS there a query to change the authentication from default windows authentication to SQL? as well as set a password to that authentication through?? If not, im using an unattended install to install sql for me. Is there a way to make the .iss file preset these settings? If i can do it through a query I can script it into my unattended install... Thanks, Mike