Error SCCM 2012 - Console don't open

[newadmsccm]

Hi guys,

 

I can't open my console SCCM. I don't change anything in my environment.

My checklists:

 

1.http://technet.microsoft.com/en-us/library/bb932213.aspx

2.Yes, I can logon in my Database in Database Management Studio

3.Permissons are OK;

4.I can ping,tracert etc between my server SCCM and server DatabaseSccm;

5. Yes, I ran AdminConsole.msi;

 

Open log smsadminui.log display following error:

*** [08001][11001][Microsoft]

A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

 

So, can you help me please? Thanks.

[newadmsccm]

So, I see smsprov.log and display following error:

 

*~*~[HYT00][0][Microsoft]

Login timeout expired   [08001][11001][Microsoft][sql Server Native Client 11.0]TCP Provider: No such host is known.~~  ThreadID : 764 , DbError: 0 , Sev: 0~*~*

 

*** [08001][11001][Microsoft][sql Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

 

*~*~[08001][11001][Microsoft][sql Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [HYT00][0][Microsoft][sql Server Native Client 11.0]Login timeout expired ThreadID : 764 , DbError: 11001 , Sev: 0~*~*

 

*** Failed to connect to the SQL Server, connection type: SMS ACCESS.

 

So, my server DBSCCM is on.

 

Please guys, I looking for this error in internet but I don't find cause root my problem.

[newadmsccm]

Please anyone idea ?

 

I read this link: http://www.windows-noob.com/forums/index.php?/topic/8811-unable-to-connect-to-sccmsql-site-database/

 

But I don't change anything, so this link no help me.

 

I have verified in SQL that named pipes and TCP/IP are enabled.

 

Anothers tests: http://blogs.technet.com/b/sudheesn/archive/2009/07/16/unable-to-open-the-sccm-console.aspx

http://www.windows-noob.com/forums/index.php?/topic/9409-cant-connect-to-configmgr-2012-sp1-r2-console/

 

No sucess.

[Edenost]

On the SCCM server it self, does the console open?

If not, when you installed SQL, did you change the default name of the Database from "MSSQLSERVER"? I only ask because in my experience, when I changed this I had problems connecting to SCCM after it. But to be honest, my problems appeared when I actually came to install SCCM.

 

Also, have you configured your firewall rules?

 

One of the errors you show is a TCP Error: "TCP Provided. No such host is known".

 

Check this link, it might give you a few pointers:

https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

[newadmsccm]

Thanks your opinion Edenost.

 

Well, my console don't open in my server SCCM or other desktop have installed console SCCM.

About second question, really I don't remember, but I installed best practices Microsoft and my SCCM ran last months normally.[

My firewall is disable 3 options (domain,public...).

I will check this link.

I read this probably error DNS, I'm check this too.

 

Thanks.