Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 2009 Database Server service does not start
afarr
Member Posts: 287
We have a handful of Nav Database Servers set up on our server, some are Nav 4.03 and 2 are Nav 2009.
Each service has a unique port, using TCP, which is assigned in the services file, e.g.
SERVICE_1 2414/tcp
SERVICE_2 2415/tcp
One of the Nav 2009 Database Servers (SERVICE_2) is working well, but when I try to start the other one (SERVICE_1) I get "System error 5 has occurred. Access is denied."
The database is OK, since I can connect to it directly from the Nav client. Any suggestions about possible causes and resolutions are appreciated.
For reference purposes, SERVICE_1 was installed by opening a command prompt, going to the directory for the Database Server, and running the following command:
SERVER servername=SERVICE_1,database=\\dynamics_db\NavData\SIE\my_database.fdb,NETTYPE=TCP,INSTALLASSERVICE
\\dynamics_db is a separate server (the same server used for SERVICE_2, by the way), and the folder \\dynamics_db\NavData is shared, with essentially unlimited number of users able to access it.
Each service has a unique port, using TCP, which is assigned in the services file, e.g.
SERVICE_1 2414/tcp
SERVICE_2 2415/tcp
One of the Nav 2009 Database Servers (SERVICE_2) is working well, but when I try to start the other one (SERVICE_1) I get "System error 5 has occurred. Access is denied."
The database is OK, since I can connect to it directly from the Nav client. Any suggestions about possible causes and resolutions are appreciated.
For reference purposes, SERVICE_1 was installed by opening a command prompt, going to the directory for the Database Server, and running the following command:
SERVER servername=SERVICE_1,database=\\dynamics_db\NavData\SIE\my_database.fdb,NETTYPE=TCP,INSTALLASSERVICE
\\dynamics_db is a separate server (the same server used for SERVICE_2, by the way), and the folder \\dynamics_db\NavData is shared, with essentially unlimited number of users able to access it.
Alastair Farrugia
0
Answers
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Anyway, this is just a NAV DB server, without SQL or RTC, so I didn't set up any SPNs.
I realise that SERVICE_1 and SERVICE_2 might be both using a default SPN (or default port number) and thus conflicting with each other.
To check this, I uninstalled them both, re-installed SERVICE_1 only, and I still can't start it - it's the same error as before.
Ok, than check that each service is using different copy of the server folder (you can run only one service from one folder/server.exe)
Check, that the service account under which the server is running, have access to the fdb file.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
The database server was in folder C:\SERVICE_1
I moved this to the NAV folder, and it worked, so it's now C:\Program Files (x86)\Microsoft Dynamics NAV\60\SERVICE_1
So, at least with NAV 2009 database server, the folder has to be in C:\Program Files (x86)\Microsoft Dynamics NAV\60\
Thanks for all your help.