Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 268 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Live DB to Test DB SQL Help
mp
Member Posts: 20
Navision 3.7 and using SQL 2000 as a backend database.
My plan is to create a copy of the production DB to a test DB for some testing purposes.
Using SQL Enterprise Manager I backed up the database to a .BAK file.
I created a new DB "TEST"from within Navision (File - DB - New etc..) and using Enterprise Manger I restored the .BAK file to this TEST db. The TEST DB is created in a different server than the live one. Now when I try connecting it I get an error.
Your program license permits a maximum of 0 non demostration companies. Contact the system manager if you need to setup additional companies.
I checked the license file and it points to our company license and not the cronus file. However I am able to connect to the TEST DB..
HOW?
I open the Tools - License information..(shows my company license) click change and again choose my company license file .Now If I connect, I am able to ..But once I logout I am not able to connect. I need to repeat the steps above to connect it again.
But I have no problem in connecting to the production DB.
Help Please
My plan is to create a copy of the production DB to a test DB for some testing purposes.
Using SQL Enterprise Manager I backed up the database to a .BAK file.
I created a new DB "TEST"from within Navision (File - DB - New etc..) and using Enterprise Manger I restored the .BAK file to this TEST db. The TEST DB is created in a different server than the live one. Now when I try connecting it I get an error.
Your program license permits a maximum of 0 non demostration companies. Contact the system manager if you need to setup additional companies.
I checked the license file and it points to our company license and not the cronus file. However I am able to connect to the TEST DB..
HOW?
I open the Tools - License information..(shows my company license) click change and again choose my company license file .Now If I connect, I am able to ..But once I logout I am not able to connect. I need to repeat the steps above to connect it again.
But I have no problem in connecting to the production DB.
Help Please
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.