June 3, 2003 at 4:22 am
Hi!
Tried to find this in BOL, but could't
List this database in active directory (in database properties)
List this publication in active directory (in publication properties)
What it all means?
June 3, 2003 at 5:03 am
That should be the options to make publications or database visible on the Active Directory system for your network. You must be part of an Active Directory Service (similar to Novells NDS and replaces Domains logic of NT networks). They will then be visible to people to know where they are, but not neccessarily access.
June 3, 2003 at 5:07 am
Not quite understand, but what is the practical use of such publications?
June 3, 2003 at 6:12 am
Just a wild guess here...
Active Directory allows you to 'publish' the 'location' of an 'entity' on the network. Such an entity can be a user or a computer, but it could also be a database.
If you publish a database on Active Directory, everyone that has access to that Directory will be able to 'find' your database. It's like saying to the world, 'hey look, here's my database...'.
The same thing happens with publishing a Web Service on a UDDI directory.
June 3, 2003 at 6:28 am
Just found it: BOL (keywords: Active Directory Services)
Typically, if a user wants to subscribe to a publication, they must know the name of the instance of Microsoft SQL Server™ and the database where the publication is published. Having publication information available in Active Directory allows users to browse based on publication properties and, if allowed, to subscribe to publications using pull subscriptions. Users do not need to know the server name and database where the publication is located.
June 3, 2003 at 6:29 am
Another one:
The properties listed in the Active Directory may not always be exactly the same as they are in SQL Server. If there is discrepancy between the publication and attributes in the Active Directory and publication properties in SQL Server, the publication properties in SQL Server are the correct settings to use. This also applies to database and server listings in the Active Directory.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply