RE: Server startup issue

Hi Jonny,

After that failure occurs(SSO fails to start due to remote SQL isn't
online), would you be able to manually start the service in Services mmc
after SQL server finished rebooting completely?

This appears to be a timing issue. It's expected that ENTSSO will fail to
start if it cannot reach master secret databases on SQL server. A work
around might be creating a scheduled task which contains the following
commands in a .cmd file to manually start BTS services after system
startup. Then set it to repeat every 5 mins or 10 mins in the task's
advanced property.

net start Entsso
net start btssvc$biztalkserverapplication
net start ruleengineupdateservice

How to Start, Stop, Pause, Resume, or Restart BizTalk Server Services
http://msdn.microsoft.com/en-us/library/aa559716.aspx

In this case, it will start the services when SQL becomes online. In case
the BTS services have alreay started, the commands will not do anything.

Furthermore I've seen a former case that ENTSSO fails to automatically
startup due to Windows firewall setting on BizTalk and SQL boxes. If
Windows firewall is enabled, you may temporarily disable it to test if the
problem no longer persists.

Please let me know if the information helps.

Have a nice week.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Tiger Stock
    ... a lot of money selling applications based on their own platform. ... larger players support more interfaces, ... Coming back to a point in the last paragraph: Lack of support for SQL ... So if we take that off the table and compare companies, ...
    (comp.databases.pick)
  • RE: SQL Set to System Account - Sharepoint Question
    ... Administration", not System Account) account. ... after the installation there isn't normally any reason to ... SQL, don't use an instance being used for anything else. ... the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Mobile and Datasets Problem
    ... About the database question, in the sql server 2005 table that is used to replicate with the mobile database, i put the flag rowguid to false in the uniqueidentifier primary key. ... Can i use the sql server 2005 tables for RDA replication without any identity columns defined? ... If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services so that a dedicated Support Professional can work with you in a more timely and efficient manner. ...
    (microsoft.public.sqlserver.replication)
  • Re: sqlstring -- a library to build a SELECT statement
    ... > short-circuiting behaviors regarding them (the resultant bytecode will ... How to best add further sql function support? ... > database does not support a given function (or operator, ... > case-insensitive in MS SQL Server but case-sensitive in PostgreSQL). ...
    (comp.lang.python)
  • RE: How to relate a SQL based entity with an Object based entity in Entity Framework
    ... As for "mixing the SQL and Non-SQL. ... The ADO.NET entity framework and EDM mainly focus on the object mapping ... between code level and backend database source. ... support some class/objects mapping to non-database source, ...
    (microsoft.public.dotnet.framework.aspnet)