So the SQL:
Do you have all connection types enabled? (tcp/ip etc)
and is browser service enabled and started? (so remote connections work properly)
the username / password properly set? (maybe try and re-apply them properly).
yes, all fine, that's the thing, that remote ms sql server has run fine from Websitepanel for 2 years....
Is there a debug log somewhere for the call?
in 2 years there has been about 2000 commits with code changes, database changes and so on.
Some migrations are more smooth then others, but i can confirm all of them are easily do-able. (i even migrated some very large DNP (DotNetPanel) environments over to SolidCP in the past few months)
along as you look at it from the "current" perspective. in all honesty in troubleshooting the history can at most give clues to issues, but they never provide the solution.
application log error has shown now, showing from the master server:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 02/09/2016 01:40:45
Event time (UTC): 02/09/2016 00:40:45
Event ID: 52b519ab8eb64748b10550d9c06af648
Event sequence: 11
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/ROOT-1-131172503190745550
Trust level: Full
Application Virtual Path: /
Application Path: C:WebsitePanelServer
Machine name: MSSQLUK5
Process information:
Process ID: 4260
Process name: w3wp.exe
Account name: MSSQLUK5WPServer
Exception information:
Exception type: ArgumentException
Exception message: ' ', hexadecimal value 0x1D, is an invalid character.
at System.Xml.XmlConvert.VerifyCharData(String data, ExceptionType invCharExceptionType, ExceptionType invSurrogateExceptionType)
at System.Xml.DocumentXmlWriter.WriteString(String text)
at System.Xml.XmlWellFormedWriter.WriteString(String text)
at System.Web.Services.Protocols.Soap11ServerProtocolHelper.WriteFault(XmlWriter writer, SoapException soapException, HttpStatusCode statusCode)
at System.Web.Services.Protocols.SoapServerProtocol.WriteException(Exception e, Stream outputStream)
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
at System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type type, HttpContext context, HttpRequest request, HttpResponse response)
Request information:
Request URL: http://10.26.0.123:9003/AutoDiscovery.asmx
Request path: /AutoDiscovery.asmx
User host address: 10.26.0.102
User:
Is authenticated: False
Authentication Type:
Thread account name: MSSQLUK5WPServer
Thread information:
Thread ID: 15
Thread account name: MSSQLUK5WPServer
Is impersonating: False
Stack trace: at System.Xml.XmlConvert.VerifyCharData(String data, ExceptionType invCharExceptionType, ExceptionType invSurrogateExceptionType)
at System.Xml.DocumentXmlWriter.WriteString(String text)
at System.Xml.XmlWellFormedWriter.WriteString(String text)
at System.Web.Services.Protocols.Soap11ServerProtocolHelper.WriteFault(XmlWriter writer, SoapException soapException, HttpStatusCode statusCode)
at System.Web.Services.Protocols.SoapServerProtocol.WriteException(Exception e, Stream outputStream)
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
at System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type type, HttpContext context, HttpRequest request, HttpResponse response)
Custom event details:
date/time setting issue ?
