Nav 5 - SQL Server Express - Database login fails

KeithMMoore
KeithMMoore Member Posts: 59
edited 2007-10-24 in SQL General
I am trying to set up a Nav 5 demo on a laptop with Win XP Prof 2002 SP2 using SQL Server Express [I need to ultimately start doing some SQL Reporting Services stuff as well]

It opens Nav 5 fine assuming my laptop ID but I cannot set up a Windows login since there is no Active Dir. When I set up a database login user with SUPER rights and synchronize, all goes well until I try to start Nav 5 as that user. I then receive a "18452 ... - login failed. The user is not associated with a trusted SQL server."

I have set up the same named user within SQL Express as a dbo and checked the Access property on Alter Database->Options tab for dbos, dbcreators & sysadmin.

I admit to being a novice on SQL setup so if I have not provided enough info please let me know; appreciate in advance any and all advice on this. Thanks.

Comments

  • DenSter
    DenSter Member Posts: 8,307
    That message is usually when SQL Server is set up for Windows logins only, and you're trying to access it using database logins. Go to the server properties (right click the server from within SSMS and open properties). On the Security page there is a property called 'Server authentication'. Make sure this is set to 'SQL Server and Windows Authentication mode'. Restart the SQL Server.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • KeithMMoore
    KeithMMoore Member Posts: 59
    Thanks much - that was it...
  • DenSter
    DenSter Member Posts: 8,307
    Excellent :)
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories