edm - Monday, December 8, 2008 5:24 PM:
Hi,
I'm testing Innovator Server 9.0.1 on two virtual machines. They both worked fine with local sql server express 2005. Now I want VM1 to connect to the database on VM2. So I changed the line of InnovatorServerConfig.xml of VM1 from
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)SQLEXPRESS" uid="innovator" pwd="innovator" dbType="SQL Server" />
to
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="192.168.1.2" uid="innovator" pwd="innovator" dbType="SQL Server" />
I can use SQL Management Studio Express from VM1 to connect to the sql server express on VM2. So the network config should be fine.
But when I tried to login, a SOAP Error window popped up: "Unexpected Server Side Error Occurred". I closed this window and another error window popped up:
*** Wrong SOAP message!*** Error:
Server Error in '/InnovatorServer/Server' Application.
ErrorCode:-1072896766 Reason: A string literal was expected, but no opening quote character was found.
It worked with SQL Server 2008 trial as the remote database. But I really want to use SQL Server Express 2005.
Can anyone tell me how to work around this?
Thanks.
Andy - Monday, December 8, 2008 6:17 PM:
I did not know SQL Server Express could support remote connections.
Did you try the instance name, rather then the ipaddress?
edm - Tuesday, December 9, 2008 9:48 AM:
SQL Server Express should support remote connections as it accepts remote SQL Server Management Studio Express connections.
I put a line : "192.168.10.2 aras2" in /windows/system32/driver/etc/hosts and tried 'server="aras2"' and 'server="aras2SQLEXPRESS"' in InnovatorServerConfig.xml ending up with the same error.
Any idea?
Thanks.
Srinivas - Friday, July 23, 2010 2:50 AM:
Hi, I am facing similar kind of issue . Did you get rootcause or fix for the same?
