none
Problem registrering Azure Data Sync Agent RRS feed

  • Question

  • Hi,

    I have problem registrering my Azure Data Sync Agent on my server running: Windows Server 2008 R2 Standard x64, Microsoft SQL Server 2008 R2 and Azure Data Sync Agent Preview. I get the error message below. After rebooting the server several times I suddenly managed to registrer the agent yesterday, and also choose which tables to sync. But then Azure started to provision the agent. I waited for about 15 hours and then I deleted my sync group. I tried to reregister the agent, but then I got the same error as below. I reinstalled the Sync Agent locally but I keep getting the same error. I have tried to run DeprovisioningUtil locally but it says the there are no tables to delete.

    Questions 1: Why can't I connect/register my local Azure Sync Agent (see error below)? (it worked once, so the problem should not be system clock or proxy/firewall issue)

    Question 2: How can I manually delete the "on-premise" agent that is created in Azure without connecting to the local agent?

    Best Regards,
    Ola Westerholm

    LocalAgentHost 1/9/2012 7:33:10 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.PingDss()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.GetAgentStateInfo(),', methodName:ClientUXService.GetAgentStateInfo, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'
    LocalAgentHost 1/9/2012 7:33:11 AM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, methodName:ClientUXService.CheckAgentKeyIsWellFormed, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.
    LocalAgentHost 1/9/2012 7:33:11 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.PingDss()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.GetAgentStateInfo(),', methodName:ClientUXService.GetAgentStateInfo, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'
    LocalAgentHost 1/9/2012 7:33:24 AM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, methodName:ClientUXService.CheckAgentKeyIsWellFormed, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.
    LocalAgentHost 1/9/2012 7:33:24 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.PingDss()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.GetAgentStateInfo(),', methodName:ClientUXService.GetAgentStateInfo, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'
    LocalAgentHost 1/9/2012 7:33:26 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.Security.MessageSecurityException,Message=An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail.,Source=mscorlib,StackTrace=
    Server stack trace:
       at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.ProcessReply(Message reply, SecurityProtocolCorrelationState correlationState, TimeSpan timeout)
       at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
       at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

    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 Microsoft.SqlAzureDataSync.LocatorServiceApi.ILocatorAgentServiceApi.GetScaleUnitForAgent()
       at Microsoft.SqlAzureDataSync.LocatorServiceApi.LocatorServiceAgentProxy.<>c__DisplayClass1.<GetScaleUnitForAgent>b__0()
       at Microsoft.SqlAzureDataSync.ClientServerCommon.ClientProxyBase`1.ExecuteRequest(Action serviceCall)
       at Microsoft.SqlAzureDataSync.LocatorServiceApi.LocatorServiceAgentProxy.GetScaleUnitForAgent()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.AgentConfigDataManager.DownloadAndCacheServiceUrisFromLocator(Guid agentId, String agentKey),'
    'Type=System.ServiceModel.FaultException,Message=An error occurred when verifying security for the message.,Source=,StackTrace=,', methodName:AgentConfigDataManager.DownloadAndCacheServiceUrisFromLocator, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.Security.MessageSecurityException,'
    'Type=System.ServiceModel.FaultException,', eMessage:'Message=An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail.,'
    'Message=An error occurred when verifying security for the message.,'
    LocalAgentHost 1/9/2012 7:33:26 AM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, methodName:ClientUXService.CheckAgentKeyIsWellFormed, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.
    LocalAgentHost 1/9/2012 7:33:26 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.SubmitAgentKey(String agentIdKey),', methodName:ClientUXService.SubmitAgentKey, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.Security.MessageSecurityException,Message=An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail.,Source=mscorlib,StackTrace=
    Server stack trace:
       at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.ProcessReply(Message reply, SecurityProtocolCorrelationState correlationState, TimeSpan timeout)
       at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
       at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

    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 Microsoft.SqlAzureDataSync.LocatorServiceApi.ILocatorAgentServiceApi.GetScaleUnitForAgent()
       at Microsoft.SqlAzureDataSync.LocatorServiceApi.LocatorServiceAgentProxy.<>c__DisplayClass1.<GetScaleUnitForAgent>b__0()
       at Microsoft.SqlAzureDataSync.ClientServerCommon.ClientProxyBase`1.ExecuteRequest(Action serviceCall)
       at Microsoft.SqlAzureDataSync.LocatorServiceApi.LocatorServiceAgentProxy.GetScaleUnitForAgent()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.AgentConfigDataManager.DownloadAndCacheServiceUrisFromLocator(Guid agentId, String agentKey),'
    'Type=System.ServiceModel.FaultException,Message=An error occurred when verifying security for the message.,Source=,StackTrace=,', methodName:AgentConfigDataManager.DownloadAndCacheServiceUrisFromLocator, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.Security.MessageSecurityException,'
    'Type=System.ServiceModel.FaultException,', eMessage:'Message=An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail.,'
    'Message=An error occurred when verifying security for the message.,'
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, methodName:ClientUXService.CheckAgentKeyIsWellFormed, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.SubmitAgentKey(String agentIdKey),', methodName:ClientUXService.SubmitAgentKey, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, methodName:ClientUXService.CheckAgentKeyIsWellFormed, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.PingDss()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.GetAgentStateInfo(),', methodName:ClientUXService.GetAgentStateInfo, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, methodName:ClientUXService.CheckAgentKeyIsWellFormed, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.
    LocalAgentHost 1/9/2012 7:33:28 AM  id:LocalAgentHost_Exception, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Error, agentId:00000000-0000-0000-0000-000000000000, agentIstanceId:4bd62c5d-7cbe-46a4-a015-6fd3e5a80f9f, version:1.1.109.0, e:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,Source=LocalAgentHost,StackTrace=   at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.ThrowFaultExceptionAndSetAgentState(String callerMethodName, ClientAgentError errorType, String errorMsgResourceId, TraceLevel traceLevel)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.CheckAgentKeyIsWellFormed()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.PingDss()
       at Microsoft.SqlAzureDataSync.LocalAgentHost.ClientUXService.GetAgentStateInfo(),', methodName:ClientUXService.GetAgentStateInfo, message:Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal., eType:'Type=System.ServiceModel.FaultException`1[[Microsoft.SqlAzureDataSync.CommonClientUtilLib.ClientAgentException, Microsoft.SqlAzureDataSync.CommonClientUtilLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91]],', eMessage:'Message=Please enter a valid agent key to proceed. The key must be generated from Azure Sync Service web portal.,'

    Monday, January 9, 2012 11:15 AM

Answers

  • Hello Owdev,

    From the exception, it looks like the agent key that you have entered is Invalid. The agent key being submitted is not the most recent; you may have regenerated a newer key on Azure Sync portal. Try regenerating on web portal and resubmitting.

    Monday, January 9, 2012 6:35 PM

All replies

  • Hi, 

    Can you open this site from your browser on the server? : https://locator.sync.azure.com/LocatorServiceApi.svc

    If not - then it's related to firewall/proxy settings. If you can see it - let me know and I'll try to help you further.

    Regards,

    Ira Bell

     


    -Ira Bell
    • Proposed as answer by Sandip Shinde Monday, January 9, 2012 5:28 PM
    Monday, January 9, 2012 4:59 PM
  • Hello Owdev,

    From the exception, it looks like the agent key that you have entered is Invalid. The agent key being submitted is not the most recent; you may have regenerated a newer key on Azure Sync portal. Try regenerating on web portal and resubmitting.

    Monday, January 9, 2012 6:35 PM
  • Hi,

    I have problem registering my Azure Data Sync Agent on my on-premise server running: Windows Server 2008 R2 Enterprise x86, Microsoft SQL Server 2008 R2 and Azure Data Sync Agent Preview. I get the message below.

    ------------------------
    Connection failed. Please check database credentials along with permissions for Local Sync Service logon account to connect to database with specified credentials.

    Other reasons for failure:

    SQL Azure databases have to be added on the Azure Sync Service portal.
    SQL Server databases lower than SQL Server 2005 SP2 are not supported on the Azure Sync Service.
    ---------------------------

    1. I can connect to my on-premise sql server database with same specified credentials (SQL and Windows authentication) but can not connect in Azure Data Sync Agent. I tried both authentication - SQL & Windows but same message.

    2. I already submit agent key and Ping sync service is also successfully pinged, so Agent is configured successfully.

    3. As per above message my database is also higher then SQL Server 2005 SP2 so this is not happen in my case.

    SO PLEASE HELP ME TO SOLVE THIS ISSUE.

    Monday, May 7, 2012 2:49 PM
  • Hi,

    I have problem registering my Azure Data Sync Agent on my on-premise server running: Windows Server 2008 R2 Enterprise x86, Microsoft SQL Server 2008 R2 and Azure Data Sync Agent Preview. I get the message below.

    ------------------------
    Connection failed. Please check database credentials along with permissions for Local Sync Service logon account to connect to database with specified credentials.

    Other reasons for failure:

    SQL Azure databases have to be added on the Azure Sync Service portal.
    SQL Server databases lower than SQL Server 2005 SP2 are not supported on the Azure Sync Service.
    ---------------------------

    1. I can connect to my on-premise sql server database with same specified credentials (SQL and Windows authentication) but can not connect in Azure Data Sync Agent. I tried both authentication - SQL & Windows but same message.

    2. I already submit agent key and Ping sync service is also successfully pinged, so Agent is configured successfully.

    3. As per above message my database is also higher then SQL Server 2005 SP2 so this is not happen in my case.

    SO PLEASE HELP ME TO SOLVE THIS ISSUE.

    Monday, May 7, 2012 2:50 PM
  • Hi,

    I have problem registering my Azure Data Sync Agent on my on-premise server running: Windows Server 2008 R2 Enterprise x86, Microsoft SQL Server 2008 R2 and Azure Data Sync Agent Preview. I get the message below.

    ------------------------
    Connection failed. Please check database credentials along with permissions for Local Sync Service logon account to connect to database with specified credentials.

    Other reasons for failure:

    SQL Azure databases have to be added on the Azure Sync Service portal.
    SQL Server databases lower than SQL Server 2005 SP2 are not supported on the Azure Sync Service.
    ---------------------------

    1. I can connect to my on-premise sql server database with same specified credentials (SQL and Windows authentication) but can not connect in Azure Data Sync Agent. I tried both authentication - SQL & Windows but same message.

    2. I already submit agent key and Ping sync service is also successfully pinged, so Agent is configured successfully.

    3. As per above message my database is also higher then SQL Server 2005 SP2 so this is not happen in my case.

    SO PLEASE HELP ME TO SOLVE THIS ISSUE.

    Monday, May 7, 2012 2:50 PM