Missing SQL instance


On a SBS 2011 I haven't a instance name MSSQLSERVER under Services.
It's normal??

The SQL Server is 2008 R2

Best Regards
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Vitor MontalvãoMSSQL Senior EngineerCommented:
MSSQLSERVER should be the default instance so I'll say that can be normal but is better you post a screen shot so we can confirm that.
OleDAuthor Commented:
Here is two screenshots from "Services" and "SQL Server Configuration Manager"
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, really those screen shots. So, that means you don't have a default instance installed but two named instances.
Isn't a problem at all.

You may want to change the SQL Service account. Local System is not a good idea. I wrote an article about that on the last month. Please give a read.

10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

OleDAuthor Commented:
I was thinking about default DB.  
I have seen lot of reference when I read about SQL Server.
Ex. In Microsoft Baseline Configuration Analyzer 2.0 Enter Parameters screen, you need to specify the SQL Server Instance Name, for a default instance you need to specify the instance name as MSSQLSERVER.

Thanks for article!
Which user is normal the best for SQL Server on SBS2011 Standard?

Best Regards
Vitor MontalvãoMSSQL Senior EngineerCommented:
I think you are confusing default DB with default instance.
Default DB is a property for the logins and default instance is a SQL Server non-named instance that you can have only one per server.

Which user is normal the best for SQL Server on SBS2011 Standard?
A dedicated domain account if you are working with clustered instances. Otherwise:
"If you are running SQL Server 2012 or superior version in a stand-alone machine then use a Managed Service account (MSA) or a Virtual Service account (VSA) to simplify service management, depending on whether resources external to the SQL Server computer are needed (use MSA) or not (use VSA)."
OleDAuthor Commented:
Yes a little confused!!

Why did I get this error, running BPA?
Vitor MontalvãoMSSQL Senior EngineerCommented:
That error message just prove that you don't have a default instance installed.
You or someone provided the MSSQLSERVER instance and that's why BPA returned the error. Try to run it again with providing MSSQLSERVER.
OleDAuthor Commented:
And I don't need a default instance?
Vitor MontalvãoMSSQL Senior EngineerCommented:
No. It's not a demand.
I personally think that for security reasons the default instance shouldn't be installed as the default port should be changed so avoids the basic attacks on default installations.

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
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 2008

From novice to tech pro — start learning today.