SCCM and SQL Installation Issues

Question

Hi

Currently looking at installing SCCM and SQL

the structure is that we will have the site server (SCCM Server) and we will have a separate SQL server from the SCCM server.

I have got all the firewalls configured but i keep getting the following errors and I'm currently stuck, I have changed the authentication to Windows and SQL authentication.

I have enabled Remote Connection

But I get these errors:

1. [A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)], Exception details: [System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified

Any ideas please help guys.

I would really appreciate the help.

Kind Regards,

Tom Gorgis

Answer 1

Hi,

These forums do not support the Business side products and services (except for Office).

TechNet is Official Microsoft Support for those and there will be MVP's and others knowledgeable to help.

(I am there as well). 

Rob - SpiritX

Answer 2

Would you have anyone in the MVP space that is specialised in SCCM and SQL that can support me through this.

It would be greatly appreciated.

Answer 3

Hi,

SQL Server, SCCM Server, and other Windows Server versions are supported via

TechNet so best to check with the Experts there.

TechNet - SQL Server

http://social.technet.microsoft.com/Forums/en/category/sqlserver

TechNet - SCCM Server

https://social.technet.microsoft.com/Forums/en-US/home?category=ConfigMgrCB

TechNet - Windows Server 

http://social.technet.microsoft.com/Forums/en/category/windowsserver

TechNet - Windows 10 IT Pro - Forums

https://social.technet.microsoft.com/Forums/windows/en-US/home?category=Windows10ITPro

TechNet - XP, Vista, Windows 7, and Windows 8/8.1 IT Pro 

http://social.technet.microsoft.com/Forums/en/category/w7itpro,w8itpro,windowsvistaitpro,windowsxpitpro,windowsintune

TechNet- Forums

http://social.technet.microsoft.com/Forums/en/categories/

TechNet - Where is the Forum For…?

http://social.technet.microsoft.com/Forums/en/whatforum/threads

Application development and programming - MSDN - SQL Server Forums.

MSDN - SQL Forums

http://social.msdn.microsoft.com/Forums/en/category/sqlserver

Hope this helps.

---

Rob Brown - Microsoft MVP <- profile - Windows and Devices for IT : Bicycle - Mark Twain said it right.