{"id":78,"date":"2013-05-14T22:33:00","date_gmt":"2013-05-14T20:33:00","guid":{"rendered":"http:\/\/release-yourself.net\/?p=78"},"modified":"2013-06-19T15:00:55","modified_gmt":"2013-06-19T13:00:55","slug":"installation-vcenter-5-1-u1-partie-7-creation-dsn-vum","status":"publish","type":"post","link":"https:\/\/www.release-yourself.net\/?p=78","title":{"rendered":"Installation vCenter 5.1 U1: Partie 7 (Cr\u00e9ation DSN VUM)"},"content":{"rendered":"<p style=\"text-align: justify;\">Dans ce chapitre nous allons cr\u00e9er le connecteur ODBC vers la base de donn\u00e9e pour Vmware Update Manager (VUM). Nous allons reprendre le m\u00eame script que pour le connecteur vers la base de vCenter en le modifiant pour atteindre la base VUM.<\/p>\n<h2 style=\"text-align: justify;\">Cr\u00e9ation du DSN pour VUM<\/h2>\n<p style=\"text-align: justify;\">La premi\u00e8re \u00e9tape pour installer VUM est de cr\u00e9er le connecteur ODBC vers la base de donn\u00e9e VUM. A la diff\u00e9rence du vCenter, qui utilise un DSN en 64 bits, VUM utilise un DSN en 32 bits. Le script Powershell pr\u00e9c\u00e9dent (celui pour vCenter) a \u00e9t\u00e9 modifi\u00e9 pour en cr\u00e9er un en DSN 32 bits. Le script se nomme VUM-DSN.ps1. le script requi\u00e8re 3 arguments:<!--more--><\/p>\n<ul>\n<li><span style=\"line-height: 15px;\">le nom FQDN du serveur SQL<\/span><\/li>\n<li>le nom de la base de donn\u00e9e VUM<\/li>\n<li>la version de SQL (2012 ou 2008)<\/li>\n<\/ul>\n<p>1. Sauvegardez le script Powershell ci dessous et ex\u00e9cutez le dans une console Powershell avec les privil\u00e8ges administrateur<\/p>\n<p>Exemple: .\\VUM-DSN.ps1 \u00ab\u00a0sql01.test.local\u00a0\u00bb \u00ab\u00a0DB_VUM_Server\u00a0\u00bb 2008<\/p>\n<pre>## Creates a 32-bit System DSN for VMware Update Manager.\r\n## Supports SQL Server 2008(R2) and SQL 2012\r\n$DSNName = $args[1]\r\n$DBName = $args[1]\r\n\r\nIf($args[0] -eq $NULL) { echo \"Must specify FQDN of SQL server.\"; Exit}\r\nIf($args[1] -eq $NULL) { echo \"Must specify VUM Database name.\"; Exit}\r\nIf($args[2] -eq $NULL) { echo \"Must specify SQL Version (2008 or 2012)\"; Exit}\r\nif($args[3] -eq \"encrypt\") { $Encrypt = \"Yes\" } Else { $Encrypt = \"No\" }\r\n\r\n$HKLMPath1 = \"HKLM:\\SOFTWARE\\Wow6432Node\\ODBC\\ODBC.INI\\\" + $DSNName\r\n$HKLMPath2 = \"HKLM:\\SOFTWARE\\Wow6432Node\\ODBC\\ODBC.INI\\ODBC Data Sources\"\r\nmd $HKLMPath1 -ErrorAction silentlycontinue\r\n\r\nset-itemproperty -path $HKLMPath1 -name Description -value $DSNName\r\nset-itemproperty -path $HKLMPath1 -name Server -value $args[0]\r\nset-itemproperty -path $HKLMPath1 -name LastUser -value \"Administrator\"\r\nset-itemproperty -path $HKLMPath1 -name Trusted_Connection -value \"Yes\"\r\nset-itemproperty -path $HKLMPath1 -name Encrypt -value $Encrypt\r\nset-itemproperty -path $HKLMPath1 -name Database -value $DBName\r\nmd $HKLMPath2 -ErrorAction silentlycontinue\r\n\r\nif ($args[2] -eq 2008) {\r\nset-itemproperty -path $HKLMPath2 -name \"$DSNName\" -value \"SQL Server Native Client 10.0\"\r\nset-itemproperty -path $HKLMPath1 -name Driver -value \"C:\\WINDOWS\\system32\\sqlncli10.dll\"\r\n}\r\n\r\nElse {\r\nset-itemproperty -path $HKLMPath2 -name \"$DSNName\" -value \"SQL Server Native Client 11.0\"\r\nset-itemproperty -path $HKLMPath1 -name Driver -value \"C:\\WINDOWS\\system32\\sqlncli11.dll\"\r\n}<\/pre>\n<p>2. Une fois le script ex\u00e9cut\u00e9, vous pouvez v\u00e9rifier le connecteur dans Source de donn\u00e9e ODBC de Windows.<\/p>\n<p>3. Comme pour le connecteur ODBC vCenter, cliquez sur Configure et faites Next jusqu&rsquo;\u00e0 la fin pour pouvoir faire un test de connexion<\/p>\n<p><a href=\"http:\/\/release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-207 aligncenter\" alt=\"DSNVUM1\" src=\"http:\/\/release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM1-290x300.png\" width=\"290\" height=\"300\" srcset=\"https:\/\/www.release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM1-290x300.png 290w, https:\/\/www.release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM1.png 365w\" sizes=\"(max-width: 290px) 100vw, 290px\" \/><\/a><\/p>\n<p>4. Cliquez sur Test Data Source pour valider le fonctionnement. Si vous avez le m\u00eame r\u00e9sultat que ci dessous c&rsquo;et que tout est OK<\/p>\n<p><a href=\"http:\/\/release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-208 aligncenter\" alt=\"DSNVUM2\" src=\"http:\/\/release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM2-291x300.png\" width=\"291\" height=\"300\" srcset=\"https:\/\/www.release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM2-291x300.png 291w, https:\/\/www.release-yourself.net\/wp-content\/uploads\/2013\/05\/DSNVUM2.png 364w\" sizes=\"(max-width: 291px) 100vw, 291px\" \/><\/a><\/p>\n<p>F\u00e9licitation, vous \u00eates pr\u00eat maintenant \u00e0 installer le r\u00f4le VUM.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans ce chapitre nous allons cr\u00e9er le connecteur ODBC vers la base de donn\u00e9e pour Vmware Update Manager (VUM). Nous allons reprendre le m\u00eame script que pour le connecteur vers la base de vCenter en le modifiant pour atteindre la &hellip; <a href=\"https:\/\/www.release-yourself.net\/?p=78\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[17],"class_list":["post-78","post","type-post","status-publish","format-standard","hentry","category-vmware","tag-vum"],"_links":{"self":[{"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts\/78"}],"collection":[{"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":8,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":256,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions\/256"}],"wp:attachment":[{"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}