Opening a 3.60 Database with SQL Server option

sudoku
sudoku Member Posts: 50
edited 2007-10-17 in SQL General
I've been trying to open an 3.60 SQL Server Database with windows login.An error message pops up saying

"The combination of user id and password is invalid.Try again".
I've been through the previous topics and checked my SQL Server too regarding the xp_ndo.dll,xp_ndo_enumusersids,xp_ndo_enumusergroups.

what might be the problem?

Thx in advance

Comments

  • sudoku
    sudoku Member Posts: 50
    Thx for ur response Black Tiger.
    I tried using "sa" login but i could not.It shows an error message

    The following SQL Server error(s) occured:
    18452,"28000",[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' .The user is not associated with a trusted SQL Server Connection.

    Is this because of settings in SQL Server?

    Thx in advance.
  • kine
    kine Member Posts: 12,562
    You need to switch the SQL server into mixed security mode. You can do it in the SQL properties in enterprise manager. After that, you can login as sa.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision Attain forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories