	Site Search:
Home Products Products Overview adTempus Report Commander Arcana Scheduler Support Support Home Knowledge Base License Management Contact Support Community Purchase Pricing and Ordering Additional Purchasing Information Contact About Us

Knowledge Base

adTempus fails to start when connecting to a remote SQL Server database that does not have SQL Server (password) security enabled

Programs Affected:

adTempus

Article ID: K00000217
Last Reviewed: 19 April 2005

Symptoms

The adTempus service fails to start as described in article K00000222. The adTempus diagnostic log contains a line with the following error message:

Error -2147467259: Login failed for user 'adtempus_XXX'. Reason: Not associated with a trusted SQL Server connection. (source=Microsoft OLE DB Provider for SQL Server; native error=18452; SQL state=42000)

Cause

adTempus is trying to connect to the SQL Server database using SQL Server (password) security, but SQL Server security has not been enabled on the database server.

Resolution

To resolve this issue you must either enable enable SQL Server (password) security for SQL Server, or change the adTempus service to run under a user account and use integrated (Windows) security. See the "Security Setup" section of the Using SQL Server topic in the adTempus online help for more information.

Was this article helpful?
[more information]
Yes
No
Did not apply
Comments:

Information on this page and the Arcana Development software to which it refers is provided "as is" and without warranties as to performance or merchantability or any other warranties whether express or implied. Because of the various hardware and software environments into which and uses to which the software may be put, no warranty of fitness for a particular purpose is offered. In no event shall Arcana Development, LLC, be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Arcana Development, LLC, has been advised of the possibility of such damages.