cancel
Showing results for 
Search instead for 
Did you mean: 
shobud
Level 7
Report Inappropriate Content
Message 1 of 4

Problem with database server name change

Hi All,
Since we have renamed our database server (same IP though) we have been getting these errors in the Application log:

18456 :
Login failed for user '<DOMAIN>\EPO$'.
Source: MSSQLSERVER

So it looks like the epo server computer account is trying to log into SQL Server.
Everything else seems to be working normally though.

These errors are being logged every few seconds and of course filling up the app log on our SQL Server box!
Has anyone seen this behavior?

Dan
3 Replies
Highlighted
jokerv
Level 7
Report Inappropriate Content
Message 2 of 4

RE: Problem with database server name change

Please check if this account have DBO permission on ePo database or not locked in Active Directory.

Why you using server account btw?

I'd created local user on SQL, gave all necessary permisions on DB and configure on ePO side (http://server:8443/core/config)
shobud
Level 7
Report Inappropriate Content
Message 3 of 4

RE: Problem with database server name change

Hi,
Thanks for your reply!
I should have added more detail.

We're not using the computer account, we use a domain account to access the db and that's still working fine.
This only started happening when we changed the name of the DB server.

We're not using the epo server account for anything, it just started trying to connect on it's own! We're trying to figure out why the account would start doing this. It's filling the app log on the DB server because it's trying to connect every few seconds and failing.

epo version: 3.6.0.595

Dan
jokerv
Level 7
Report Inappropriate Content
Message 4 of 4

RE: Problem with database server name change

I can't help with this particularly issue, however please keep in mind that old ePo and SQL have huge performance issues, because of way how ePo app and MS SQL handle connections.

I had migrate db from 2000 to 2005 and number of opened connection between App and DB drop from 245 (maximum number for Tomcat that shipped with ePo 4) to 5-7.

on other thought please check permissions for this ePo AD account on DB and on OS level.
Member Rewards
McAfee Community rewards active and helpful members just like you. Click here to take a look at the first community members who received a special reward and were recognized by McAfee leader, Aneel Jaeel, for their participation and trusted knowledge in the community.