Adding SQL LOB Target Error

Question

 Hi,

 I see remote server returned an error(401)unauthorized on completing wizard for adding SQL LOB Target. Its a fixed username on the server. /SBConnect has access to Allow all users and even the specific user

Even for a domain account, its the same unauthorized error

Thanks

Answer 1

Hi Sharath

Visual Studio must be opened with Administrative privileges to create and develop with the LOB adapters. Can you please confirm if you are already doing this?

Thanks
Neha

Answer 2

Hi,

I am using Service bus EAI and EDi Labs

when I am adding the LoB target by providing all the information like namespace ,credentials etc in UI and click create the  i got the following error

500

Code: '13'
Message: 'Error occurred while trying to bring up the relay service. Error Message: 'Unable to reach edilabs.servicebus.appfabriclabs.com via TCP (9351, 9352) or HTTP (80, 443)

Server Error in '/edilabs_orderprocessing_13' Application.

Unable to reach edilabs.servicebus.appfabriclabs.com via TCP (9351, 9352) or HTTP (80, 443)

 Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

 Exception Details:
System.ServiceModel.CommunicationException: Unable to reach edilabs.servicebus.appfabriclabs.com via TCP (9351, 9352) or HTTP (80, 443)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[CommunicationException: Unable to reach edilabs.servicebus.appfabriclabs.com via TCP (9351, 9352) or HTTP (80, 443)]
 Microsoft.ServiceBus.NetworkDetector.ChooseConnectivityModeForAutoDetect(Uri uri) +163
 Microsoft.ServiceBus.ConnectivityModeCache.GetConnectivityMode(Uri uri) +225
 Microsoft.ServiceBus.ConnectivityModeConnectionElement.CreateListener(Int32 bufferSize, Uri uri) +26
 Microsoft.ServiceBus.SocketConnectionTransportManager.OnOpen(TimeSpan timeout) +68
 Microsoft.ServiceBus.Channels.TransportManager.Open(TimeSpan timeout, TransportChannelListener channelListener) +450
 Microsoft.ServiceBus.Channels.TransportManagerContainer.Open(TimeSpan timeout, SelectTransportManagersCallback selectTransportManagerCallback) +215
 Microsoft.ServiceBus.Channels.TransportChannelListener.OnOpen(TimeSpan timeout) +80
 Microsoft.ServiceBus.Channels.ConnectionOrientedTransportChannelListener.OnOpen(TimeSpan timeout) +77
 Microsoft.ServiceBus.SocketConnectionChannelListener`2.OnOpen(TimeSpan timeout) +79
 System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) +318
 Microsoft.ServiceBus.Channels.LayeredChannelListener`1.OnOpen(TimeSpan timeout) +58
 System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) +318
 System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout) +72
 System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) +318
 System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout) +111
 System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) +318
 System.ServiceModel.Channels.CommunicationObject.Open() +36
 System.ServiceModel.HostingManager.ActivateService(String normalizedVirtualPath) +184
 System.ServiceModel.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath) +615

[ServiceActivationException: The service '/edilabs_orderprocessing_13/RuntimeService.svc' cannot be activated due to an exception during compilation. The exception message is: Unable to reach edilabs.servicebus.appfabriclabs.com via TCP (9351, 9352) or HTTP (80, 443).]
 System.Runtime.AsyncResult.End(IAsyncResult result) +679246
 System.ServiceModel.Activation.HostedHttpRequestAsyncResult.End(IAsyncResult result) +190
 System.ServiceModel.Activation.ServiceHttpModule.EndProcessRequest(IAsyncResult ar) +300622
 System.Web.AsyncEventExecutionStep.OnAsyncEventCompletion(IAsyncResult ar) +8837348

Version Information:
 Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1'.'

 

also this url "(edilabs.servicebus.appfabriclabs.com") is not accessible in browser

but when i use edilabs.servicebus.windows.net it is accessible

Please help

Answer 3

Hi Sharath,

pls ensure that the account used for runnig Vs is -

1. runnihg with elevated priviledges if UAC is enabled.

2. has access to - C:\Program Files\Microsoft ServiceBus Connect\SBConnect\ManagementService.svc

U can grant new users access to managemet servcie by-

1. granting acces to C:\Program Files\Microsoft ServiceBus Connect\SBConnect\ManagementService.svc

2. Adding the user to .net authorization rules  in IIS manger for SBconnect website.

---

Rohit Singh

Answer 4

Hi Obaid,

U have a namespace in live environment and u are trying to crate a relay in labs environemnt .

2 options -

1. create a namespace edilabs at https://portal.appfabriclabs.com/Default.aspx

OR

2. Create files

 [this will make your service bus environment point to the live environment, you can do this just for testing that relay creation works.

However it's not recommended as you won't be able to try oter features that are part of the current labs relaese.]

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\servicebus.config

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\servicebus.config

with following contents -

<configuration>

  <Microsoft.ServiceBus>

    <relayHostName>servicebus.windows.net</relayHostName>

    <stsHostName>accesscontrol.windows.net</stsHostName>

    <acmHostName>accesscontrol.windows.net</acmHostName>

  </Microsoft.ServiceBus>

</configuration>

---

Rohit Singh

Answer 5

Hi,

   If your machine is behind some proxy then you need to have ISA server firewall client. You can install that from here http://www.microsoft.com/en-us/download/details.aspx?id=10193

then restart visual studio and try again.

Thanks

Gyan

---

If this answers your question, please mark it as "Answered".

Answer 6

Hi Rohit/Neha,

 VS.NET is running using admin privileges, user has admin access to ManagementService. I see the following error now

500

Code: '13'
Message: 'Error occurred while trying to bring up the relay service. Error Message: 'The operation has timed out'.'

-Thanks,

Answer 7

Hi sharath,

The error seems to be relete to network access issue.

You need to ensure that the accout inder which the Appool of SBConnect service is running has acces to internet.

Some corporate policies require that the accout should be a domian account which is a sysadmin on local box.

Also, as pointed out by Gyan, you might have to install some firewall client software (eg ISA firewall client for forefront TMG),depending upon your firewall configuration.

---

Rohit Singh