From owner-freebsd-virtualization@freebsd.org Tue Oct 25 18:19:07 2016 Return-Path: Delivered-To: freebsd-virtualization@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id E73ABC20D27 for ; Tue, 25 Oct 2016 18:19:07 +0000 (UTC) (envelope-from grehan@freebsd.org) Received: from alto.onthenet.com.au (alto.OntheNet.com.au [203.13.68.12]) by mx1.freebsd.org (Postfix) with ESMTP id AAF56E3B for ; Tue, 25 Oct 2016 18:19:07 +0000 (UTC) (envelope-from grehan@freebsd.org) Received: from iredmail.onthenet.com.au (iredmail.onthenet.com.au [203.13.68.150]) by alto.onthenet.com.au (Postfix) with ESMTPS id 3493420C1C18 for ; Wed, 26 Oct 2016 04:18:51 +1000 (AEST) Received: from localhost (iredmail.onthenet.com.au [127.0.0.1]) by iredmail.onthenet.com.au (Postfix) with ESMTP id 2EFA0280A40 for ; Wed, 26 Oct 2016 04:18:51 +1000 (AEST) X-Amavis-Modified: Mail body modified (using disclaimer) - iredmail.onthenet.com.au Received: from iredmail.onthenet.com.au ([127.0.0.1]) by localhost (iredmail.onthenet.com.au [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id A6piCWS7jNSg for ; Wed, 26 Oct 2016 04:18:51 +1000 (AEST) Received: from Peters-MacBook-Pro-2.local (96-82-80-65-static.hfc.comcastbusiness.net [96.82.80.65]) by iredmail.onthenet.com.au (Postfix) with ESMTPSA id 2AAB5280903; Wed, 26 Oct 2016 04:18:48 +1000 (AEST) Subject: Re: Installing SQL Server on Windows 2012 bhyve guests To: Randy Terbush References: From: Peter Grehan Cc: freebsd-virtualization@freebsd.org Message-ID: <212f161a-d2d1-d164-3910-eeb256ae68ec@freebsd.org> Date: Tue, 25 Oct 2016 11:18:59 -0700 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-CMAE-Score: 0 X-CMAE-Analysis: v=2.2 cv=Jq6BlIwC c=1 sm=1 tr=0 a=A6CF0fG5TOl4vs6YHvqXgw==:117 a=mwgbnDbW7alINpy3vhoKyg==:17 a=N659UExz7-8A:10 a=CH0kA5CcgfcA:10 a=6I5d2MoRAAAA:8 a=5UeDudzLVvk3_xX1uKUA:9 a=pILNOxqGKmIA:10 a=IjZwj45LgO3ly-622nXo:22 wl=host:3 X-BeenThere: freebsd-virtualization@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "Discussion of various virtualization techniques FreeBSD supports." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 25 Oct 2016 18:19:08 -0000 Hi Randy, > I've followed the info provided here https://wiki.freebsd.org/bhyve/Windows > to create a Windows Server 2012 image that I successfully installed on the > bhyve hypervisor. After getting a working Win2012 image running, applying > updates, etc. I attempted to install SQL Server 2014. In the late stages of > that install, the process attempts to start the SQL server engine and fails. There have been some reports of this previously. What might be happening is that SQL Server has stricter requirements on the underlying block size than NTFS itself has. Since you are using a file-backed image, the reported block size from the emulated storage controller may be 8KB or even higher, depending on the underlying filesystem type. A suggestion is to force the block size to 4KB (has to be done during install as well), and if the problem persists, try 512 bytes. This is done by using the 'sectorsize=' parameter to the disk configuration e.g. -s 4,ahci-hd,/path/to/disk.img,sectorsize=4096 later, Peter.