chenge pass word sa | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
chenge pass word sahi i have a problem about 3 months ago till now sometimes change sa password automatically and i can not open my some software that related to sql i dont know t how is happen and who do this in my network in my company thanks a lot PLEASE guide me Best Regards O.MOLLAZADEH* mailto: email@example.com WEB: http://www.niroutrans.com
Welcome to the forums!.
Are you DBA for your company?
I mean, are you the only guy who must know sa password?
BTW: Why you post in Log Shipping forum?
Welcome to the forums.
Can you connect to that SQL Server using any other login or your own loging which has SYSADMIN privileges. If so you can simply change the SA password again to desired value to function your application.
why don’t you use Windows Authenticaiton mode in order to change sa password? And Also i think yo should not use sa user in your applicaitons.