|
|
|
Расместить АктивДиректори в MS SQL
|
|||
|---|---|---|---|
|
#18+
Когда-то я поверхностно изучал IBMские продукты. Есть там такая тема как разместить LDAP сервер на DB2. Я бы с удовольствием сделал бы такое с AD на MS SQL. Ни кто про такое не слышал? Скорее всего продублирую этот вопрос на ветви IBM. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 21.10.2005, 17:09 |
|
||
|
Расместить АктивДиректори в MS SQL
|
|||
|---|---|---|---|
|
#18+
Если я правильно понял вопрос: Adding or Removing a Server Object to the Active Directory Adding an instance of SQL Server object to the Active Directory requires a login with local administrator privileges on the server. If the login used to register the instance of SQL Server does not have sufficient permissions, and the server is a local server, the Connect to SQL Server dialog box is displayed requesting a login with the required permissions. If the login does not have sufficient permissions, and the server is a remote server, an error message is displayed. To add a SQL Server object to the Active Directory On the SQL Server Properties dialog box, Active Directory tab, click Add. After the SQL Server object is added, click Refresh to update the attributes of the instance of SQL Server object in the Active Directory. (Clicking Refresh does not add new objects to the Active Directory; it only refreshes the attributes of the server object). To remove a SQL Server object from the Active Directory On the SQL Server Properties dialog box, Active Directory tab, click Remove. Removing this SQL Server object from the Active Directory also removes its databases and publications from the Active Directory. To add or remove a SQL Server object from the Active Directory using Transact-SQL Execute sp_ActiveDirectory_SCP and set @action='CREATE' to add to Active Direcotry or set @action='DELETE' to remove from Active Directory. Adding Publications as Active Directory Objects After the SQL Server object is enabled for the Active Directory, you can add publications as Active Directory objects. To add publications the SQL Server service account must have at least Power User privileges. To add a publication to the Active Directory Right-click the publication, and then click Publication Properties. On the General tab, select List this publication in the Active Directory. Or when you are creating a publication using the Create Publication Wizard, on the Select Publication Name and Description page, select List this publication in the Active Directory. If a Subscriber has access to the publication, you can subscribe to the publication using Active Directory. To add a publication to Active Directory using Transact-SQL For new publications, execute sp_addpublication or sp_addmergepublication and set @add_to_active_directory='TRUE'. For existing publications, execute sp_changepublication or sp_changemergepublication and set @property=publish_to_ActiveDirectory, @value='TRUE'. Browsing or Subscribing to Publications in Active Directory You can browse publications in Active Directory and, if allowed, subscribe to publications using the Pull Subscription Wizard or Windows Synchronization Manager. Browsing or Subscribing to Publications in Active Directory Using the Pull Subscription Wizard At the Subscriber, start the Pull Subscription Wizard, and then on the Look for Publication page, select Look at publications in the Active Directory or specify publication information. On the Specify Publication page, click the browse button (...) to browse for publications in Active Directory. Browsing or Subscribing to Publications in Active Directory Using Windows Synchronization Manager In Windows Synchronization Manager, double-click To create a subscription, and then select By browsing Active Directory for publications. On the Create Anonymous Subscription (Browse the Active Directory) dialog box, view the publication listed in Active Directory or click the browse (...) button to browse for publications in Active Directory. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 22.10.2005, 18:07 |
|
||
|
Расместить АктивДиректори в MS SQL
|
|||
|---|---|---|---|
|
#18+
Неправильно понял вопрос... Описанная процедура публикует в AD SQL Server (как самого по себе так и баз, для которых он публикует для репликации) - чтобы его было проще искать клиентам, особенно в большой сети. Но к основному вопросу - хранение информации AD в базе SQL Server'a это не имеет отношения. И судя по всему вообще невозможно. -- чем дальше в лес, тем больше нас ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 22.10.2005, 21:00 |
|
||
|
|

start [/forum/topic.php?fid=26&fpage=503&tid=1511980]: |
0ms |
get settings: |
8ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
55ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
49ms |
get tp. blocked users: |
1ms |
| others: | 242ms |
| total: | 386ms |

| 0 / 0 |
