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
Can't connect to SQL server
staalanden
Member Posts: 12
Hi All
I have just installed NAV2013 - Client, Server and Database on the same Windows 2008 R2 Standard server. It works and everything is fine :-)
I would now like to separate the database to my dedicated SQL server running Microsoft SQL Server Web (64-bit). I have installed "SQL Server Database Component" on the SQL server but I can't get the NAV server to connect to it. The service is using "Network service" as Login account and Credential Type is "Windows". All the computers is on the same AD and I'm an administrator.
When I try to connect I get the error on the picture below. It must something with the permissions on SQL server but i can't figure out what, any ideas on how I can narrow it down?
I have just installed NAV2013 - Client, Server and Database on the same Windows 2008 R2 Standard server. It works and everything is fine :-)
I would now like to separate the database to my dedicated SQL server running Microsoft SQL Server Web (64-bit). I have installed "SQL Server Database Component" on the SQL server but I can't get the NAV server to connect to it. The service is using "Network service" as Login account and Credential Type is "Windows". All the computers is on the same AD and I'm an administrator.
When I try to connect I get the error on the picture below. It must something with the permissions on SQL server but i can't figure out what, any ideas on how I can narrow it down?
Lars Hædersdal
0
Answers
Of course you need to give access to that account in SQL Server.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Great that did the job, thx :-)
Where should we create domain account on either database server or NAV server?
I am planning to separate Database and NAV server for production environment.
Thank you.
It is not created on the single computers.
Another trick you can use (But always try to avoid it because is NOT best practices, but might be necessary in certain cases):
Create a local user on both machines. Both NEED to have the SAME NAME and SAME PASSWORD. This way you can use the local using in SQL Server and the Dynamics NAV service can use the same name. And it is possible for the NAV service to connect to SQL Server.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!