EN Ikoula wiki - User contributions [en]

Test

2015-12-11T09:19:13Z

Jdossantos1972b:

[[:he:מבחן]][[he:מבחן]]
[[:ru:Тест]][[ru:Тест]]
[[:ja:テスト]][[ja:テスト]]
[[:ar:اختبار]][[ar:اختبار]]
[[:zh:测试]][[zh:测试]]
[[:ro:Testul]][[ro:Testul]]
[[:pl:Badania]][[pl:Badania]]
[[:de:Test]][[de:Test]]
[[:nl:Test]][[nl:Test]]
[[:it:Prova]][[it:Prova]]
[[:pt:Teste]][[pt:Teste]]
[[:es:Prueba]][[es:Prueba]]
[[:fr:Test]][[fr:Test]]
 

This article has been created by an automatic translation software. You can view the article source [[:fr:Test|here]]. 

Hello World, this is a simple test.
<comments />

How to change the OS of its FLEX Server

2015-11-06T16:12:03Z

Jdossantos1972b:

[[:ro:Cum de a schimba sistemul de operare al FLEX Server]][[ro:Cum de a schimba sistemul de operare al FLEX Server]]
[[:pl:Jak zmienić OS jego serwer FLEX]][[pl:Jak zmienić OS jego serwer FLEX]]
[[:de:Das OS seines FLEX-Servers ändern]][[de:Das OS seines FLEX-Servers ändern]]
[[:nl:Het wijzigen van de OS van de FLEX-Server]][[nl:Het wijzigen van de OS van de FLEX-Server]]
[[:it:Come cambiare il sistema operativo del proprio Server FLEX]][[it:Come cambiare il sistema operativo del proprio Server FLEX]]
[[:pt:Como mudar o sistema operacional do seu servidor FLEX]][[pt:Como mudar o sistema operacional do seu servidor FLEX]]
[[:es:Cómo cambiar el sistema operativo de su servidor FLEX]][[es:Cómo cambiar el sistema operativo de su servidor FLEX]]
[[:fr:Comment changer l'OS de son serveur FLEX]][[fr:Comment changer l'OS de son serveur FLEX]]
 

This article has been created by an automatic translation software. You can view the article source [[:fr:Comment changer l'OS de son serveur FLEX|here]]. 

You want to change the OS of your [https://express.ikoula.com/fr/serveur-virtuel Virtual Server (VPS)].

To change the operating system of your server, you need to go on your client interface :

URL : https://order.ikoula.com/cp

You log in and you go to the tab "Account " Then :

- You click on "Subscriptions "

- You click on the concerned delivery "****HPV ******.ikoula.com"

- On the right click on "Software "

You arrive on the OS list. You select the desired OS and you confirm.

[[Category:FLEX]]
 
<comments />

Creating SQL with Storage 2012R2 iSCSI cluster

2015-10-08T15:46:11Z

Jdossantos1972b:

[[:nl:SQL maken met opslag 2012R2 iSCSI-cluster]][[nl:SQL maken met opslag 2012R2 iSCSI-cluster]]
[[:it:Creazione di SQL con cluster di iSCSI Storage 2012R2]][[it:Creazione di SQL con cluster di iSCSI Storage 2012R2]]
[[:pt:Criação de SQL com cluster de iSCSI Storage 2012R2]][[pt:Criação de SQL com cluster de iSCSI Storage 2012R2]]
[[:es:Creación de SQL con almacenamiento 2012R2 iSCSI del racimo]][[es:Creación de SQL con almacenamiento 2012R2 iSCSI del racimo]]
[[:fr:Creation cluster SQL avec Storage iSCSI sur 2012R2]][[fr:Creation cluster SQL avec Storage iSCSI sur 2012R2]]
 

This article has been created by an automatic translation software. You can view the article source [[:fr:Creation cluster SQL avec Storage iSCSI sur 2012R2|here]]. 

[[:de:Erstellen von SQL mit Storage 2012R2 iSCSI cluster]][[de:Erstellen von SQL mit Storage 2012R2 iSCSI cluster]]
[[:fr::de:Erstellen von SQL mit Storage 2012R2 iSCSI cluster]][[:fr:de:Erstellen von SQL mit Storage 2012R2 iSCSI cluster]]

== Problem ==
We want to mount a cluster SQL with a storage on a server accessible en iSCSI, all on servers in Windows 2012 R2.

== Debug ==

This platform requires 3 servers :
* 2 Windows 2012R2 wit SQL 2014 wit 5 ports Etherna (This number can be raced according to the needs ) : ServSQL01 and ServS02
* 1 Windows 2012R2 in storage server with 9 ports Etherna (This number can be retced according to the needs ) ServStor01

== Solution ==
In prerequisites, install Windows 2012 R2 on the 3 servers and it updates.
the two servers SQL must be on the same domain.

Diagram nawor "simplifie" platform (Th switchs are not present to monitor which is connected to what ) :



=== ServStor Server Configuration 01 ===

On this server we have 9 port naworks used.
1 dedicated to management.
2 x 4 dedicated ports to iSCSI.

[[File:schema_reseau_simple.PNG]]NIC1, NIC2 et NIC3 correspond to the three present networks cards, each with 4 ports gigabits.
(See diagram to identify the connections )

For the networ iSCSI, we will use a IP en 192.168.0.0/24
Here the IP configured on the server ServStor 01 :

NIC1 port 1 : Votre IP de votre serveur
NIC1 port 2 : Non utilisé
NIC1 port 3 : Non utilisé
NIC1 port 4 : Non utilisé

NIC2 Port 1 : 192.168.0.11
NIC2 Port 2 : 192.168.0.12
NIC2 Port 3 : 192.168.0.13
NIC2 Port 4 : 192.168.0.14

NIC3 Port 1 : 192.168.0.15
NIC3 Port 2 : 192.168.0.16
NIC3 Port 3 : 192.168.0.17
NIC3 Port 4 : 192.168.0.18


For all cards in 192.168.0.x will in the Advanced Settings tab DNS<pre>, and on the box unchec "</pre>Register this connection's addresses in DNS"



On the server ServStor01, it installs the rol iSCSI[[File:register_dns.PNG]] ''Target Server



In the Server Manager'', we will create disks [[File:roles_servstor01.PNG]]iSCSI (who are at the end of the) and t Target iSCSI that go them with :



It therefor :
* task / New iSCSI virtual disk
* Select the volume
* It gives it a name (one can notice its future path down )
* Choose the size in [[File:iSCSI_servstor01.PNG]]"Fixed Size" (Leave "Clear the virtual disk on allocation")
* One choos "New iSCSI Target"
* We give a name to this "iSCSI Target"
* Click on ADD in part "access Servers"
* In the choice of the method of identification of the initiator, soldarity bottom IP and put a IPIt will change it later.
* Leave CHAP et Reverse CHAP unchecke
* We finish by "Create" The "close" Once completed

From the, you have a shared disk en iSCSI.
Repeat the operation as many times as necessary.
In our case we create 3 discs :
* 1 for databases
* 1 for the logs
* 1 for th quorum (1GB will s)

=== Configuration iSCSI servers ServSQL 01 et 02 ===

In this part, we will connect the two servers SQL to the serve storage by links iSCSI.
We will use the MPIO in order to use ou 4 links networks and to share the load.

Configuration IP servers :

NIC1 et NIC2 correspond to the two network adapters on servers. NIC1 owns 4 ports, NIC2 a 2.
Here is the configura :

ServSQL01 :

NIC1 port 1 : 192.168.0.22
NIC1 port 2 : 192.168.0.26
NIC1 port 3 : IP Server
NIC1 port 4 : non utilisé

NIC2 port 1 : 192.168.0.25
NIC2 port 2 : 192.168.0.21

ServSQL02 :

NIC1 port 1 : 192.168.0.24
NIC1 port 2 : 192.168.0.28
NIC1 port 3 : IP du serveur
NIC1 port 4 : non utilisé

NIC2 port 1 : 192.168.0.27
NIC2 port 2 : 192.168.0.23
<pre>

For all cards in 192.168.0.x will in the Advanced Settings tab </pre>DNS<pre>, and on the box unchec "</pre>Register this connection's addresses in DNS"



* On both servers, installing the feature "Multipath I/O".

[[File:Register dns.PNG]]

* Once installed in the interface metro de 2012R2 (started so click ) just type "[[File:Feature_mpio.PNG]]MPIO" and click on the result :



* In the tab "Discover Multipaths" on coche [[File:Mpio.PNG]]"Add Support for iSCSI devices" then clicked on ADD. It proposes to restart, is done.
* Once restarted, it relaunches MPIO, and this ensures "MSFT2005iSCSIBusType_0x9" is present in the "device hardware id".

* It then launche "iSCSIinitiator " on both servers SQL
* One goes on the tab "Configuratio" and it retrieves t "Initiator Name" (the form "iqn.1991-05.com.microsoft:ServSQL01.domain.tld")
* It returns on the server ServSTOR 01
* In Server Manager, "File and storage Services", "iSCSI", right click on the Target then in initiators
* Clicked on ADD
* On coche "Enter a value for the selected type"
* One sets type "IQN" and we put the address found earlier on the server SQL.
* You click on OK, repeat the operation to add the "IQN" of the SQL on all the Targets
* Removing thIP It was previously put here.
* Once validated, it returns on our servers SQL, always in the iSCSI initiator, we go in the tab "Targets" and it connects to the server storage.
* We go in the tab "Favorite Targets", one on t Target visible then it mad remove.
* Returns the tab "Targets" then we go on properties for one of Target
* The switching off the current session, and then clicke Add Session. On coche Multipath, clicked on advanced. One choos "Microsoft iSCSI initiator". En initiator IP it chooses the first IP iSCSI du serveur SQL. En Target portal IP it chooses the first IP iSCSI Server of storage. It valid 2 times. Repeat the operation for each network adapter in passing to the ip following therefore.
In the end must be the IPs related to this form :

<table "1">
<tr>
<th>Initiator IPborder=
<th>Target Portal IP</th>
<th>On the server

<tr>
<th>192.168.0.21</th>
<th>192.168.0.11</th>
<th>ServSQL01</tr>
</th>
<tr>
<th>192.168.0.22</th>
<th>192.168.0.12</th>
<th>ServSQL01</tr>
</th>
<tr>
<th>192.168.0.23</th>
<th>192.168.0.13</th>
<th>ServSQL02</tr>
</th>
<tr>
<th>192.168.0.24</th>
<th>192.168.0.14</th>
<th>ServSQL02</tr>
</th>
<tr>
<th>192.168.0.25</th>
<th>192.168.0.15</th>
<th>ServSQL01</tr>
</th>
<tr>
<th>192.168.0.26</th>
<th>192.168.0.16</th>
<th>ServSQL01</tr>
</th>
<tr>
<th>192.168.0.27</th>
<th>192.168.0.17</th>
<th>ServSQL02</tr>
</th>
<tr>
<th>192.168.0.28</th>
<th>192.168.0.18</th>
<th>ServSQL02</tr>
</th>
</th>

* It returns in </th>"Favorite Targets</tr>" and you look at the details of these. We check that there are good relations with </table>IP in the preceding table.

=== Configuration o Failover servers ServSQL 01 et 02 ===

We begin by installing the feature Failover clustering on the 2 servers SQL.

During this time you can go in the disk management (right click on the me Windows, "disk management").
From here we pass disks in "online" and it initializes (GPT). It also created the partitions and formats it.

It then launche "Failover cluster Manager" and it po Validate Configuration to verify that everything is ok. Some warnings may be present at the network level.
Is then "Create cluster" :
* You enter the name of the two se SQL
* You enter the nam cluster, in our example we'll take clusterSQL01
* Leave "Add all eligible storage to the cluster" check
* It valid

Once created, down in "cluster core resources", we click right "ip address" / properties. One chooses ip du cluster. Then we redid right click on it and been "bring online"
You must now configure the quorum. To do this, you click on the na clusterand t "more actions" et "configure cluster quorum settings".
* Been next
* Select the quorum witness
* Configure a disk witness
* We check the corresponding disk to quorum
* been next The finish.
* The other two discs, it pointed "add to clustershared volume" 

We get the disc a logs volume 1 and the disc a BDD volume 2 in our case.

We now have a cluster configured.

=== Installation o SQL 2014 en cluster ===

We begin by VMSQL01

* It installs the feature .net 3.5
* We start the installation, choose "New SQL Server Failover cluster installation"



* The choice of features, in our case (future use with CRM 2015) Let's check [[File:Install_SQL1.PNG]]Database Engine Services, SQL Server Replication, Full-Text and Semantic Extractions for Search, reporting services, management Tools basic / complete
* Choose a network name for the SQL. In our case we will use SQLServ
* On cluster Disk Selection You can choose those you want to use. In our case, we take the cluster Disk 1 et 3 (le 2 being th quorum, le 1 et 2 being volumes databases et logs)
* It then chooses the ip du failover SQL
* We choose the accounts and passwords for services (in our case we have created dedicated services accounts )
* In part "Database engine Configuration" in our case we use the Mixed mode.
* Always in the same part in the tab Data Directories, you specify the database records (We therefore choose our volum iSCSI)
* For th reporting Services one p "Install & configure"
* It launches the Setup

If you encounter the following error during installation :



The following error has occurred:

Updating permission setting for folder 'C:\clusterstorage\Volume2' failed. The folder permission setting were supposed to be set to 'D:P(A;ERE;FA;;;BA)(A;ERE;FA;;;SY)(A;ERE;FA;;;CO)(A;ERE;FA;;;S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003)'.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: SQL<pre>%20Server&EvtSrc=Setup.rl&EvtID=50000&Collec=12.0.2000.8&EvtType=0x0ADF5303%25400xBB814387
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20


You should go in the volume concerned with Explorer windows</pre>to display the hidden files and protected system files and change the rights on the folder system volume information.

Once the intervention is finished, we go to VMSQL02.
* Installing th .net framework 3.5
* It launches the Setup with "Add a node to a SQL Server Failover cluster"



* It follows the steps, most being pre-filled
* It retyped passwords if necessary.
* It launches the Setup

Once the installation is complete, you have your SQL 2014 en [[File:Install_SQL2.PNG]]failover wit storage logged in iSCSI on a Windows 2012 R2.
You can make improvements, as a link between the 2 servers for the heartbeat for example, but it is optional.

 

[[Category:Windows]]

<comments />