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
- 266 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
RTC for different DB
teckpoh
Member Posts: 271
Dear All,
My sql server05 have 2 db. How to config my RTC to open another DB other than default installation one?
Jz curious where's the parameter stored to point the RTC to open default DB cz i wish to change it. Any idea? Thx in adv.
Cheers,
Wee
My sql server05 have 2 db. How to config my RTC to open another DB other than default installation one?
Jz curious where's the parameter stored to point the RTC to open default DB cz i wish to change it. Any idea? Thx in adv.
Cheers,
Wee
0
Answers
2) You need to change configuration or create new NAV Service tier for the second DB. This is the point which drives which database you will see, not RTC.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I managed to create NAV Service tier for the second DB.
In my sql server05 got 2 servers. eg: pcserver and pcserver\sqlexpress
pcserver using window authentication which defaultly pointed by rtc.
pcserver\sqlexpress i used database authentication. I want to use rtc open pcserver\sqlexpress db but I dunno where to specify userid=sa password=sasa(sqlserver id & password) in customSetting.config. What's the syntax to specify sqlserver id & password? Any idea?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Why my rtc keep accessing default NST db although i've created another NST for pointing to another db and change the databaseserver value and serverinstance name value in 2nd nst customsettings.config file. rtc seem like do not read the parameters(databaseserver value and serverinstance) that i set in service2 folder. Any idea?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.