An error occurred during the pool backend detection: Pool backend discovery failed. Failed to start SQL service or invalid SQL instance (Solved)

)Issue

When you try to create an enterprise pool by using the Microsoft Lync Server 2010 or Microsoft Office Communications Server deployment wizard, you receive the following error message:

"An error occurred during the pool backend detection

Pool backend discovery failed

Failed to start SQL service or invalid SQL instance.

This can happen due to network or credential problems. Please make sure networks is good and logon has sufficient permissions."

Solution

·         Task 1

In the FE  configuration wizard ,in SQL Server instance box try to use FQDN rather than its netbios name

Eg: MYSQLSERVER.mydomain.com\OCSINSTANCE

If OCS is using default instance do the change accordingly

·         Task-2

Check the DNS in the AD whether OCS Pool name is added or not

·         Task 3

Check the windows firewall is configured properly so that it wont stop any communication between OCS front end server and SQL backend servers .Preferably stop the firewall and check first , if it is working fine then try to add the relevant rules for security standpoint

·         Task 4

Check whether SQL server, SQL browser and SQL agent services are running in the SQL server. If this is a freshly installed SQL server, try to open the SQL management studio and connect to the SQL DB to check it is working fine.

·         Task 4

Install the latest service pack for the installed SQL version and reboot the server

·         Task 5

Check whether the user is having sufficient privilege  in both SQL and OCS (for OCS the user must be a member of  RTCUniversalServerAdmins group) and in SQL user preferably should be in sysadmin group (I am not sure whether any other privilege is sufficient or not )

·         Task -6

Check whether the SQL server is configured to accept remote connections.

o    Click Start, Programs, Microsoft SQL Server 2005/2008 and select SQL Server Configuration Manager.

o    Select “SQL Server Network Configuration “

o    Double click on “Protocols for SQLEXPRESS”

o    Check whether TCP/IP is enabled or not, if not enabled and select Yes to enable it .

o    In the next tab “ IP address “,check whether the port number is same for all the TCP port field, (default port is 1433) and change accordingly ,for me it is 1433 itself for all .

o    Check whether IP address of the SQLserver is added into the IP address field under IPA2 heading.

o    Restart the SQL server services from services.msc and

·         Task -7

Click “Retry “option in the FE server.