server access

runway7
runway7 Member Posts: 9
edited 2007-10-25 in SQL General
Hi

I have installed sql server 2005 and created database through Navision 4.03 and restored backup.The database can be accessed locally but when we try to access it from other computers in network an error msg pops out "cannot find the server"

can anyone tell me what is the problem ?

thanks in advance

Comments

  • kine
    kine Member Posts: 12,562
    If you will search this forum, you can find out that non-server editions of MS SQL are by default enabled just for local connections. YOu need to enable remote connections.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • runway7
    runway7 Member Posts: 9
    Hi

    Thanx for the help
    I had to activate remote connections along with sql server browser service and creating exceptions in firewall.Now i am able to aceess navision from other computers in the network.

Categories