Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Database.ActiveDirectory Property

Gets the information about the Active Directory settings for the database.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)]
public DatabaseActiveDirectory ActiveDirectory { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.DatabaseActiveDirectory
A DatabaseActiveDirectory object that specifies the Active Directory settings for the database.

The ActiveDirectory property points to a DatabaseActiveDirectory object, which can be used to register the referenced database Active Directory.

When you call the Register method to add a database to Active Directory, users can use Active Directory to find this database. This is useful in large organizations with many databases.

NoteNote

Registering a database in Active Directory can be performed only on instances of SQL Server that are installed on computers that are running Windows 2000 or later versions.

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks2008R2 database
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")

'Register the AdventureWorks2008R2 database in the Active Directory 
'directory service.
db.ActiveDirectory.Register()

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$db.ActiveDirectory.Register()

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.