VM details and accounts

You will need to identify your virtual machine details, such as a virtual machine name, instance name, and service account. The following table is a sample form that you can use as a reference:

Item

Description

Virtual machine name

SQL2014VM

Virtual machine computer name

PHOENIX

Domain

QUERYWORKS

Virtual machine computer administrator account

UserName: Administrator

Password: P@ssword

SQL Server instances

Default: PHOENIX (localhost can also be used)

Named: PHOENIX\SQL01

SQL Server service account

UserName: QUERYWORKS\sqlservice

Password: P@ssword

SQL Server agent account

UserName: QUERYWORKS\sqlagent

Password: P@ssword

Additional domain accounts

QUERYWORKS\tstark

QUERYWORKS\srogers ...

Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial