Apex Customer Portal Apex Customer Portal
Forums Pictures Articles Downloads
Advanced purchasing for Electrical, Plumbing, and HVAC contractors
Register Active Topics Members Search Bookmarks FAQ
Save Password Forgot your password?
 All Forums
 Problem: sa login fails due to improper security
 Printer Friendly Version  
Author Previous Topic Topic Previous Topic  

131 Posts
Posted - December 27 2004 :  12:51:36 AM  Show Profile Send a private message to admin
Why does the Apex Database login fail with the message "Login failed for user sa. Reason: Not associated with a trusted SQL Server connection."

This is what happens if the SQL Server is not installed with support for SQL Authentication. (This is also sometimes called "Standard" security.) That's why we need the "SECURITYMODE=SQL" parameter during the MSDE installation. The Apex installation program does this automatically.

If you have a "real" version of SQL Server loaded, you can change the security mode in the SQL Server Enterprise Manager without uninstalling and reinstalling the program. To do this, call up the properties for the SQL Server, go to the Security tab, and make sure that "SQL Server and Windows" is selected as the authentication option.

Otherwise, use the normal Apex setup program, or use the setup.exe command line as shown in the next section (MSDE is not installed correctly and cannot be removed).

Jump To:

Set as your default homepage Add favorite Privacy   2017 Vulcan Software LLC All Rights Reserved.   Go To Top Of Page