Database user acces on SQL2008

ouredp
ouredp Member Posts: 56
edited 2009-12-22 in SQL General
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

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ouredp
    ouredp Member Posts: 56
    :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.

Categories