Re: SQL and AD

Tech-Archive recommends: Fix windows errors by optimizing your registry

I think this question may be more appropriate in
microsoft.public.sqlserver.server

--


Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA

This posting is provided "AS IS" with no warranties, and confers no rights.


"MAGrimsley" <MAGrimsley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:587E33B9-4D93-48CD-8686-18C0D301A54B@xxxxxxxxxxxxxxxx
>I have a project that I am working on that requires me to dynamically
>create
> the connection string to a SQL Server database. All of our SQL Servers are
> published within Active Directory. Within SQL Server there is a tab that
> allows you to add the instance of SQL to Active Directory. This can also
> be
> done for a database after SQL has been added to AD (the options tab at the
> bottom).
>
> With the database and the SQL instance published in AD I should be able to
> query AD to find the location of the database, i.e., What server is
> database
> X on?, I have looked through System.DirectoryServices and have been able
> to
> find how to do this or what objects I need to call. Your help is greatly
> appreciated.
>


.

Relevant Pages

  • Re: T-Sql & Active Directory Roles, Identification of original login of impersonated IDs an
    ... We want to be able to control access to data within a table based on a ... role within Active directory. ... All the sites are held in a single database table. ... can grant permissions in SQL Server to Windows groups. ...
    (comp.databases.ms-sqlserver)
  • Re: some security concerns
    ... I'm not an expert on MS SQL Server, but if you are using Active Directory; ... password for the database which cannot be linked to Active Directory. ... overall it still comes down to training of the data entry people as ...
    (comp.databases.ms-access)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)