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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Sync NAV Apps on Azure SQL DB
mibrel
Member Posts: 1
Hi!
Having an issue syncing navapps to a 2018 NAV Database which is on Azure SQL DB.
Service Tier is on our Azure VM and is connecting to the database just fine.
SQL Server Database Credential to access the database for the service tier is a Database Login (not windows),
Running Sync-NavApp using a current user on the VM with a windows login.
Issue looks more like point 3, but not sure how to pass such credentials to the Sync-App command.
Any ideas appreciated.
Thanks!
Having an issue syncing navapps to a 2018 NAV Database which is on Azure SQL DB.
Service Tier is on our Azure VM and is connecting to the database just fine.
Sync-NAVApp -ServerInstance DynamicsNAV110 -tenant default -Path "pathtomyapp.app"
Cannot Establish a connection to the SQL Server / Database
This could be due to one of the following reasons:
- SQL Server is not started
- Database does not exist
- Proper permissions have not be given to the NAV Server Account.
SQL Server Database Credential to access the database for the service tier is a Database Login (not windows),
Running Sync-NavApp using a current user on the VM with a windows login.
Issue looks more like point 3, but not sure how to pass such credentials to the Sync-App command.
Any ideas appreciated.
Thanks!
0