Database user acces on SQL2008

ouredp

Hello,

We are in migration test moving from sql2000 nav4.3 on sql2008 nav 5.1

I took a Navision Backup and restored it on a new empty 5.1 database with standard security model on our sql2008 server.
I synchronized the security.

Login with windows login works fine but I can´t login with an sql server login & password.

I tried to configure the rights thru SQL security and navision SUPER role as well. Databaselogin even comes with the error: wrong user or wrong password .

Is there something missing in the server setup ? Navision setup ?

SQL2008 on Windows 2008
Navision Client 5.1 running on WinXp

ara3n

the db sql server logins need to be added manually to sql server.


I think you can create a sql script or google for it.

ouredp

:oops:

After looking at the server log I discovered that it was configured to "windows login only".

Changing the config to both window and server solved the problem.