use [master]
go
CREATE DATABASE [VCDB] ON PRIMARY
(NAME = N'vcdb', FILENAME = N'C:\VCDB.mdf', SIZE = 2000KB, FILEGROWTH = 10% )
LOG ON
(NAME = N'vcdb_log', FILENAME = N'C:\VCDB.ldf', SIZE = 1000KB, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
go
use VCDB
go
sp_addlogin @loginame=[vpxuser], @passwd=N'vpxuser!0', @defdb='VCDB', @deflanguage='us_english'
go
ALTER LOGIN [vpxuser] WITH CHECK_POLICY = OFF
go
CREATE USER [vpxuser] for LOGIN [vpxuser]
go
use MSDB
go
CREATE USER [vpxuser] for LOGIN [vpxuser]
go
I'm new to vMware, so right now I'm following a guid for the version I want to install. I'm not using the Database Express installation. Instead I have a Windows 2012 R2 Server with Microsoft SQL Server 2012 installed. The command above isn't working, I get the following error:
Msg 1803, Level 16, State 1, Line 2
The CREATE DATABASE statement failed. The primary file must be at least 5MB to accommodate a copy of the model database.
So I started googling and found this: VMware KB: Creating a SQL Server database for vCenter Server fails with the error: The primary file ...
It didn't solve my problem.
Does anyone know what I'm doing wrong here?
All server are running on ESXi 5.1 host, in case that's relevant for my question.