asked on
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