troubleshooting Question

Reset MSSQL sa password

Avatar of garychu
garychu asked on
Microsoft SQL Server 2008Statistical Analysis System (SAS)
5 Comments1 Solution14052 ViewsLast Modified:
A server computer comes with Windows SBS 2011 Std pre-installed.
Out of the box, an instance of MSSQL 2008 R2 (Express Edition with advanced services) is also pre-installed to manage SBSMonitoring. Installation is apparently in mixed mode.

I am able to access via Server Management Studio, using a Windows logon (domain-admins).
However, access is very limited. An sa SQL logon seems to be needed.
But I have no way of knowing the sa SQL logon password.

I tried re-setting the sa password (while connected using the Windows logon).
Unsurprisingly, it failed with the following message;

"Cannot alter the login 'sa', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 15151)"

Nor could I add a new logon and give it a sysadmin role.

Given this situation, would an Expert be kind enough to provide some help.
I recall vaguely that this may be achieved via SQLCMD .
But I hesitate to try without some expert guidance.

Thanks
ASKER CERTIFIED SOLUTION
Peter Chan
System consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros