CREATE DATABASE failed when installing Cronus Sample Database

Today I did run into a problem installing the “Cronus Sample Database”. In the error report view I found this error message

SQL Server option

Cronus Sample Database for Microsoft Dynamics NAV 2009

Fatal error during installation.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Read more

Microsoft Dynamics NAV Team Blog

All my post about NAV have been moved to “Microsoft Dynamics NAV Team Blog“. I will continue to double post about NAV on “Microsoft Dynamics NAV Team Blog” and this blog.

My blog posts http://blogs.msdn.com/nav/archive/tags/peterwib/default.aspx
All blog post http://blogs.msdn.com/nav/default.aspx

License for Dynamics NAV 2009 RTC problem

You do not have permission to run the ‘Microsoft Dynamics NAV Server’ system. Contact your system administrator to have your permissions changed

If you get this error when trying to start the RTC, it normally means it’s something wrong with the licenses.
Ensure that the license you are using have permission to run RTC and service tier (correct granule). Granule needed for RTC.
• 9,000 Role Centers
• 9,100 Dynamics NAV Server

Ensure also that the license is uploaded.
1. Start classic client
2. Open the database used by RTC
3. Click Tools->License information
4. Click upload and pick the license file to be uploaded to SQL server

Ensure also that the license is saved in the database.
1. Start classic client
2. Open the database used by RTC
3. Click File->Database->Alter
4. Click on integration tab
5. Put a check mark on “Save license in database”

“User ID and password are invalid.try again?”

If you get “User ID and password are invalid.try again?” when starting RTC you need to first check that you can login to database in the classic client. Note that the database should be the same as the service tier (the service you are trying to connect with RTC) is connected to.
1. Start “classic client with SQL”
2. Click File->Database->Open
3. Pick the server the database exist one
4. Select authentication “Windows Authentication”
5. Pick the database
6. Press OK

If it works in the classic client make database login synchronization.
1. Start “classic client with SQL” and connect to the database as above
2. Click Tools->Security->Synchronize all logins
3. Answer yes to the question if you would like to synchronize

If it doesn’t to connect to the database start SQL server manager and verify that the windows user have permission to login and use the NAV database