could not open/connect to database with RTC client

chris1129

Hi All,
I am trying to do some test on my local own computer,so I installed SQL server 2005 ( 32 bit) on my win 7 operate system; and i installed NAV server,NAV 2009 Roletailor client; and i also conneted the demo(6-0) database to sql server 2005, but i could not connet database through RTC client, I do not know why?
when i try to open my database throught RTC client, the error messasge as below:
"The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: user ‘NT AUTHORITY\NETWORK SERVICE' failed when log in".

i do not know whether i have finished all the confiration about the database and sql? is there any other steps i need to setup?

thanks very much for your advice and answers in advance.

mik

Hi,
because it is only a local demo system I would try to run the NAV Services with your account. This should solve your problem.

greetings michael

chris1129

Hi Michael,

thanks for your kindly reply,
but I could not run the NAV Service?

mik wrote:

Hi,
because it is only a local demo system I would try to run the NAV Services with your account. This should solve your problem.

greetings michael

mik

Hi,
sorry I never had problems like this on the local computer. Only in a three tier environment there a rules to follow.

At the moment I am not sure what's not working for you.

1) You installed the NAV Server so you have a server "Microsoft Dynamics NAV Server" and another one for the Webservice. Those two services can not be startet?
2) The Database and the services are on the same machine?
3) You tried to change the logon information for the service to another user?

greetings michael

mohana_cse06

chris1129 wrote:

Hi Michael,

thanks for your kindly reply,
but I could not run the NAV Service?

What error message you are getting?

chris1129

Hi Mohana,
thanks for your notice,
when i tried to open nav with rtc client the error message popped as the attached picture:

mohana_cse06 wrote:

chris1129 wrote:

Hi Michael,

thanks for your kindly reply,
but I could not run the NAV Service?

What error message you are getting?

chris1129

Hi Michael,
thanks for your answer for my problem.

to answer your question,
1) You installed the NAV Server so you have a server "Microsoft Dynamics NAV Server" and another one for the Webservice. Those two services can not be startet?

yes, cannot. i am afraid the NAV Server does not connect to sql server, but i do not know how to check it is connected or not.

2) The Database and the services are on the same machine?
yes. all the 3 tier are on the same computer.

3) You tried to change the logon information for the service to another user?

no., problem is i cannot open nav database with the rtc client, neither can change user.

mik wrote:

Hi,
sorry I never had problems like this on the local computer. Only in a three tier environment there a rules to follow.

At the moment I am not sure what's not working for you.

1) You installed the NAV Server so you have a server "Microsoft Dynamics NAV Server" and another one for the Webservice. Those two services can not be startet?
2) The Database and the services are on the same machine?
3) You tried to change the logon information for the service to another user?

greetings michael

mohana_cse06

Set Log on to local account in Microsoft Dynamics server service in services
restart the service and try

Edit : As you said it is on your local machine..

chris1129

yes, it is on my local machine, but how to and where to setup the log on information? could you please describe it in detail,thanks very much.

mohana_cse06 wrote:

Set Log on to local account in Microsoft Dynamics server service in services
restart the service and try

Edit : As you said it is on your local machine..

mohana_cse06

Click Run from Start..
enter services.msc
clieck enter
Services will open
select Microsoft Dynamics Server Service
right click-->select properties
Click logon tab
change it to Local System Account and restart it..
Open RTC

chris1129

Hi Mohana,

i tried with the methods you listed.
and now, a new error message when i try to open nav by rtc client is as below:

" The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: cannot open the requested database "Demo Database NAV (6-0)". log on failed. User 'NT AUTHORITY\SYSTEM'log on failed'."

mohana_cse06 wrote:

Click Run from Start..
enter services.msc
clieck enter
Services will open
select Microsoft Dynamics Server Service
right click-->select properties
Click logon tab
change it to Local System Account and restart it..
Open RTC

Peter_Wibeck_[MSFT]

Take a look at

Enabling the Object Change Listener
http://msdn.microsoft.com/en-us/library/dd568739.aspx

chris1129

i did the setup step by step follow the methods that the web adviced. and then i try to open database with the rtc client,
got another error, i attached the error message in below,
and my computer system is win 7(32 bit), and sql server 2005 (32 bit),

"Peter wrote:

"]Take a look at

Enabling the Object Change Listener
http://msdn.microsoft.com/en-us/library/dd568739.aspx

mohana_cse06

Follow this link
http://blog.wibeck.org/2009/05/installing-store-procedures-for-dynamics-nav-2009-manually/

chris1129

Hi Mohana,
many thanks for your reply and help, i am really happy that in here i got so many helps from you and other unkown friends. you all are very kind.

I tried with the methods the linked web shows, and i am quite sure that i am closing to the success step by step,
but now, i really got another error when i try to open NAV database with the rtc client, the error said that" the user id or password are invalid.", i am confused that i did not input user name or password, why there is error about user id or password?

mohana_cse06 wrote:

Follow this link
http://blog.wibeck.org/2009/05/installing-store-procedures-for-dynamics-nav-2009-manually/

mohana_cse06

Check this link
http://blog.wibeck.org/2009/10/user-id-and-password-are-invalidtry-again/

chris1129

i can open database from classic client for Sql, and i also did the synchronization.
after that, when i try to open database from rtc client, i got an wierd error---here i attached it in the following,

mohana_cse06 wrote:

Check this link
http://blog.wibeck.org/2009/10/user-id-and-password-are-invalidtry-again/

mohana_cse06

Compile all objects from classic client and try

chris1129

when i compile, i got many reports error message, error messages are almost the same, said "Could not copy the ReportLayout directory. Detailed description: unexpected file ending occured. the following elements are not closed: CaptionML, Report. line 6,position 44."

mohana_cse06 wrote:

Compile all objects from classic client and try

mohana_cse06

is it a upgraded database or base?

chris1129

there is chinese lanuage traslation related to each fields in each object

mohana_cse06 wrote:

is it a upgraded database or base?

mohana_cse06

just check whether this ca help you
http://www.mibuso.com/forum/viewtopic.php?f=32&t=37935

chris1129

thanks very much, i will check.

mohana_cse06 wrote:

just check whether this ca help you
http://www.mibuso.com/forum/viewtopic.php?f=32&t=37935

chris1129

i tried many times to download the hotfix, but i could not open the download link, http://hotfixv4.microsoft.com/Microsoft ... 86_zip.exe)

chris1129 wrote:

thanks very much, i will check.

mohana_cse06 wrote:

just check whether this ca help you
http://www.mibuso.com/forum/viewtopic.php?f=32&t=37935