Client server Connectivity in SQL 2005 SP3

vyanku
vyanku Member Posts: 791
edited 2007-09-26 in NAV/Navision Classic Client
I install SQL 2005 on Win 2003 server.
Then I install navision create database ans users as per requirnment and add them in SQL server also.
On that server when I am trying to connect server it connects sussessfully with any user.
But when I am trying from other PC it will shows me error server not found.
But it shows the name of the server in the list of all servers.
Is it necessary to install SQL server 2005 client on client PC ?
if not then what must be the problem??? ](*,)

Comments

  • nunomaia
    nunomaia Member Posts: 1,153
    Check remote connections

    http://www.mibuso.com/forum/viewtopic.php?t=20898
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • vyanku
    vyanku Member Posts: 791
    I am using enterprise edition.
    Will you please tell me how to activate remote connection manually?
  • vyanku
    vyanku Member Posts: 791
    hi I done that also.
    Now it shows me another error
    229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object '$ndo$dbproperty',database 'name of database' ,schema'dbo'

    Any body please suggest any solution.
  • nunomaia
    nunomaia Member Posts: 1,153
    Did you synchronized users?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • vyanku
    vyanku Member Posts: 791
    If we change any property of the user in SQL is it necessary to synchronize avery time?
  • kine
    kine Member Posts: 12,562
    1) Change the security model to simple
    2) Read the documentation about the security models. There are cases when you need to sync the security.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    1) Change the security model to simple
    2) Read the documentation about the security models. There are cases when you need to sync the security.

    Did you mean the sequrity model of SQL?
    Will you please tell me how to change the sequrity model to simple?
  • kine
    kine Member Posts: 12,562
    I mean Nav security model (there is just simple Recovery model in MS SQL). File - Database - Alter - Advanced - Security model. For more info see documentation (Security Synchronization in Navision 4.0 SP3.doc).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • nunomaia
    nunomaia Member Posts: 1,153
    After synchronization did it solved that permissions problem?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • vyanku
    vyanku Member Posts: 791
    again I am getting the same error message
    229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object '$ndo$dbproperty',database 'name of database' ,schema'dbo'
  • diptish.naskar
    diptish.naskar Member Posts: 360
    vyanku wrote:
    again I am getting the same error message
    229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object '$ndo$dbproperty',database 'name of database' ,schema'dbo'

    Hi Vyanku,

    Try this, on the client machine(obviously other than the server) open the add an entry to the host file and change the services file and provide the port no. by default Navision uses 2407. Save the files and then try to connect the same.

    Hope this works for you.
    Diptish Naskar
    For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
  • vyanku
    vyanku Member Posts: 791
    Thanks
    My Problem is solved.

Categories