Problem with Windows Login before Change Security Model

fdgameiro
fdgameiro Member Posts: 4
edited 2013-02-22 in NAV/Navision Classic Client
Hello,

I changed the security model of Navision 5.0 with Sql Server 2008R2 Database to Standard.
When i try to access Navision with Database login i can do everything normally.
But when i try to acess with Windows Login i got the error "The user and password are invalid.".

I tried to connect database directly by sql server and my login works (With both users). ](*,)

So, someone have one idea how to fix that at Navision?

Thanks.

Comments

  • rafal
    rafal Member Posts: 23
    Do you have proper created SQL logins, and database users (wrong user schema)? Logins in NAV are synchronized?

    I think you can have created SQL login, but missing database user...

    If you have a doubts please write a little bit more about your users configuration in SQL, or look in the security manual for NAV 5 (can find it on the cd with NAV)
    Rafał
    http://www.nav.info.pl (The first polish blog about Microsoft Dynamics NAV)
  • fdgameiro
    fdgameiro Member Posts: 4
    rafal wrote:
    Do you have proper created SQL logins, and database users (wrong user schema)? Logins in NAV are synchronized?

    I think you can have created SQL login, but missing database user...

    If you have a doubts please write a little bit more about your users configuration in SQL, or look in the security manual for NAV 5 (can find it on the cd with NAV)


    Rafal,

    I Have my Windows Login user at navision is the same of Sql Server, the schema is "dbo" and I removed db_owner permission, but if i put it again the same error occurs.

    Before i change the security model Enhanced to Standard I had not any problems with Windows Login.

    I don't know what more infomation you need for help me... #-o

    Thanks..
  • rafal
    rafal Member Posts: 23
    It's not so simple... If user has dbowner privilages and can't login to database this means that is not a one of the standard issues...

    I think the easiest way is create the new windows login according to Security Hardening manual from NAV cd, and compare it with old logins...

    Try following steps:
    - Create new windows login
    - Create new login in SQL based on Windows security (Security->Logins in SQL Management Studio) (without linking it with any databases)
    - Add created login in NAV
    - Synchronize logins in NAV
    - Check that database user was proper created in SQL (Databases->[Database]->Security->Users in SQL Management Studio)
    - Try to login to NAV with new login

    If it's work then compare this login (and database user) with the others.
    Rafał
    http://www.nav.info.pl (The first polish blog about Microsoft Dynamics NAV)

Categories