November 6, 2002 at 10:07 pm
What is the use of publishing/Listing a sqlserver database in Active Directory ?
Or in general, what has sqlserver to do with active directory and how is it used ?
November 7, 2002 at 5:04 am
Not a lot that I can tell. AD really impacts in two places. One is authentication, the other is allowing your credentials to pass through to a linked server. Listing your publications in AD is....useful how?
Andy
November 7, 2002 at 7:10 am
I guess it would be useful if you had publications available in a very large environment and didn't know exactly what server a particular publication was on... but even this seems a bit of a stretch. The idea behind getting it in AD though is to make AD the one-stop shop to find all resources.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
November 11, 2002 at 12:38 pm
Listing SQL Server databases in Activie Directory is only useful if applications are developed to take advantage of it. Microsoft White Paper "Integrating Applications with Windows 2000 and Active Directory"* suggests a few reasons why you might want to "directory enable" your applications. One one of the more practical reasons: Service publication to help clients locate appropriate database servers. Rather than having perhaps hundreds of workstations or Servers with DSN's that point to a specific database server. I could publish the SQL Server and database(s) in Active Directory. Clients could then locate database servers by name dynamically. Should I need to move a database to different server, I only need to update Active Directory.
Another practical reason -- adminstration -- Rather than connect to each SQL Server to return configuration and perhaps backup information. I could publish SQL Server and databases in Active Directory, I can then go to one place, the Active Directory catalog, to query such things as SortOrder, ServiceAccount, LastBackupDate, LastDiagnosticDate.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply