Demo NAV 2009

johanna

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.

ssingla

You need to download and install SQL server management studion for sql 2005.

aavio

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:

lvanvugt

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.

johanna

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