{"id":16061,"date":"2014-03-21T10:01:59","date_gmt":"2014-03-21T10:01:59","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=16061"},"modified":"2014-03-21T10:01:59","modified_gmt":"2014-03-21T10:01:59","slug":"scvmm-setting-up-remote-sql-database-is-hanging-or-failing","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=16061","title":{"rendered":"SCVMM \u2013 Setting Up Remote SQL Database Is Hanging Or Failing"},"content":{"rendered":"

If you are deploying lots of System Center products, then it\u2019s not uncommon to use a single SQL server\/cluster for one instance per component (Service Manager is a whole other ball of wax but I stay away from that game). This means setting up a remote SQL database for VMM<\/a>. It\u2019s no big deal, and it increases scalability for the truly large deployments. It also makes clustering VMM a realistic possibility \u2013 and that\u2019s a must-do if you\u2019re creating a cloud.<\/p>\n

\"image\"<\/a><\/p>\n

When at the above screen, the connection to the remote server to allow you to select an instance can freeze or fail if you have not configured the Windows Firewall of the remote SQL server<\/a>. Configure the firewall, and away you go.<\/p>\n

Note: the lazy and less secure method is to open the firewall completely. Don\u2019t do that if you can help it.<\/em><\/p>\n

Technorati Tags: Hyper-V<\/a>,System Center<\/a>,VMM<\/a>,SQL<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

If you are deploying lots of System Center products, then it\u2019s not uncommon to use a single SQL server\/cluster for one instance per component (Service Manager is a whole other ball of wax but I stay away from that game). This means setting up a remote SQL database for VMM. It\u2019s no big deal, and … Continue reading “SCVMM \u2013 Setting Up Remote SQL Database Is Hanging Or Failing”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[48],"tags":[181,192,193,196],"class_list":["post-16061","post","type-post","status-publish","format-standard","hentry","category-vmm","tag-hyper-v","tag-sql","tag-system-center","tag-vmm"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t