Adding a Adam NT group to SQL Server?

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

This post has been moved around a couple times so i apologies.

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

I have set up the ADAM instance. Added the ADAM user to an ADAM security group. now I need to add that user group to a SQL instance that resides on our AD domain ( non-ADAM instance.) obviously when I attempt to view all available domains within SQL security manager, all I see is our standard domain, I can't seem to figure out how to make the ADAM domain visible to our AD domain.

Any Thoughts?

Thanks

I'll move this post over to the SQL Server Security forum where I think folks will be better equiped to answer your question.

Best of luck-

Cheers,

Adam

|||

Check this duplicate thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1741431&SiteID=1

|||

Apparently it was moved to a different forum with no sucess. I was then requested to post within the AD group which again got thrown back in here.. I dont know where i can go to get an answer( does anyone know if there is an ADAM forum?)

Thanks

Adding a Adam NT group to SQL Server?

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

This post has been moved around a couple times so i apologies.

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

I have set up the ADAM instance. Added the ADAM user to an ADAM security group. now I need to add that user group to a SQL instance that resides on our AD domain ( non-ADAM instance.) obviously when I attempt to view all available domains within SQL security manager, all I see is our standard domain, I can't seem to figure out how to make the ADAM domain visible to our AD domain.

Any Thoughts?

Thanks

I'll move this post over to the SQL Server Security forum where I think folks will be better equiped to answer your question.

Best of luck-

Cheers,

Adam

|||

Check this duplicate thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1741431&SiteID=1

|||

Apparently it was moved to a different forum with no sucess. I was then requested to post within the AD group which again got thrown back in here.. I dont know where i can go to get an answer( does anyone know if there is an ADAM forum?)

Thanks

Adding a Adam group to SQL Server

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

I have set up the ADAM instance. Added the ADAM user to an ADAM security group. now I need to add that user group to a SQL instance that resides on our AD domain ( non-ADAM instance.) obviously when I attempt to view all available domains within SQL security manager, all I see is our standard domain, I can't seem to figure out how to make the ADAM domain visible to our AD domain.

Any Thoughts?

Thanks

Unfortunately I am not familiar with ADAM, and given that there hasn't been any response yet I would assume most people in this forum have limited or no experience on this topic either.

I would suggest asking in the Windows or AD forums and find out if there is a difference in ADAM authetntication with respect of regular ADs.

-Raul Garcia

SDE/T

SQL Server Engine

|||Will do. Thank you.|||

Not possible. ADAM is not a network OS like AD.... ADAM groups aren't available to SQL server ...

what you can do is: If all your users exist in AD and your ADAM is domain joined, create the groups in AD instead and use them in ADAM as well. ADAM can use AD security principals for Authentication and Authorization.

thanks

Adding a Adam group to SQL Server

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

I have set up the ADAM instance. Added the ADAM user to an ADAM security group. now I need to add that user group to a SQL instance that resides on our AD domain ( non-ADAM instance.) obviously when I attempt to view all available domains within SQL security manager, all I see is our standard domain, I can't seem to figure out how to make the ADAM domain visible to our AD domain.

Any Thoughts?

Thanks

Unfortunately I am not familiar with ADAM, and given that there hasn't been any response yet I would assume most people in this forum have limited or no experience on this topic either.

I would suggest asking in the Windows or AD forums and find out if there is a difference in ADAM authetntication with respect of regular ADs.

-Raul Garcia

SDE/T

SQL Server Engine

|||Will do. Thank you.|||

Not possible. ADAM is not a network OS like AD.... ADAM groups aren't available to SQL server ...

what you can do is: If all your users exist in AD and your ADAM is domain joined, create the groups in AD instead and use them in ADAM as well. ADAM can use AD security principals for Authentication and Authorization.

thanks

sql

Adding a Adam group to SQL Server

Hello all, I 'm not sure if this is the right forum for this, and I apologies if so...

But in a nut shell I'm attempting to grant SQL server access to a ADAM user group account within an ADAM instance.

I have set up the ADAM instance. Added the ADAM user to an ADAM security group. now I need to add that user group to a SQL instance that resides on our AD domain ( non-ADAM instance.) obviously when I attempt to view all available domains within SQL security manager, all I see is our standard domain, I can't seem to figure out how to make the ADAM domain visible to our AD domain.

Any Thoughts?

Thanks

Unfortunately I am not familiar with ADAM, and given that there hasn't been any response yet I would assume most people in this forum have limited or no experience on this topic either.

I would suggest asking in the Windows or AD forums and find out if there is a difference in ADAM authetntication with respect of regular ADs.

-Raul Garcia

SDE/T

SQL Server Engine

|||Will do. Thank you.|||

Not possible. ADAM is not a network OS like AD.... ADAM groups aren't available to SQL server ...

what you can do is: If all your users exist in AD and your ADAM is domain joined, create the groups in AD instead and use them in ADAM as well. ADAM can use AD security principals for Authentication and Authorization.

thanks

Add And Query Linked Server To ADAM Instance...

I was not sure if this was the best SQL Server newsgroup to post this
question to but I thought I would start here.
I would like to add a linked server to an ADAM instance and then be able to
execute queries against this linked server. It looks like I can add the
linked server but I am not sure if I am doing it right. When I try to
execute a query, I receive the following:
An error occurred while preparing the query ... for execution against OLE DB
provider "ADsDSOObject" for linked server ...
I have not been able to get around this error. From what I have read, I am
getting the impression that this is a security issue. I have tried to add
logons to the linked server but again, I am not sure if I am doing this
right. Most of the articles seem to lead me in the right direction but there
is something I am not doing correctly.
Any help with this will be most appreciated.
By the way, I am using SQL Server 2005.
Thank you,
JasonWhen you created the linked server did you define the security at all? Can
you show the query you were trying to execute?
"Jason Richmeier" wrote:
> I was not sure if this was the best SQL Server newsgroup to post this
> question to but I thought I would start here.
> I would like to add a linked server to an ADAM instance and then be able to
> execute queries against this linked server. It looks like I can add the
> linked server but I am not sure if I am doing it right. When I try to
> execute a query, I receive the following:
> An error occurred while preparing the query ... for execution against OLE DB
> provider "ADsDSOObject" for linked server ...
> I have not been able to get around this error. From what I have read, I am
> getting the impression that this is a security issue. I have tried to add
> logons to the linked server but again, I am not sure if I am doing this
> right. Most of the articles seem to lead me in the right direction but there
> is something I am not doing correctly.
> Any help with this will be most appreciated.
> By the way, I am using SQL Server 2005.
> Thank you,
> Jason

Adam rocks..

Adam,
This link http://www.sql-server-performance.c...ing_indexes.asp
was exactly what I needed. Thank you.
Sincerely
PatrickGlad to help.
Have a good Thanksgiving, if you're in the US...
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"news.microsoft.com" <Patrick@.hotmail.com> wrote in message
news:u6GSykG8FHA.4036@.TK2MSFTNGP11.phx.gbl...
> Adam,
> This link http://www.sql-server-performance.c...ing_indexes.asp
> was exactly what I needed. Thank you.
> Sincerely
> Patrick
>|||Does that mean you can't have a good thanksgiving if you're not in the US?
;-)
No, I guess not; "WHERE Country = 'USA'" does not imply what occurs
"WHERE Country != 'USA'"...but I think I'll have a good 4th Thursday in
November anyway (well, I'll try at least)...hey, that's today!
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Adam Machanic wrote:

>Glad to help.
>Have a good Thanksgiving, if you're in the US...
>
>|||Have a good Thursday, no matter where you are :)
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:e0M
mZOI8FHA.3636@.TK2MSFTNGP09.phx.gbl...
Does that mean you can't have a good thanksgiving if you're not in the US?
;-)
No, I guess not; "WHERE Country = 'USA'" does not imply what occurs "WHERE C
ountry != 'USA'"...but I think I'll have a good 4th Thursday in November any
way (well, I'll try at least)...hey, that's today!
--
mike hodgson
blog: http://sqlnerd.blogspot.com
Adam Machanic wrote:
Glad to help.
Have a good Thanksgiving, if you're in the US...

Adam - FYI

I clicked your link in your signature and got this
Using Maxthon Browser
.Text - Application Error!
Details
ArgumentException
The SqlParameter with ParameterName '@.ItemCount' is already contained by
another SqlParameterCollection.
Return to site
Simon Worth
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eaAJLU$IFHA.3336@.TK2MSFTNGP10.phx.gbl...
> This is the first I've ever heard of that SQL-NS... Strange, because MS
> documentation on Notification Services uses SQL-NS as well -- you'd think
> they would have used a different acronym they hadn't already used!
> Anyway, maybe the .clients or .tools groups can offer more help... I have
> never seen mention of this technology in this group in the last year and a
> half that I've been paying close attention.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> <Eric> wrote in message news:Oyk1kH$IFHA.1248@.TK2MSFTNGP10.phx.gbl...
> SQL-NS
news:%23sKzqR5IFHA.3568@.TK2MSFTNGP10.phx.gbl...
to
Naturally,
SQL-DMO
>Yeah, that's the site -- hit refresh a couple of times and it goes away.
Been happening for months, unfortunately. The admin claims it
will -finally- be fixed within the next two days when he upgrades to a more
recent version of the blog software...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%235HhxW$IFHA.2744@.TK2MSFTNGP15.phx.gbl...
> I clicked your link in your signature and got this
> Using Maxthon Browser
> .Text - Application Error!
> Details
> ArgumentException
> The SqlParameter with ParameterName '@.ItemCount' is already contained by
> another SqlParameterCollection.
>
> Return to site
>
> --
> Simon Worth
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:eaAJLU$IFHA.3336@.TK2MSFTNGP10.phx.gbl...
think
have
a
automate
message
> news:%23sKzqR5IFHA.3568@.TK2MSFTNGP10.phx.gbl...
easy
> to
> Naturally,
publication-subscription
when
> SQL-DMO
>|||Cool, just wanted you to know in case the error was new.
It's all good.
Simon Worth
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uAyK5b$IFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Yeah, that's the site -- hit refresh a couple of times and it goes away.
> Been happening for months, unfortunately. The admin claims it
> will -finally- be fixed within the next two days when he upgrades to a
more
> recent version of the blog software...
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%235HhxW$IFHA.2744@.TK2MSFTNGP15.phx.gbl...
MS
> think
> have
and
> a
I'm
> automate
but
> message
> easy
(Notification
> publication-subscription
> when
>