chenge pass word sa | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

chenge pass word sa

hi 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: mollazadeh@niroutrans.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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |