Connect SQL with Active Directory

Hi everybody. I have this problem: I have to access to the Active Directory of a remote server from my computer using SQL and make searches based on the LDAP of the server. Someone told me to use Add Linked Server, but I don't know how to do it with the Active Directory. Thanks for the help.

Please take a look at the link below for the solution:

http://msdn2.microsoft.com/en-US/library/ms190803.aspx

Books Online topics on linked servers are also useful to know. Note that there are however restrictions on what you can do via distributed queries. For example, some of the collection data types in the Active Directory Schema are not supported in SQL Server, number of rows that you can retrieve is restricted by default & so on.

|||

Linking SQL Server to Active Directory is tricky. and Microsoft support/help isn't very intuitive for this.
Check a few things first...
1. two single quotes not double.
2. Make connection w/out security context.

Follow this syntax:
EXEC master.dbo.sp_addlinkedserver @.server = N'ADSI',
@.srvproduct=N'Active Directory Services', @.provider=N'ADsDSOObject',
@.datasrc=N'Servername.domain.com' --AKA the full computer name of the AD server

Then execute the openquery like this:

select * from openquery
(
ADSI,'SELECT name
FROM ''LDAP://Servername.domain.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')

I couldn't find anything on the Internet that would help me.

Connect SQL with Active Directory

Hi everybody. I have this problem: I have to access to the Active Directory of a remote server from my computer using SQL and make searches based on the LDAP of the server. Someone told me to use Add Linked Server, but I don't know how to do it with the Active Directory. Thanks for the help.

Please take a look at the link below for the solution:

http://msdn2.microsoft.com/en-US/library/ms190803.aspx

Books Online topics on linked servers are also useful to know. Note that there are however restrictions on what you can do via distributed queries. For example, some of the collection data types in the Active Directory Schema are not supported in SQL Server, number of rows that you can retrieve is restricted by default & so on.

|||

Linking SQL Server to Active Directory is tricky. and Microsoft support/help isn't very intuitive for this.
Check a few things first...
1. two single quotes not double.
2. Make connection w/out security context.

Follow this syntax:
EXEC master.dbo.sp_addlinkedserver @.server = N'ADSI',
@.srvproduct=N'Active Directory Services', @.provider=N'ADsDSOObject',
@.datasrc=N'Servername.domain.com' --AKA the full computer name of the AD server

Then execute the openquery like this:

select * from openquery
(
ADSI,'SELECT name
FROM ''LDAP://Servername.domain.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')

I couldn't find anything on the Internet that would help me.

Confirm SP install on a cluster

Hi,
How do I know that the installation of a SP was successfully done on both
nodes of a 2-node cluster?
I installed SQL 2005 SP1 on the active node of my 2-node cluster and after
it had successfully completed. I checked the productlevel to confirm and then
failed over to the other node and checked the productlevel there as well. Is
that good enough? Should I bee looking elsewhere, such as maybe
date-time-stamp on certain files, registry entries, file versions, etc?
Thanks.
Hello Rob, the updates to the dlls and exe files under c:\program
files\microsoft sql server\mssql\binn can also me checked for versioning
information if you wish. the SQL that is aplied during the install will be in
the server no matter what server your on obviously. In my experience when a
service pack fails to update binaries properly for a cluster and SP1 for
SQL2000 did you will be a message on the node it failed on that it can no
longer run the SQL resource and it will fail back to the other node that was
updated properly usually the one you ran the SP on.
Hope that helps
John Vandervliet
"Rob" wrote:

> Hi,
> How do I know that the installation of a SP was successfully done on both
> nodes of a 2-node cluster?
> I installed SQL 2005 SP1 on the active node of my 2-node cluster and after
> it had successfully completed. I checked the productlevel to confirm and then
> failed over to the other node and checked the productlevel there as well. Is
> that good enough? Should I bee looking elsewhere, such as maybe
> date-time-stamp on certain files, registry entries, file versions, etc?
> Thanks.

Confirm SP install on a cluster

Hi,
How do I know that the installation of a SP was successfully done on both
nodes of a 2-node cluster?
I installed SQL 2005 SP1 on the active node of my 2-node cluster and after
it had successfully completed. I checked the productlevel to confirm and then
failed over to the other node and checked the productlevel there as well. Is
that good enough? Should I bee looking elsewhere, such as maybe
date-time-stamp on certain files, registry entries, file versions, etc?
Thanks.Hello Rob, the updates to the dlls and exe files under c:\program
files\microsoft sql server\mssql\binn can also me checked for versioning
information if you wish. the SQL that is aplied during the install will be in
the server no matter what server your on obviously. In my experience when a
service pack fails to update binaries properly for a cluster and SP1 for
SQL2000 did you will be a message on the node it failed on that it can no
longer run the SQL resource and it will fail back to the other node that was
updated properly usually the one you ran the SP on.
Hope that helps
John Vandervliet
"Rob" wrote:
> Hi,
> How do I know that the installation of a SP was successfully done on both
> nodes of a 2-node cluster?
> I installed SQL 2005 SP1 on the active node of my 2-node cluster and after
> it had successfully completed. I checked the productlevel to confirm and then
> failed over to the other node and checked the productlevel there as well. Is
> that good enough? Should I bee looking elsewhere, such as maybe
> date-time-stamp on certain files, registry entries, file versions, etc?
> Thanks.

Confirm SP install on a cluster

Hi,
How do I know that the installation of a SP was successfully done on both
nodes of a 2-node cluster?
I installed SQL 2005 SP1 on the active node of my 2-node cluster and after
it had successfully completed. I checked the productlevel to confirm and the
n
failed over to the other node and checked the productlevel there as well. Is
that good enough? Should I bee looking elsewhere, such as maybe
date-time-stamp on certain files, registry entries, file versions, etc?
Thanks.Hello Rob, the updates to the dlls and exe files under c:\program
files\microsoft sql server\mssql\binn can also me checked for versioning
information if you wish. the SQL that is aplied during the install will be i
n
the server no matter what server your on obviously. In my experience when a
service pack fails to update binaries properly for a cluster and SP1 for
SQL2000 did you will be a message on the node it failed on that it can no
longer run the SQL resource and it will fail back to the other node that was
updated properly usually the one you ran the SP on.
Hope that helps
John Vandervliet
"Rob" wrote:

> Hi,
> How do I know that the installation of a SP was successfully done on both
> nodes of a 2-node cluster?
> I installed SQL 2005 SP1 on the active node of my 2-node cluster and after
> it had successfully completed. I checked the productlevel to confirm and t
hen
> failed over to the other node and checked the productlevel there as well.
Is
> that good enough? Should I bee looking elsewhere, such as maybe
> date-time-stamp on certain files, registry entries, file versions, etc?
> Thanks.

Configuring SSIS in an Active\Active Cluster

OK so I am aware that the SSIS service can be clustered relatively easily but my problem is a bit more complex I believe.

I have an Active\Active\Active 3 node cluster running Windows 2003 sp1 all running SSIS packages. What I need is a solution to having an instance fail to another node and still be able to run scheduled SSIS packages through the SQL Agent.

The solution that I have come up with is to have a single network share for all three instances of SSIS running locally on the individual nodes. I have removed the ability for SSIS to look in MSDB by altering the config file and reference only the Packages share on the network for accessability. They all share the same config file on the share as well. The share structure looks something like this simplified example.

\\server1\SSIS\Configuration

\\server1\SSIS\Packages

\\server1\SSIS\Packages\Instance1\

\\server1\SSIS\Packages\Instance2\

\\server1\SSIS\Packages\Instance3\

Once I change the registry to point to the config file all three instances can access the Instance1, 2 or 3 directories.

This works ok for the jobs, and I can access the stored packages under the file system folder only if I'm remotely connected to that particular physical server hosting the service or on the console. The problem I am having though is when users or I attempt to access the SSIS Engine through SSMS from our locale machines. It seems as though SSMS is having trouble with the passthrough of the directory information. On the share I obviously have permissiosn to access the directory structure (full control to be exact) because I can get to it when I access it from SSMS on the server.

This is the error I get...

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

The storage location for the folder "File System\" cannot be accessed. (MsDtsSrvr)

DETAILS:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Program Location:

at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()

===================================

The storage location for the folder "File System\" cannot be accessed. (MsDtsSrvr)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetDtsServerPackageInfos(String sPackageFolder, String sServerName)
at Microsoft.SqlServer.Dts.SmoEnum.PackageEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)

Any work around or suggestion would be appreciated.

Thanks,

Zach

Anyone have any thoughts on how to make this work?

Thanks for the look,

Zach

Configuring an SQL 2005 Cluster on a windows 2003 Active Passive c

Hi All.
I want to deploy an sql 2005 cluster on a Windows 2003 Active/Passive
Cluster.Are there any KB articles avalible that will guide in deploying sql
2005 Cluster.
Appreciate it.
Regards
Khalid
Search the Microsoft site for an article by Allan Hirt
SQL Server 2005 Failover Clustering White Paper SQLServer2005FOC.doc
Khalid wrote:
>Hi All.
>I want to deploy an sql 2005 cluster on a Windows 2003 Active/Passive
>Cluster.Are there any KB articles avalible that will guide in deploying sql
>2005 Cluster.
>Appreciate it.
>Regards

configuring Active/Active...

You would need to install multiple instances of SQL Server
to do what you want. So Ins1 would own DB1, and Ins2 DB2
and DB3. (Or Two instances ... whatever you want). The
way failover clustering works is that upon a failure, the
whole SQL instance will fail over to another node, so if
you had a failure on Ins1, it would go to Node 2 (or 3 or
whatever) automatically.
So I'm not sure what it is you're asking since you get
that functionality.
Your apps would connect to the SQL virutal server/instance
that has the DBs. On a cluster, a SQL virtual server is
an instance.
Heelo AA,
Here are some links that you may find useful learning about SQL Server 20000 Failover Clustering
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Microsoft SQL Server 2000 High Availability (MS Press)
ISBN 0-7356-1920-4
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

configuring Active/Active...

My Current configuration is:
Windows 2003, cluster service, SQL 2000 sp3
I have 3 databases I want to run one in the cluster node1 and the other two
databases in the node2.
So, when node1 fail, node2 take the node1 DB and vice-versa.
Is possible? do you know some URL where I can find information about it?
Another question: In the Active/Active my applications always make a
connection to the Virtual Server or to each Instance?
Thanks
AA
Yes, this is possible. You will need separate physical disks for each
installation of SQL. Each instance corresponds to a virtual server so the
SQL connection is to the IP of the virtual server and the port of the
instance. Since each instance is on a separate IP address, you can have all
instances using the same port number. All that is required to create a
second installation is to run the SQL install agaon and create a new
clustered instance using new resources (disks, network name, IP address).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"AA" <aa@.personal.net.py> wrote in message
news:e93uK5UdEHA.3732@.TK2MSFTNGP11.phx.gbl...
> My Current configuration is:
> Windows 2003, cluster service, SQL 2000 sp3
> I have 3 databases I want to run one in the cluster node1 and the other
two
> databases in the node2.
> So, when node1 fail, node2 take the node1 DB and vice-versa.
> Is possible? do you know some URL where I can find information about it?
>
> Another question: In the Active/Active my applications always make a
> connection to the Virtual Server or to each Instance?
>
> Thanks
> AA
>

Configuring Active Directory as a Linked Server.

Hi, in a server running sql server 2000 sp3, as a new requirement for an
application. They need to have the active Directory configured as a
Linked Server.
Do somebody know the pros and cons of configuring this.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***Hi,
its their SQL Server ,SQL server can be integrated with Active Directory ,
please read *Active Directory* in BOL.
here are some articles FYI :
msdn.microsoft.com/library/en-us/architec/8_ar_cs_1gku.asp
msdn.microsoft.com/.../adsi/adsi/ creating_a_heterogeneous_join_between_sq
l_s
erver_and_active_directory.asp
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"MariaGuzman" wrote:

> Hi, in a server running sql server 2000 sp3, as a new requirement for an
> application. They need to have the active Directory configured as a
> Linked Server.
> Do somebody know the pros and cons of configuring this.
> Thanks a lot for your help.
> *** Sent via Developersdex http://www.codecomments.com ***
>