![]() ![]() Make sure that you have installed Microsoft. It’s now possible to open an Azure file share seamlessly : Run -> \\.net\sql-data Log off and Login with the new service user account “sqldataonazure”. In my domain I create a user named “sqldataonazure” and the access key as password:Īfterwards, log on to the VM where you plan to install the SQL Server and add the newly created user to the local Administrators group: ![]() But you can work around this restriction by creating a user in your domain with the name and password written down in the previews step. Unfortunately, you cannot add users to Azure Files. To enable seamless access of the Azure file shares by your SQL Server, the SQL Server process has to run with a service account known by Azure Files. Please note the username (sqldataonazure) and the access key for the next step. The storage account access key is retrievable at storage account level -> All settings -> Access keys ->key1 (or key2) Net use \\.net\sql-data /u:sqldataonazure To map an Azure file share, click on (e.g.) “sql-data” -> connect and you will see a net use command: Then I create 4 Azure File Shares with a quota of up to 1024 GB named: I create a new standard storage account named “sqldataonazure” in the same region as my SQL Server VM (use a least a D2v2 sized VM): If you use an existing storage account, ensure that the account can handle an additional 4000 IOPS). Prepare the storageĬreate a new storage account in Azure or use an existing one (please note: A storage account can handle up to 20000 IOPS. Use Azure Files as a network share instead of disks Use Azure premium storage disks attached to the virtual SQL Server Limited to 500 IOPS on a standard VM size per Disk.Use Azure standard disks attached to the virtual SQL Server In Azure I have three different approaches: In the data center world, I have now to deal with different RAID configurations or have to use an enterprise storage. In this case I needed to have a native Microsoft SQL Server 2014 in Azure (SQL as a service was not an option in this case ).īut how do you configure an SQL Server in regard to the disks? It´s best practice to have a single disk for each of the following: Know this beforehand: I’m not a Microsoft SQL Server professional, but sometimes I have to install and configure a SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |