Login: [DVROEE20TH\vmadmin]

Collapse All Expand All

Login Properties

Name	Value
Name	[DVROEE20TH\vmadmin]
Friendly Name	English
Language	us_english
System
Default Database	master
Deny Windows Security Authenticated Connections
Type	Windows user
Permissions to Access the Server	Explicit grant

Users with this login

	Database	User
	ARCH_CTRLCTR	dbo
	CTRLCTR	dbo
	DATAMART	dbo
	EagleGatewayConfig	dbo
	EagleGatewayPreStage	dbo
	EagleGatewayStage	dbo
	EAGLEKB	dbo
	EAGLEMGR	dbo
	LEDGER	dbo
	MSGCENTER	dbo
	PERFORM	dbo
	PRICING	dbo
	ESTAR	dbo
	BBDW	dbo
	Northwind	dbo

Roles with this login

	Role
	sysadmin

SQL

CREATE LOGIN [DVROEE20TH\vmadmin] FROM WINDOWS WITH 
    DEFAULT_DATABASE=[master],
    DEFAULT_LANGUAGE=[us_english]
GO

See also

Buildmasters.com.au