mibuso.com
Home› NAV/Navision Classic Client
Options

error message when opening database server

nostrannostran Member Posts: 106
edited 2005-07-12 in NAV/Navision Classic Client
i've installed navision 4.0 client and navision database server 4.0 on windows 2003. while installing the navision database server, i've selected the database eg. e:\abc\abc.fdb

when i try to open the database using the option servername ABC that i have defined i get the message " The operating system cannot gain access to the file e:\abc\abc.fdb Please check that the file type and attributes are correct"

if i open the database using the option client, it works perfectly

any help most appreciated :lol:

Comments

  • Options
    watungwatung Member Posts: 29
    Sure it is not "Read-Only" file?
  • Options
    nostrannostran Member Posts: 106
    watung wrote:
    Sure it is not "Read-Only" file?

    positive it is not read only. actually gave full control rights onto the file and the folder as well
  • Options
    SteveOSteveO Member Posts: 164
    I think Watung meant the file property "read only". If you right click on the file choose properties there are some check boxes at the bottom, one of them is Read Only.
    This isn't a signature, I type this at the bottom of every message
  • Options
    kinekine Member Posts: 12,562
    In some cases when you select the database during install process the path is not saved. Please, try set the server service again (for example through mmc snap-in).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    GoMaDGoMaD Member Posts: 313
    bbrrr, the mmc plug-in from Navision. :-&

    In my six years of experience with Navision i NEVER used this snap-in

    The command prompt is much more reliable
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • Options
    kinekine Member Posts: 12,562
    GoMaD wrote:
    bbrrr, the mmc plug-in from Navision. :-&

    In my six years of experience with Navision i NEVER used this snap-in

    The command prompt is much more reliable

    Yes, I agree, but there is still more and more people which don't know what is command prompt... :roll:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    GoMaDGoMaD Member Posts: 313
    ah, the good old days :D
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • Options
    nostrannostran Member Posts: 106
    i've tried to configure the snap in again but still does not work. couple of time when i go back to the snap in i created, get the message can't start the snap in.

    anyone kind enough to tune me on the command lines for the snap in. thanks
  • Options
    GoMaDGoMaD Member Posts: 313
    use the following syntax:
    server servername=yourname,database=c:\yourpath\yourdb.fdb,cache=800000,commitcache=yes,nettype=tcp,installasservice

    the cache size you specify depends on your internal memory.
    The best way to calculate is the following procedure
    open task manager when your db server isn't running, on the performance tab note the Available Physical Memory. Subtract 250.000 of this number (should be enough to keep the server running smoothly) and the result is your cache. (note that the maximum cache of a native service is around 900.000)

    Regards
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • Options
    nostrannostran Member Posts: 106
    hi Gomad,

    thanks a lot for your help. one question though, where do i type in those command lines. i've tried to type it in dos prompt but to no avail.

    regards
  • Options
    GoMaDGoMaD Member Posts: 313
    change dir to the directory where your server.exe can be found

    you can try to run the server in a dos box first, to do this just leave out the installasservice part

    After the full command has run you must manually start the service in your services window
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • Options
    mzvolskymzvolsky Member Posts: 1
    In default, Navision server service is installed under account 'NT AUTHORITY\NetworkService', when I changed the service user to the default user, e.g. Local System account (Local System), the problem with the database file permission disappeared. (I installed the service from the command prompt since I am accustomed to.)

    The Navision server and client build number is 20942.
Sign In or Register to comment.