Error 11501: unable to connect to the database

[Tommy]

Hi,

I'm trying to setup a new SEPM and connect to my SQL database. During the process below, it not allowing me to proceed. 

Is there any steps I missed?

• SA password confirmed.
• SQL Server Client folder:C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn 

• both Windows Firewall is turn off.
• Ping test to SQL server is working fine. 

TCP/IP enabled

Manually insert the port number 1433 into TCP Port

running out of ideas.

Regards

[Igor Perevozchikov]

Hi Tommy!

Please check last comments in this discussion about similar problem
https://community.broadcom.com/symantecenterprise/viewthread?MessageKey=6691b44e-1c02-4fcd-bff9-244d4f8bd01c&CommunityKey=1ecf5f55-9545-44d6-b0f4-4e4a7f5f5e68&tab=digestviewer 

Also try to enable "Named pipes" for your SQL Server instance "SEPM" in SQL Server Configuration Manager.

Best regards,
IP.

[Tommy]

Hi Igor, 

After installed and run the PortQuery.exe. here is the results. 

[Torsten Knorr]

Just a try,

1. there are two MS SQL Server instances on the machine, did you have the correct port?
2. Can you please go to the bottom within the Protocols for SEPM => TCP/IP Properties and confirm that there is only 1433 and not 65### configured?

[Tommy]

Hi Torsten 

Yes, I have two instances running in a single SQL server. The DCS server and DCSSA instance is working fine. 

As for the SEPM instance, is newly added. Here are the content of the SEPM > TCP/IP

The TCP/IP:1433 was manually added by me.