{"id":71,"date":"2013-05-14T22:30:30","date_gmt":"2013-05-14T20:30:30","guid":{"rendered":"http:\/\/release-yourself.net\/?p=71"},"modified":"2013-06-19T14:59:50","modified_gmt":"2013-06-19T12:59:50","slug":"installation-vcenter-5-1-u1-partie-3-creation-des-bases-de-donnees-vcenter-et-vum","status":"publish","type":"post","link":"https:\/\/www.release-yourself.net\/?p=71","title":{"rendered":"Installation vCenter 5.1 U1: Partie 3 (Cr\u00e9ation des bases de donn\u00e9es vCenter et VUM)"},"content":{"rendered":"

La base de donn\u00e9e est la premi\u00e8re chose \u00e0 faire avant d’installer vCenter. La premi\u00e8re \u00e9tape de l’installation de vCenter est la d\u00e9finition de la base de donn\u00e9e. J’ai donc pris le parti d’utiliser un serveur SQL pour h\u00e9berg\u00e9 la base. L’installation de vCenter propose aussi d’installer une base en local avec SQL Express.<\/p>\n

Cr\u00e9ation des bases de donn\u00e9es pour vCenter et VUM<\/h2>\n

1. Dans un premier temps, il faut installer le client SQL Native correspondant \u00e0 la version du serveur SQL. Dans mon exemple j’utilise SQL 2008 R2, Voici le lien<\/a> pour t\u00e9l\u00e9charger le client. Si vous utilisez SQL 2012, voici le lien<\/a> pour t\u00e9l\u00e9charger le client.<\/p>\n

2. Utilisez le compte de service sp\u00e9cifique \u00e0 vCenter qui a \u00e9t\u00e9 cr\u00e9\u00e9 \u00e0 la partie 1.<\/p>\n

3. Sur le serveur SQL, il convient maintenant de cr\u00e9er les bases de donn\u00e9es ainsi que les comptes de s\u00e9curit\u00e9 associ\u00e9s. Voici un script pour la cr\u00e9ation des bases et le changement du compte du service. Pensez \u00e0 modifier selon votre compte de service ainsi que l’emplacement des fichiers de base de donn\u00e9e.<\/p>\n

\/* Creates vCenter server and VUM databases. *\/\r\n\/* Change login name to vCenter service account *\/\r\n\r\nEXEC('CREATE LOGIN [test\\vcenterservice]FROM WINDOWS')\r\n\r\nUSE MSDB\r\nEXEC sp_grantdbaccess 'test\\vcenterservice'\r\nEXEC sp_addrolemember db_owner, 'test\\vcenterservice'\r\n\r\nUSE master\r\ncreate database \"DB_vCenter_Server\"\r\non\r\n( name = 'DB_vCenter_Server',\r\nfilename = 'K:\\Microsoft SQL Server\\MSSQL\\Data\\DB_vCenter_Server.mdf',\r\nsize = 2000MB,\r\nfilegrowth = 500MB )\r\nlog on\r\n( name = 'DB_vCenter_Server log',\r\nfilename = 'L:\\Microsoft SQL Server\\MSSQL\\Data\\Logs\\DB_vCenter_Server.ldf',\r\nsize = 200MB,\r\nfilegrowth = 20MB )\r\nCOLLATE SQL_Latin1_General_CP1_CI_AS;\r\n\r\ncreate database \"DB_vCenter_VUM\"\r\non\r\n( name = 'DB_vCenter_VUM',\r\nfilename = 'K:\\Microsoft SQL Server\\MSSQL\\Data\\DB_vCenter_VUM.mdf',\r\nsize = 250MB,\r\nfilegrowth = 25MB )\r\nlog on\r\n( name = 'DB_vCenter VUM_log',\r\nfilename = 'L:\\Microsoft SQL Server\\MSSQL\\Data\\Logs\\DB_vCenter_VUM.ldf',\r\nsize = 25MB,\r\nfilegrowth = 2MB )\r\nCOLLATE SQL_Latin1_General_CP1_CI_AS;\r\n\r\nEXEC('ALTER AUTHORIZATION ON DATABASE::\"DB_vCenter_Server\" TO [test\\vcenterservice]')\r\nEXEC('ALTER AUTHORIZATION ON DATABASE::\"DB_vCenter_VUM\" TO [test\\vcenterservice]')\r\n\r\nGO<\/pre>\n
Cr\u00e9ation du lien ODBC<\/h2>\n
Sur le serveur vCenter, il faut maintenant cr\u00e9er le lien ODBC. Soit vous le cr\u00e9ez via l’interface graphique, soit par un script Powershell. voici un exemple de script Powershell. Modifiez toutes valeurs pour correspondre \u00e0 votre environnement<\/p>\n
## Cr\u00e9e un DSN System pour vCenter.\r\n## Supporte SQL Server 2008(R2) et 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 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\\ODBC\\ODBC.INI\\\" + $DSNName\r\n$HKLMPath2 = \"HKLM:\\SOFTWARE\\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\n\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
Pour lancer le script, ouvrez une console Powershell en mode Administrateur et tapez la commande suivante<\/p>\n
.\\vCenter-DSN.ps1 \u00ab\u00a0FQDN du serveur SQL\u00a0\u00bb \u00ab\u00a0Nom de la base de donn\u00e9e\u00a0\u00bb \u00ab\u00a0Version SQL (2008 ou 2012)\u00a0\u00bb \u00ab\u00a0Encryption SQL (\u00e0 mettre seulement si la communication est crypt\u00e9 au niveau du SQL)\u00a0\u00bb<\/p>\n
Pour mon environnement cela a donn\u00e9 ceci:<\/p>\n
.\\vCenter-DSN.ps1 \u00ab\u00a0SQL01.test.local\u00a0\u00bb \u00ab\u00a0DB_vCenter_Server\u00a0\u00bb 2008<\/p>\n
Ouvrez le Source de Donn\u00e9es et cliquez sur l’onglet System DSN<\/p>\n
\"ODBC1\"<\/a><\/p>\n
 <\/p>\n
Cliquez sur Configure et faites Next jusqu’\u00e0 l’apparition de cette fen\u00e8tre<\/p>\n
\"ODBC2\"<\/a><\/p>\n
 <\/p>\n
Cliquez sur Test Data Source pour valider la connexion sur le serveur SQL<\/p>\n
\"ODBC3\"<\/a><\/p>\n
Si vous avez ce message c’est le connecteur a \u00e9t\u00e9 correctement cr\u00e9\u00e9. Maintenant la prochaine \u00e9tape, l’installation de vCenter<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
La base de donn\u00e9e est la premi\u00e8re chose \u00e0 faire avant d’installer vCenter. La premi\u00e8re \u00e9tape de l’installation de vCenter est la d\u00e9finition de la base de donn\u00e9e. J’ai donc pris le parti d’utiliser un serveur SQL pour h\u00e9berg\u00e9 la … Continuer la lecture →<\/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":[6,17],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-vmware","tag-vcenter","tag-vum"],"_links":{"self":[{"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts\/71"}],"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=71"}],"version-history":[{"count":12,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":251,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/251"}],"wp:attachment":[{"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.release-yourself.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}