mibuso.com
Home› NAV Three Tier

Problem Accessing Nav 09

tdn1234tdn1234 Member Posts: 47
edited 2011-03-28 in NAV Three Tier
Hi,

I have installed Navision Database on Sql.

User ID - SA
Password - 123
Now I am trying to access the database from a client system using RTC. Its not working.

Can any1 assist in this.
Thanks,
Tdn

Comments

  • DenSterDenSter Member Posts: 8,307
    I believe RTC only works with Windows logins, but I could be wrong.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ara3nara3n Member Posts: 9,256
    that correct Daniel. It only works with windows authentication.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • tdn1234tdn1234 Member Posts: 47
    That means RTC can only work in a domain setup.

    We cannot have the traditional way of creating users in SQL and accessing the database using a FinSql Client.
  • DenSterDenSter Member Posts: 8,307
    So set it up in a domain, and use Windows Logins.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ara3nara3n Member Posts: 9,256
    tdn1234 wrote:
    That means RTC can only work in a domain setup.
    .

    not necessarly. You can use windows users and you don't need active directory.



    I believe in future version sql will remove db authentication.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • tdn1234tdn1234 Member Posts: 47
    Can you tell me how.
  • garakgarak Member Posts: 3,263
    in the windows login enter \Windowsusername <- this is the local windows user name if you doesn't have a domain.

    This i would only use if i have one or two users who use NAV and the firm is so little that he doesn't need a domain.
    If the firm is larger, a domain shauld also use (so with an AD you have a lot of benefits
    Do you make it right, it works too!
  • tdn1234tdn1234 Member Posts: 47
    I am still not able to connect to RTC Client. I followed following steps.

    Step 1 :- I connected network through LAN.
    Step 2 :- I created a new window User ID in Server , named "userid" which is identical to my local system user id "userid".
    Step 3 :- Then I created a new userid in SQL server, named "servername\userid".Its a window Login id on SQL Logins.
    Step 4:- Loged in NAV through classic and created "servername\userid" in NAV and then synched with SQL.
    Step 5:- Then I tried to connect RTC from my local system and get an error (User ID and Password is not correct).
    Step 6:- Tried to connect through NAV Classic by selecting Window Login option then also i got same error.

    I need help, how to create user id for window login if Network is not domain based.

    Thanks in advance.
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    tdn1234 wrote:
    I am still not able to connect to RTC Client. I followed following steps.

    Step 1 :- I connected network through LAN.
    Step 2 :- I created a new window User ID in Server , named "userid" which is identical to my local system user id "userid".
    Step 3 :- Then I created a new userid in SQL server, named "servername\userid".Its a window Login id on SQL Logins.
    Step 4:- Loged in NAV through classic and created "servername\userid" in NAV and then synched with SQL.
    Step 5:- Then I tried to connect RTC from my local system and get an error (User ID and Password is not correct).
    Step 6:- Tried to connect through NAV Classic by selecting Window Login option then also i got same error.

    I need help, how to create user id for window login if Network is not domain based.

    Thanks in advance.

    Go to Microsoft Dynamics NAV Server Services
    in LogOn Tab use This account(Userid and Password)
    Restart Service and Try to connect

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • aavioaavio Member Posts: 143
    mohana_cse06 wrote:
    Go to Microsoft Dynamics NAV Server Services
    in LogOn Tab use This account(Userid and Password)
    Restart Service and Try to connect

    is this solution working???? any one tried?? :-k
    aav!o
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    aavio wrote:
    mohana_cse06 wrote:
    Go to Microsoft Dynamics NAV Server Services
    in LogOn Tab use This account(Userid and Password)
    Restart Service and Try to connect

    is this solution working???? any one tried?? :-k

    Did you get any problem with this?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • aavioaavio Member Posts: 143
    mohana_cse06 wrote:
    aavio wrote:
    mohana_cse06 wrote:
    Go to Microsoft Dynamics NAV Server Services
    in LogOn Tab use This account(Userid and Password)
    Restart Service and Try to connect

    is this solution working???? any one tried?? :-k

    Did you get any problem with this?

    still i have the same problem... :(
    aav!o
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    aavio wrote:
    still i have the same problem... :(

    can u explain the steps?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • loshmeloshme Member Posts: 1
    I am also very interested in making RTC work without domain because i would like to connect over wan where I cannot be in the same domain as my server. Any help would be appriciated.
  • ara3nara3n Member Posts: 9,256
    I suggest to do exe upgrade to R2, where it opens a authentication dialog to allow you to login when not in your domain.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • mihail_kolevmihail_kolev Member Posts: 379
    loshme wrote:
    I am also very interested in making RTC work without domain because i would like to connect over wan where I cannot be in the same domain as my server. Any help would be appriciated.

    It's possible in R2 http://msdn.microsoft.com/en-us/library/gg502476.aspx
    -Mihail- [MCTS]
Sign In or Register to comment.