Allow SQL Password Logins MSDE

Argh. The default MSDE configuration disables SQL Server users and passwords - leaving just Windows authentication. Soo.... if you check that little box in the ODBC configuration, it does nothing and you get an error message upon testing/using.

Specifically, this was my error message when trying to open tables with Access:
"Not associated with a Trusted SQL Server connection"

See this to fix this:;en-us;285097
Without Enterprise Manager, you need to do change this setting IN THE REGISTRY. Fun.

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode - 2=mixed mode

If you knew this beforehand, you could enable the authentication mode in the setup.ini file by adding: "SECURITYMODE=SQL"

Related Scribbles:
  • Free SQL Server / MSDE Admin
  • Microsoft Access Links
  • SQL Server

  • ID: 550
    Date Updated:
    2013-10-03 15:31:09
    Date Created:
    2004-09-15 00:49:40


     >> Leonard Chan's Homepage  >> Scribble Web  >> Allow SQL Password Logins MSDE is hosted by Perceptus Solutions Inc.