Demo NAV 2009

johanna
johanna Member Posts: 369
edited 2011-01-04 in NAV Three Tier
Dear all,

When we install Demo NAV 2009, SQL Server 2005 Express Edition is installed. But, there is no SQL Server Management Studio in this SQL Server 2005 Express, isn't ?
I try to create new database from NAV and restore cronus database and synchronize all user. When I close the database and open it again with Windows Authentication, it result error : invalid user ID and password. Anyone know why it result error and how to fix this?
Is the demo version is very limited then I cannot create new database?
Please help. Thank you.
Best regards,

Johanna

Answers

  • ssingla
    ssingla Member Posts: 2,973
    You need to download and install SQL server management studion for sql 2005.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • aavio
    aavio Member Posts: 143
    open new DB in management studio,
    GotO User table, OPEN, Delete all records.
    GotO Windows Login table, OPEN, Delete all records. :whistle:

    Open Classic Client :thumbsup:
    aav!o
  • lvanvugt
    lvanvugt Member Posts: 774
    You might want to read this (as far as I know it should also apply to SQL Server 2005 Express: SQL Server 2008 Express #1: the free database engine from Microsoft.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • johanna
    johanna Member Posts: 369
    Hi,

    thanks to ssingla, aavio, and lvanvugt .. ^^
    this error "invalid user ID and password" just because I don't set the user I used in windows login. So, the solution is after restore database and synchronize all, I must add my user to windows login then synchronize all..
    Thanks again for all :)
    Best regards,

    Johanna

Categories