From owner-freebsd-virtualization@freebsd.org Wed Oct 26 17:13:50 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 AD3B8C23395 for ; Wed, 26 Oct 2016 17:13:50 +0000 (UTC) (envelope-from randy@terbush.org) Received: from mail-qt0-x236.google.com (mail-qt0-x236.google.com [IPv6:2607:f8b0:400d:c0d::236]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 71BA8337 for ; Wed, 26 Oct 2016 17:13:50 +0000 (UTC) (envelope-from randy@terbush.org) Received: by mail-qt0-x236.google.com with SMTP id g32so6068069qta.2 for ; Wed, 26 Oct 2016 10:13:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=terbush.org; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=EPwM54OkUmxu7eedRdfk1bPFBFH08Fj0+vRp54TjbuE=; b=aDty/IMtkGgILfaSFba6z0YSKDCD1d8Kv1m5n5QTuL2Xdrzt+XvFVVzFsJ0KkdFCgs RqfMdYA4WR9U0O60jg9oW3BwGMdwc4yt5VtXwsknWcknePig11NWBXlxkNhrpSVF36bV XO9HNuL0sN/EMOJRHfNTBV4GsfXyLPBI0q3fs= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=EPwM54OkUmxu7eedRdfk1bPFBFH08Fj0+vRp54TjbuE=; b=QFD6GVjjLv87CB0OaKMPO7ysffW71Rgwfk4YU9yPZfKHi5cMZainhepkPrqDjN30cy 39MOJXuA0FCAP+mbVx7CdRGI75sMZmRDBYvQ+t+G9v90aYA1feZeUJ31mNC3tNzM09dX P0P0KkwrNZfQd6koqryhP+IccoriFbNTDInUYu3xPC1a3Vp+19ie2N3QvD1/1d+2QWVq L/JAdxH1xCoeKkrnKErlMWNfw2V8qt0+KtfkLijejxdS6O0ZL1i9VnPqkDCxJ0I5EwpR XUR5Pb8brAJF66VbJ0TDOjnSBlWDjNpyPAf12/pYR6+BX3RmUhJN6zgMoy7h4WNxckIV YRaA== X-Gm-Message-State: ABUngveNcl/Dn58C9FPwgwrtjHk2uCUTXSOLSvAONP//6src5vMIvSjt6I+vgjxYv3L8q7YNXsL4ztfJIHiSQg== X-Received: by 10.237.54.98 with SMTP id e89mr2540833qtb.130.1477502029417; Wed, 26 Oct 2016 10:13:49 -0700 (PDT) MIME-Version: 1.0 Received: by 10.200.51.174 with HTTP; Wed, 26 Oct 2016 10:13:19 -0700 (PDT) In-Reply-To: References: <212f161a-d2d1-d164-3910-eeb256ae68ec@freebsd.org> <4febd210b57742b780eefc0132709be2@SERVER.ad.usd-group.com> From: Randy Terbush Date: Wed, 26 Oct 2016 11:13:19 -0600 Message-ID: Subject: Re: Installing SQL Server on Windows 2012 bhyve guests To: Matt Churchyard Cc: Peter Grehan , "freebsd-virtualization@freebsd.org" Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.23 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: Wed, 26 Oct 2016 17:13:50 -0000 I can confirm that the following template file and vm-bhyve allows me to do an unattended install of win2012r2 that will also allow a successful install of SQL Server 2014. guest="windows" uefi="yes" cpu=2 memory=4G network0_type="virtio-net" network0_switch="public" disk0_type="ahci-hd" disk0_name="disk0.img" disk0_opts="sectorsize=512" I'll see about trying with 4k blocks but for some reason, was having trouble booting new VMs yesterday which led me to try 512 which also failed, but after a fresh buildworld on 11-stable, the 512 block image booted just fine. Thanks for the help here -- Randy On Wed, Oct 26, 2016 at 7:08 AM, Randy Terbush wrote: > Thanks guys, I'll report back once I nail this down. > > I've tried both 4096 and 512 and cannot seem to get an image to boot past > the failed EFI message. Not sure if something has changed lately in stable > to create that result, but will investigate and report back. > > Thanks again for the guidance here. > > -- > Randy > > On Wed, Oct 26, 2016 at 3:30 AM, Matt Churchyard < > matt.churchyard@userve.net> wrote: > >> -----Original Message----- >> From: owner-freebsd-virtualization@freebsd.org [mailto: >> owner-freebsd-virtualization@freebsd.org] On Behalf Of Peter Grehan >> Sent: 25 October 2016 19:19 >> To: Randy Terbush >> Cc: freebsd-virtualization@freebsd.org >> Subject: Re: Installing SQL Server on Windows 2012 bhyve guests >> >> >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 >> >> Just to add, if you're using vm-bhyve you should be able to add this with >> the diskX_opts template/config option >> >> disk0_opts="sectorsize=4096" >> >> I may adjust the sample templates to include a sectorsize option for >> Windows guests, although I'm not 100% clear on what exact OS versions or >> applications require specific settings. I do know that SQL Server has been >> reported to suddenly fall over unless a valid block size is used (although >> I believe it did install and run), but again I'm not sure exactly what the >> "correct" settings are. >> >> Also note that you shouldn't need any grub_* template options if you're >> using UEFI. Those options only apply to grub-bhyve. >> >> Matt >> >> >later, >> >> >Peter. >> >> >