We help IT Professionals succeed at work.

sa password,

romari
romari asked
on
868 Views
Last Modified: 2008-07-23
The system administrator who installed the SQL has left, and now we can't access teh SQL server, how can I resert/chagne the sa password? and will this affect the current operation of the applications who has databases on that SQL server?

Thanks for any help,
Comment
Watch Question

Development Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Muhammad KashifDevelopment Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
So how can I solve this problem? I need to change the password but I still want the applications to work? how should this problem be addressed?

Thanks,
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Awarded 2008
Awarded 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Isn't there a tool to show the SQL password?

Thanks,
Muhammad KashifDevelopment Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Muhammad KashifDevelopment Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.