BizTalk Server 2004 : B2B, EAI and .NET

Thursday, November 18, 2004

Getting the BizTalk SQL Server DB Name

A quick one. How to get the name of the SQL Server that BizTalk is running? A relatively easy way is to get it from the registry. Heres a code sippet that does just that.


string strBtsSvrSubKey =
"Software\\Microsoft\\BizTalk Server\\3.0\\Administration";
string strBtsSqlSvrKey = "MgmtDBServer";
Microsoft.Win32.RegistryKey key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(strBtsSvrSubKey);
string strBtsSqlSvrName = key.GetValue(strBtsSqlSvrKey).ToString();

Any queries, post a comment.

6 Comments:

  • The me is back. Since you insist that one has to have a query to post a comment, here's mine — How does one write creative comments on a blog without offending the author, who seems to take his geek-writing pretty seriously?

    A code snippet explaining the solution is, of course, always appreciated! :)

    By Blogger Megha, on December 06, 2004 3:17 PM  

  • i saw that debate between u and steve on the MS discussion boards about which was better. registry lookup or WMI? so which is it?

    By Anonymous Anonymous, on December 06, 2004 5:32 PM  

  • Hey nice blog

    By Anonymous Anonymous, on January 31, 2005 2:06 PM  

  • Informative blog. I have a counter xhtml blog.

    By Blogger Steve Austin, on October 02, 2005 11:29 AM  

  • Hey nice info you posted.
    I just browsing through some blogs and came across yours!

    Excellent blog, good to see someone actually uses em for quality posts.

    Your site kept me on for a few minutes unlike the rest :)

    Keep up the good work!

    Thanks!.

    By Anonymous Anonymous, on October 19, 2005 8:42 AM  

  • There is alot of Blogs, I never guessed I'd find some usefull information.

    Thanks.
    I'll be back later to see if anymore good updates are available.

    By Blogger banner ads, on October 25, 2005 7:57 PM  

Post a Comment