EP-problems when using 2 NAS's in 2 different companies

BlackBird

Hi All,

I'm having trouble with the following setup.
I have one database containing 2 companies. Both companies have to be accessed through the Employee Portal.
For that purpose i have installed 2 instances of the NAS. De first points to company A with startupparameter NEP-1. In this company i have performed the appropriate setup (EP Setup and NAS Setup).
De second NAS points to company B in the same database with parameter NEP-2. I have also done the mandatory EP- and NAS-setup in this company.
Both NAS's use the same message queues (according to the EP-documentation you cán use the same queues for multiple nas's).
All software (sql server, applicationserver, sharepoint) is installed on the same server by the way.

For the demo i have created one site for Company A and one for Company B and i use the existing webpart CUSTOMERLIST from the SALES-group from CRONUS to show all customers.
As you might have guessed: on site Company A the customers from Company A have to be listed and on site Company B the customers from Company B have to be listed.

But this doesn't work. The site from Company A shows me the customers from that company, but when i refresh the site the customers from Company B are shown ](*,) After another refresh the customers from company A are shown again.


Why is this happening? What am i missing or doing wrong? #-o

Your help is greatly appreciated.

Thanks,

Hans

kine

I recommend to split the message queues. One queue can be used for one company with more NAS for load balancing. If you want to send one request from one site to one server and from another site to another server, I assume that you need different queues for each site.

IHateLinux

Hi,

Kine is right.

To use more NAS on the same queue means to have load balancing for accessing one company in one database. As long as you get the customers from the different companies you can see that the load balancing is working.

You have to setup a second pair of queues for the communication with the second company.

BR
Rainer

kine

After you split the queues, you need to set correct queue in the web.config for each site...

BlackBird

Well,

i've been testing and trying to create the required setup when 2 companies from one database are involved. Conclusion:
- you have to set up 2 SPS-sites.
- install EP for the first site and copy the contents of the installmap manually to the map of the second site (just like installing a second datbaseserver).
- create a new pair of messages
- and then install the second NAS and do the proper settings in the database.

i Hope this is usefull for anyone out there.
\:D/

Hans

DenSter

Excellent feedback Hans, thanks for sharing that. This should go into the tips and tricks section. =D>

BlackBird

thanks Daniel for the praise .

My conclusion is a bit short, so here's how a did it (a bit longer version):

Steps for the second site:
- create a new folder in the wwwroot-folder;
- create a new site on IIS and point it to this new folder. Use seperate portnumber for the second site;
- from the central administration site on Sharepoint you have to extend this new virtualwebsite;
- copy the contents of the folder of the first website (in a clean installation this is in the wwroot-folder i guess) to the new folder (folders Bin, usercontrols, wpcatalog and the web.config);
- create two new message queues;
- adjust the web.config for the second site and replace the existing queuenames with the new ones;
- install a second NAS (you have to do this manually);
- do the proper settings in the EP-setup in the database (NAS-settings, backendpair etc);
- voila =P~

Hans

surya.singh

Hi blackbird,I am having the same problem,But i m not able to run NAS properly.Suppose I am running NAS from Dos prompt,It is displaying the message
"NAS for Employee Portal is Started" .But when I am trying to access the web part it is displaying the communication error.

It is very urgent to run two NAS for two company.Pls help me ASAP...

BlackBird

Hi surya.singh,

is your event viewer saying anything?
Did you setup the NAS allright (startup parameter) and do the proper EP-settings in the database?

Hans

surya.singh

Hi BlackBird,

My EventViewer is showing warning message stating about the Registry Permission.I need to run four different NAS for 4 different companies.I want to run it from Command Prompt.
Command I am using is:

g:\program files\microsoft business solution-navision\application server>NASSQL appservername=NAS1,servername=indasset,database=Reach_LIVE,company=Reach Lifesystems Pvt. Ltd.,nettype=default,startupparameter=NEP-1

I am using Sql Server option for database.NASSQL is successfully install as a service.
Now I am copying the Required files from application server to application server2 and installing it as a service.In this case,System automatically uninstall the first NAS service and install second as a service.After this i am running the command and it is showing the message that NAS for employee portal is started successfully.But it is not able to connect and giving the communication error.

When I am passing the startupparameter manually to HTTP Request Handler codeunit as NEP-1 and running it.Then it is correctly connecting me to the server and everything is working fine.

Pls suggest me what to do in my case.
Thanks and Regards:
Surya Prakash Singh

kine

Do not forget that the service must run under user with access into NAV and you need to check the permissions on the MSMQ queues used by NEP too...

surya.singh

The description for Event ID ( 20010 ) in Source ( INDASSET-SQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: The combination of user ID and password entered is invalid. Try again.

This is what i am getting in Eventviewr.Pls help me what to do next.

surya.singh

Ya Kine,
Service is running under the user acount who have super permission in Navision.It has Job queue permission as well.I am using windows authentication for navision. Its showing UserId and password is invalid

Thanks for help:

Surya

kine

1) Please cross-check the Account, under which the NAS (INDASSET-SQL) is running
2) Check that SAME account (same domain, same name) is inserted into Windows Logins table.
3) Check that permissions are synchronized.
4) Check that you checked the permissions in point 3 in same database which is used by the NAS.
5) Check that there is no another message before or after this one in Event Log.

surya.singh

Hi Kine, As i discovered the points u mentioned.Its like

1)NAS INDASSET-SQL is running with navadmin@medschool.local .That is for domain user MEDSCHOOL\navadmin

2)In Windows login table ,I have Medschool\navadmin as a user with super permission.

3) Pls tell me how to check the permissions are synchronized or not.Is it in SQL Server database..???

4)In sql server in corresponding database,I am having the navadmin as a user with db_owner permission.

5) There is no message in event log before or after the message ,I mentioned.


Does anywhere it is related with windows and or sql server authentication.We all are loging into the system by windows authentication only.And it is working fine....

Pls suggest me how to proceed.....

Thanks in advance

Surya Singh

kine

ad 3) Just press the Synchronize all button and if there is no error, you are sure, that permissions are synchronized. Do not search for anything else behind this sentence... :-)

surya.singh

Hi Kine,

I didn't get any error by pressing synchronize all button.It means the permissions are synchronized.

So now coming to my problem,All the checklist is fine as you told.Then how is this coming.

As i think this may be because of UserId and password in database login.

I am totally frustrated by this...........

Thanks in advance:

Surya Prakash