database server authantication problem in SQL option SP3

vyanku
vyanku Member Posts: 791
edited 2012-09-18 in SQL General
I install sql 2005 and create database using sql option .
I create super user in sql and then create super user in navision.
But when I am trying to login with super it shows me error
18452 "28000" [Microsoft [ODBC SQL server driver][SQL Server] Login failed for use super,The user is not associated with trusted SQL Server.

Any body got this type of error. Please suggest any soln.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • kine
    kine Member Posts: 12,562
    Check, that the server is set to Mixed mode authentication and not just to Windows Authentication...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • sudhakarsv
    sudhakarsv Member Posts: 100
    It is already explained,check the below forum link

    http://support.microsoft.com/kb/2121736
    Regards,
    S.V.Sudhakar

Categories