Creating a new Vcenter SQL db

use [master] 
go 
CREATE DATABASE [vcenterdb] ON PRIMARY 
(NAME = N'vcenterdb', FILENAME = N'C:\vcenterdb.mdf', SIZE = 200000KB, FILEGROWTH = 10% ) 
LOG ON 
(NAME = N'vcenterdb_log', FILENAME = N'C:\vcenterdb.ldf', SIZE = 100000KB, FILEGROWTH = 10%) 
COLLATE SQL_Latin1_General_CP1_CI_AS 
go
use vcenterdb 
go 
sp_addlogin @loginame=[vpxuser], @passwd=N'vpxuser!0', @defdb='vcenterdb', @deflanguage='us_english'
go 
ALTER LOGIN [vcuser] WITH CHECK_POLICY = OFF 
go 
CREATE USER [vcuser] for LOGIN [vcuser]
go
use MSDB
go
CREATE USER [vcuser] for LOGIN [vcuser]
go

Select all Open in new window