Problem Accessing Nav 09

tdn1234 · 2009-07-25

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

DenSter · 2009-07-25

I believe RTC only works with Windows logins, but I could be wrong.

ara3n · 2009-07-25

that correct Daniel. It only works with windows authentication.

tdn1234 · 2009-07-26

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.

DenSter · 2009-07-26

So set it up in a domain, and use Windows Logins.

ara3n · 2009-07-26

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.

tdn1234 · 2009-07-27

Can you tell me how.

garak · 2009-07-27

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

tdn1234 · 2009-07-27

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_cse06 · 2009-07-27

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

aavio · 2009-08-12

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

mohana_cse06 · 2009-08-12

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?

aavio · 2009-08-12

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...

mohana_cse06 · 2009-08-12

aavio wrote:

still i have the same problem...

can u explain the steps?

loshme · 2011-03-25

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.

ara3n · 2011-03-25

I suggest to do exe upgrade to R2, where it opens a authentication dialog to allow you to login when not in your domain.

mihail_kolev · 2011-03-28

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

Howdy, Stranger!

Quick Links

Categories

Problem Accessing Nav 09

Comments