Logout Developer Knowledgebase Search Adobe Partners Main Adobe Solution Partner Finder Adobe Solution Partner Program Support Developer Knowledgebase Adobe Solution Partner Program Products & Technology Adobe
Developer Knowledgebase

Knowledgebase HomeContent Server KB

Overview
Software Development Kits
Developer Knowledgebase
Support
Legal Notices
Feedback
Adobe Solution Partner Program
Join
Find a Solution Partner

Product
ContentServer
 
Version
3.0.1
 
Last Edited
16-Jul-2004
 
Document
53766

How To: Login failed ... not associated with a trusted SQL server connection

Summary
You probably didn't specify "Mixed Mode authentication" during the install.


Issue
While configuring the ODBC data source (step 2 on page 12 of the ACS Administrator Guide) I'm getting the error
    Connection failed:
    SQLState: '28000'
    SQL Server Error: 18452
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'gbadmin'. Reason: Not associated with a trusted SQL Server connection
Solution
You probably didn't specify "Mixed Mode authentication" during the install.
Bad authentication mode.png
  • Open The SQL Server Enterprise Manager
    Start menu > Programs > Microsoft SQL Server > Enterprise Manager)
  • Expand the tree-control until you can your server
  • Right click on the server name and "SQL Server Properties (Configure)" window will open
  • Select the Security tab
  • For "Authentication", select "SQL Server and Windows"
SQL Server and windows.png

Click "OK" to close the window and then "Yes" to restart SQL Server

Supporting Files
Bad authentication mode.png
SQL Server and windows.png

back to top
Was this Knowledgebase document helpful? Yes  No
The articles in this knowledgebase are intended for use by software programmers currently using an Adobe SDK to extend or customize an Adobe product. These articles may be highly technical in nature.
If you have questions about an Adobe Product that are not related to development or an SDK product please visit: http://adobe.com/support/main.html
Copyright © Adobe Systems Incorporated. All rights reserved.
Terms of Use
Online Privacy Policy