Production web server on non-domain machine
I've read the deployment documentation, and understand and have successfully setup a site on a domain machine with a remote database.
However, I'm setting up on a web server that is a stand alone machine, and I'm not smart enough to get past the authentication part. I keep getting the following:
[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.] System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +1734594 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +826 Microsoft.CommerceServer.Internal.Orders.MtsHelper.ExecuteSqlCommandDataSet(String connStr, String commandText, CommandType commandType, ArrayList sqlParameterHelpers, Int32 timeout) +0 Microsoft.CommerceServer.Runtime.Orders.DetailedSqlTableInformation..ctor(String TableName, String ConnectionString, Int32 timeout) +175 I know I'll need to use sql authentication, but not sure where to actually configure. I've configured strings in Commerce Server Manager, but no joy. Any help greatly appreciated.thanksgene
[1437 byte] By [McPadawan] at [2008-1-9] 