Problem with Windows Login before Change Security Model

fdgameiro

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.

rafal

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)

fdgameiro

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

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.