Re: Failed to contact the SSO database - Selva

[Sridhar Bharadwaj]

How was this problem solved?I encountered the same problem recently. My Biztalk server has been working fine from past 3 years and all of a sudden I am not able to bring up the SSO service on the app. When I log into DB and query SSO DB its fine. I checked all the ports between APP and DB server and everything looks fine. I tried DTCPing and it works fine. Any Ideas?

> On Wednesday, September 17, 2008 12:51 PM Selva wrote:

> Geeks,
>
> I am not able to start the ENTSSO service and it was working fine till
> yesterday.
> I got the following error on my event log
>
> Failed to contact the SSO database: System.Data : The type initializer for
> 'System.Data.SqlClient.SqlConnection' threw an exception.
> Data Source=XXXX;Integrated Security=SSPI;Initial Catalog=SSODB
>
> Error code: 0x800710D9, Unable to read from or write to the database.
>
>
> My system Spec is :
>
> Windows Server 2003 R2, SP2
> Biztalk 2006 R2
> SQL 2005 Installed on Remote computer
>
>
> Did you guys had any problem before like this?.
>
> Please advice!
>
> Thanks
> Selvan


>> On Wednesday, September 17, 2008 4:14 PM Selva wrote:

>> Dan,
>>
>> I am able to query the SSODB tables.
>>
>> Any idea what could went wrong?.
>>
>> Thanks
>> Selvan
>>
>> "Dan Rosanova" wrote:


>>> On Wednesday, September 17, 2008 8:38 PM Selva wrote:

>>> Yes, I am able to reach the database with my user id using SQL management
>>> studio.
>>>
>>> Thanks
>>> Selvan
>>>
>>> "Dan Rosanova" wrote:


>>>> On Wednesday, September 17, 2008 10:43 PM Dan Rosanova wrote:

>>>> Sounds like the SSO database could be in single user mode or locked.
>>>> Databases can get locked by DTC transactions so check on that. You
>>>> could try connecting to the SSODB and selecting from a table.\
>>>> Kind Regards,
>>>> -Dan


>>>>> On Wednesday, September 17, 2008 10:43 PM Dan Rosanova wrote:

>>>>> Your able to reach the database as the user that the ESSO service runs
>>>>> under?
>>>>> -Dan


>>>>>> On Thursday, April 16, 2009 4:32 PM Carmen Puccio wrote:

>>>>>> Did you ever get this resolved? I am having the EXACT same issue. It will not start after a reboot but afterwards, net start entsso works fine.