We help IT Professionals succeed at work.

Missing SQL instance

OleD
OleD asked
on
Hi.

On a SBS 2011 I haven't a instance name MSSQLSERVER under Services.
I have only SBSMONITORING and SHAREPOINT.
It's normal??

The SQL Server is 2008 R2

Best Regards
Comment
Watch Question

Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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.

Author

Commented:
Here is two screenshots from "Services" and "SQL Server Configuration Manager"
2015-03-03-140104.jpg
2015-03-03-140319.jpg
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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.

Cheers.

Author

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ãoIT Engineer
Distinguished Expert 2017

Commented:
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)."

Author

Commented:
Yes a little confused!!

Why did I get this error, running BPA?
2015-03-03-153637.jpg
2015-03-03-153310.jpg
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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.

Author

Commented:
Allright.
And I don't need a default instance?
IT Engineer
Distinguished Expert 2017
Commented:
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.