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.