I was installing SCOM ACS 2012 R2 and configuring it to use SQL authentication. This is not to collect events from an untrusted domain, I was just implementing redundant ACS collectors as described here which would require the collectors to use SQL authentication to connect to the backend database.
ACS setup completed successfully on all ACS collector servers, but the Audit Collection Services shuts down shortly after starting and logs this event
Error occured on database connection:
Status: 0x04080000
ODBC Error: 15151
ODBC State: 42000
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user 'AdtServer', because it does not exist or you do not have permission.
Database: SqlWriter
Connection: Maintenance
Statement:
/**********************************************************
The reason this happened was because I precreated the SQL account and gave it dbcreator role then supplied it to the ACS setup. I then discovered that the ACS installer would actually create the account itself, surprisingly it did not complain that the account already existed and completed successfully but apparently something was still broken.
I uninstalled ACS, deleted the SQL account then reinstalled ACS and now it works.
ACS setup completed successfully on all ACS collector servers, but the Audit Collection Services shuts down shortly after starting and logs this event
Error occured on database connection:
Status: 0x04080000
ODBC Error: 15151
ODBC State: 42000
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user 'AdtServer', because it does not exist or you do not have permission.
Database: SqlWriter
Connection: Maintenance
Statement:
/**********************************************************
The reason this happened was because I precreated the SQL account and gave it dbcreator role then supplied it to the ACS setup. I then discovered that the ACS installer would actually create the account itself, surprisingly it did not complain that the account already existed and completed successfully but apparently something was still broken.
I uninstalled ACS, deleted the SQL account then reinstalled ACS and now it works.
go to Cheapest Windows and Office Product Key Sale. i must thank them! my office 2013 pro plus just activated n worked well,
ReplyDeletethey do provide the warmest customer service i ever met.
because of employees like here, i will refer everyone to this site
go to Cheapest Windows and Office Product Key Sale. i must thank them! my office 2013 pro plus just activated n worked well,
ReplyDeletethey do provide the warmest customer service i ever met.
because of employees like here, i will refer everyone to this site
It's like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a little bit, but instead of that, this is great blog. A great read. I will certainly be back. Visit this site right here: Here’s How To Password Protect Folder Like A Professional
ReplyDeleteACS setup completed successfully on all ACS collector servers, but the Audit Collection Services shuts down shortly after starting and logs this event
ReplyDeletebulk shirts online
bulk t shirts printing wholesale