mibuso.com
Home› NAV/Navision Classic Client
Options

SQL Server error

dburgerdburger Member Posts: 8
edited 2004-11-29 in NAV/Navision Classic Client
I get the following error message when I want to login into Navision (running on SQL server):

Volgende SQL Server fout is opgetreden:
4064, "42000", [Micrososft][ODBC SQL Driver][SQL Server]Cannot open user default database. Login failed.

Does somebody know how to solve this problem? Other users can still enter the Navision database.

Kind regards,

Dave

Comments

  • Options
    ArhontisArhontis Member Posts: 667
    Hi,

    A quick look at:
    http://groups.google.com.gr/groups?q=Ca ... gin+failed.
    From:Suresh Channamraju[MS] (sureshvc@online.microsoft.com)
    Subject:RE: "Cannot open user default database. Login failed."

    microsoft.public.sqlserver.connect
    Date:2002-08-29 12:05:01 PST


    In SQL EM, Edit registration properties and change login to 'sa' or use
    windows authentication that has sysadmin role on SQL Server (you need to windows login using this account)
    and in SQL EM go to Security->Logins and check the default database for
    the login you go the error(double click on login). Check in the database
    role, and make sure it has permissions to the database or change the
    default database.

    Regards,
    Suresh.

    Regards,
    Arhontis

    https://forum.mibuso.com/search
Sign In or Register to comment.