SQL Server 2005 password

We have a version of SQL Server 2005 Standard that came as the back end of law practice management software (Amicus). The person who assisted Amicus in the installation has "misplaced" the SQL administrator username and password. We want to use Crystal Reports to access our data. Is there any way to crack or reset the SQL Server administrator username and password?
techresultsOwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee SavidgeCommented:
If you can login using Windows Authentication then exec sp_password nul, null, 'sa' will blank the sa password.

Lee

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sammySeltzerCommented:
This approach
You could use SQL Server Management Studio, connect with
windows-Authorization to the server/instance, then under Security/Logins (,you can right-click
on "sa", select "properties" and then you can change the password.

or this approach:

1) USE [master]
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'blah' MUST_CHANGE
GO

2) From a command shell (start > run > cmd)
    OSQL -S <YOUR_SERVERNAME_GOES_HERE> -E
    1> EXEC sp_password NULL, 'blah', 'sa'
    2> GO
should work
BrandonGalderisiCommented:
By default the Local Built-In Administrators group has local admin permissions.  So you would just need to login using Windows Authentication as an account that has local admin permissions.

If that group has been removed, you can start SQL Server via the command line in single user mode which should allow the admin group back in.
lomo74Commented:
open command prompt on your server, then:
osql.exe -E -Q"sp_password NULL, 'newpassword', 'sa'"
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.