Intranet clients work fine with installation, setup web portal as stated, remote test yields the following:

<?xml version="1.0" encoding="UTF-8" ?>

- <definitions name="DataPortal" targetNamespace="http://schemas.microsoft.com/clr/nsassem/CSLA.Server/CSLA.Server.DataPortal%2C%20Version%3D1.3.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Ddf66a8d8e49833d3" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://schemas.microsoft.com/clr/nsassem/CSLA.Server/CSLA.Server.DataPortal%2C%20Version%3D1.3.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Ddf66a8d8e49833d3" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:suds="http://www.w3.org/2000/wsdl/suds" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns2="http://schemas.microsoft.com/clr/nsassem/CSLA.Server.DataPortal/CSLA.Server.DataPortal%2C%20Version%3D1.3.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Ddf66a8d8e49833d3" xmlns:ns3="http://schemas.microsoft.com/clr/ns/System.Security.Principal" xmlns:ns4="http://schemas.microsoft.com/clr/nsassem/CSLA.Server.DataPortalContext/CSLA.Server.DataPortal%2C%20Version%3D1.3.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Ddf66a8d8e49833d3" xmlns:ns0="http://schemas.microsoft.com/clr/nsassem/CSLA.Server/CSLA.Server.DataPortal%2C%20Version%3D1.3.0.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Ddf66a8d8e49833d3" xmlns:ns1="http://schemas.microsoft.com/clr/ns/System" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/">

- <message name="DataPortal.FetchInput">

  <part name="Criteria" type="xsd:anyType" />

  <part name="context" type="ns0ataPortalContext" />

  </message>

- <message name="DataPortal.FetchOutput">

  <part name="return" type="xsd:anyType" />

  </message>..............<edited by admin>

- 

  </binding>

- <service name="DataPortalService">

- <port name="DataPortalPort" binding="tnsataPortalBinding">

  <soap:address location="http://192.168.0.10:6969/AyaNovaDP/DataPortal.rem" />

  </port>

  </service>

  </definitions>

 

 

 

When I run the remote client program (copied from server) I get this:

 

AyaNova was unable to start

Depending on how early in startup the problem occurred,
a detailed log of the problem with suggestions *may* have
been saved to the file AyaLog.txt
located at: file:\C:\Program Files\Ground Zero Tech-Works Inc on 2k3sbs\AyaNova 3

Error details:
Unhandled Exception:
Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException
Inner exception: Unable to complete network request to host "192.168.0.10".

Stack Trace:

Server stack trace:
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at CSLA.Server.DataPortal.CallMethod(Object obj, String method, Object[] params)
   at CSLA.Server.DataPortal.Fetch(Object Criteria, DataPortalContext context)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at CSLA.Server.DataPortal.Fetch(Object Criteria, DataPortalContext context)
   at CSLA.DataPortal.Fetch(Object Criteria)
   at CSLA.Security.BusinessIdentity.LoadIdentity(String UserName, String Password)
   at CSLA.Security.BusinessPrincipal..ctor(String Username, String Password)
   at CSLA.Security.BusinessPrincipal.Login(String Username, String Password)
   at GZTW.AyaNova.BLL.AyaBizUtils.0()
   at GZTW.AyaNova.BLL.AyaBizUtils.Initialize()
   at AyaNova.Form1.4()

 

Any ideas why I am getting this.

Perhaps the AyaNova.exe.config file the remote computer is using is incorrect. Or there is something with the configuration:

Please zip up the following files into a file called serverfiles.zip and attach to your reply:

• Web.Config from the computer where the Data Portal utility is installed to
• AyaNova.exe.config file from the computer

Please zip up the following file into a file called remotecomputer.zip and attach to your reply:

• AyaNova.exe.config file from the remote computer

Identify the following information:

• What is the IP address of the computer where the Data Portal is installed on
• You stated "remote test yields the following" - and than pasted a copy of the results. Confirm that this is from the computer where you installed Data Portal too. not the remote computer which your statement indicates

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Thanks

<EDIT: attachments were removed>

BertSP

1. The AyaNova.exe.config file that you sent from the computer is connecting to a local stand-alone installation of the AyaNova database - it has not yet been configured to connect to the networked Firebird database and this should be done.

Easist way to do this, is log into AyaNova on a local networked computer and confirm connecting to the networked AyaNova database.

Than copy that local netowrked computers AyaNova.exe.config file to the server, and test making sure connecting to the networked databse, not a stand-alone database.

2. I've attached an AyaNova.exe.config file zipped to this message. I want you to do each of the following and provide specific details on what occurs for each one:

• A. On the server where the database resides and where you have Data Portal set up, rename the existing AyaNova.exe.config file to AyaNova.exe.configlocalnetwork
• Extract the attached zip file to extract the AyaNova.exe.config file into the AyaNova program folder onto this server
• Run AyaNova - can you log into AyaNova on this server using this AyaNova.exe.config I just sent?
• If you can, open menu Help -> About AyaNova, copy all text to a NotePad document, save as serverAyaNovaHelp.txt and attach
• If you can not, provide the exact error you receive.

• B. On a local networked computer, rename the existing AyaNova.exe.config file to AyaNova.exe.configlocalnetwork
• Extract the attached zip file to extract the AyaNova.exe.config file into the AyaNova program folder onto this server
• Run AyaNova - can you log into AyaNova on this networked computer using this AyaNova.exe.config I just sent?
• If you can, open menu Help -> About AyaNova, copy all text to a NotePad document, save as LANAyaNovaHelp.txt and attach
• If you can not, provide the exact error you receive.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

	Post Attachments
	RemotecomputerTestAyaNova.exe.zip (2 views, 460 bytes)

  I'm working with Bert to remedy this. Somehow our config files are getting changed.

Regardless. Our configuration is with an MSSQL server that we've migrated Firebird to using the tool. After that I configured the server configuration to use SQL:

<?xml version="1.0" encoding="utf-8"?>
<configuration>

  <appSettings> 
 <add key="Authentication" value="CSLA" /> 
 
 <!-- Use a shared Microsoft SQL Express 2005 or MSDE Database -->
 <!-- Replace COMPUTERNAME and PASSWORD below with values chosen during installation of SQL --> 
 <add key="ConnectionType" value="DataBase" />
     <add key="DataBaseType" value="MSSQL" />
     <add key="DataBaseConnectionString" value="Server=localhost;initial catalog=AyaNova;User Id=xxxxxxx; Password=xxxxxxx;" />
   
  </appSettings>
</configuration>

then used the web config of

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
 
 <appSettings>
 <!--"Authentication" should always be set to "CSLA" -->
 <add key="Authentication" value="CSLA" /> 
 

 <!-- Set your database connection here, it's easiest to just copy this section from a working and tested AyaNova.exe.config file-->
 <!-- Note that Embedded Firebird can not be used with a data portal only a full shared Firebird server or MS sql server-->
 <!-- The connection block below is a sample only, you will need to replace it with your specific settings-->
 <!-- Do not change anything in this file other than the data connection sectin below -->
 

 <!-- ****** Start of data connection section *****-->
 <!-- Use a shared Firebird server, NOTE change the 192.168.1.100 below to your Firebird server's actual IP Address -->    
 <add key="ConnectionType" value="DataBase" />
 <add key="DataBaseType" value="MSSQL" /> 
    <add key="DataBaseConnectionString" value="ServerType=0;DataSource=192.168.0.10;DataBase=AYANOVA;User=xxxxxx;Password=xxxxxx;Dialect=3;" />
 <!-- ***** end of data connection section *****-->

      </appSettings> 

the IIS tests work and the firewall has been configured on a specific port.

locally the software works running the client on the server. From any client or remote it doesn't. I suspect config files issue.

Jermo

Jermo

Please confirm the following as I want to make sure of each item before we proceed:

1. On the AyaNova server itself, you are using SQL Server to host the AyaNova database - correct?

2. On the server itself, are you able to log into the AyaNova SQL database using the locally installed AyaNova program? - confirm this as the AyaNova.exe.config previously sent to me indicates use of the stand-alone default configuration which is conflicting information

3. From your post above, Server=localhost is being used - what is the IP address of the server where the database resides, and what is the actual servername for this server where the AyaNova SQL database resides

3. Zip up a copy of the server's AyaNova.exe.config file and attach labeled SQLserverAyaNova.exe.config.zip

4. I understand from your last post that you can not connect to the SQL Server database from a local networked computer?

5. What is the exact message you receive from a local network computer when you attempt to run the AyaNova program connecting to the AyaNova SQL database?

6. Zip up a copy of this local networked computers AyaNova.exe.config and name it localnetworkAyaNova.exe.config

7. Has an exception for sqlserver.exe on the server been set as per topichttp://forum.ayanova.com/Topic792-90-1.aspx

Please provide all information requested above.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

AyaNova Sales & Technical Support

http://www.ayanova.com