Endpoint Protection

Hi I'm using Win server 2003 and encounter issue when configuring SEPM. For DR purpose, i've try to uninstall my SEPM and reinstall back, but now i encounter issue of configuring part.

Once i key in the database parameter at below screen:-

I will encounter error as below.

I have no idea what to do. 

please let me know which database you are using( SQL or embedded)

is the port 1381 the SQL listening on?

I'm using SQL, and my telnet is went through.

however is it the SQL application port?

is SQL on remote machine?

if yes, can you use SQL client to connect to SQL server?

Hi Pete,

Yes it is. And the SQL is a remote machine and i've tried to use SQL Client to connect and its TEST Successful.

I have 3 more server which using the same SQL which functioning without any issue.

can you check if the firewall is blocking the connection?

also can you use SQL authentication? or have you used windows authentication on the other servers as well?

Hi Pete,

The firewall have no issue. I even tried after i disable all firewall. and for the SQL Authentication, i suppose to use Windows authentication. This is similar like how i use in other servers.

If i still try with SQL Authentication, i will get below error:-

This error clearly show that my authentication is wrong. I've logged in to SQL server to check my Database name, and its all correct.

One thing i notice while browsing for solution, some ask me to check SEMSRV service. This not available in this newly installed PC after uninstall, but i notice i have the option in other servers.

do you see repair in the add/remove program for SEPM? if yes, can you repair?

Hi Pete,

Just done the repair and also full installation. Still same. I'm not sure what else actually cause it.

I'd recommend checking the SQL logs for more information.  These would give you a better description of why the SEPM is failing to connect.

If you don't see any logs for connections from the SEPM server, then the check out the SQL Server Configuration Manager for the correct instance details and verify you are entering the same into the SEPM.

If the SEPM is connecting, but failing in some other way, the log will say why.