Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Hm... Ya, after reading all the answers.. I have surrenderd.. And will talk to the "Moneymaker" The person who have all the money.. Hehe.. It sounds like the software i need...
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Does your SQL table know when the information has been updated?
If not, then SimpleSync or MIIS are a good idea to investigate further. If it
does, you could use that and have it trigger updates. Or you could have timed
procedures that wake up, check for changes, and then commit the changes. Still
fairly simple solution and can be done by yourself. SimpleSync starts to get
more attractive if you have to write code and definitely as you begin to want
to sync multiple identity stores.
This is still one to one from what I hear, so you have options available that
range in price and complexity.
From: [EMAIL PROTECTED] on behalf of Kasper Sørensen
Sent: Thu 8/25/2005 11:48 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000
integration?
Well, as i said..
I dont have the permission to chamge the ASP pages..
And was told they are not to touch..
THATS my problem.. Because, it was my first ideer
On 8/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
So, the ASP pages feed the SQL. If so, then in your case, I'd just
extend the
ASP pages to feed AD at the same time. You already have a mechanism in
place,
you just need to extend it.
Sincerely,
Dèjì Akómöláfé, MCSE+M MCSA+M MCP+I
Microsoft MVP - Directory Services
www.readymaids.com - we know IT
www.akomolafe.com
Do you now realize that Today is the Tomorrow you were worried about
Yesterday? -anon
From: [EMAIL PROTECTED] on behalf of Kasper Sørensen
Sent: Thu 8/25/2005 8:01 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000
integration?
Hm, Its not a One time..
There is some users in the SQL database..
And they have to be up to date with the users in the Active Directory..
We have som girls in the reception, and they are updating, creating
users, by
internet interface... And those users have to be in the active
directory,
without changing in the ASP pages..
On 8/25/05, Jerry Welch <[EMAIL PROTECTED] > wrote:
I agree completely completely with Al. For a 1-time load there
are a
number of good tools that can get the job done.
SimpleSync is designed for synchronizing LDAP directories and
ODBC
data sources on an ongoing basis. I am sure there are members of this
group
who use it for Exchange GAL sync.
Jerry
Jerry Welch
CPS Systems
US/Canada: 888-666-0277
International: +1 703 827 0919 (-4 GMT)
IP Phone (Skype): Jerry_Welch ( www.skype.net
<http://www.skype.net/> )
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Al Mulnick
Sent: Thursday, August 25, 2005 9:57 AM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL
2000 integration?
While I agree that Jerry has a good solution, I'm not sure I
understand your complete requirement. Do you have a database that is
the
start of the identity lifecycle? Or is this a one time create?
Is this something that you need to have records of? Any reason
not
to script it from SQL (very few lines of code to just create a new
account
object; to manage that account later is much more work instensive and
MIIS or
other is a better fit.)
If this is a one time create, then just use some of the built in
tools and SQL. If this is ongoing, then we need to hear some of the
needs to
put this in perspective.
Al
-Original Message-
From: [EMAIL PROTECTED]
[mailto: [EMAIL PROTECTED] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD
and
MSSQL 2000 integration?
Ohh... Hmm.. okay...
Well, THANKS!!
MIIS is very expensive.. So thanks..
On 8/25/05, Jerry Welch <[EMAIL PROTECTED] > wrote:
Kasper -
Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Well, as i said.. I dont have the permission to chamge the ASP pages.. And was told they are not to touch.. THATS my problem.. Because, it was my first ideer On 8/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: So, the ASP pages feed the SQL. If so, then in your case, I'd just extend theASP pages to feed AD at the same time. You already have a mechanism in place, you just need to extend it.Sincerely,Dèjì Akómöláfé, MCSE+M MCSA+M MCP+IMicrosoft MVP - Directory Serviceswww.readymaids.com - we know IT www.akomolafe.comDo you now realize that Today is the Tomorrow you were worried aboutYesterday? -anonFrom: [EMAIL PROTECTED] on behalf of Kasper SørensenSent: Thu 8/25/2005 8:01 AMTo: ActiveDir@mail.activedir.orgSubject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?Hm, Its not a One time..There is some users in the SQL database..And they have to be up to date with the users in the Active Directory..We have som girls in the reception, and they are updating, creating users, by internet interface... And those users have to be in the active directory,without changing in the ASP pages..On 8/25/05, Jerry Welch <[EMAIL PROTECTED] > wrote: I agree completely completely with Al. For a 1-time load there are anumber of good tools that can get the job done. SimpleSync is designed for synchronizing LDAP directories and ODBC data sources on an ongoing basis. I am sure there are members of this groupwho use it for Exchange GAL sync. Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net<http://www.skype.net/> ) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]> ] On Behalf Of Al Mulnick Sent: Thursday, August 25, 2005 9:57 AM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL2000 integration? While I agree that Jerry has a good solution, I'm not sure Iunderstand your complete requirement. Do you have a database that is the start of the identity lifecycle? Or is this a one time create? Is this something that you need to have records of? Any reason notto script it from SQL (very few lines of code to just create a new account object; to manage that account later is much more work instensive and MIIS orother is a better fit.) If this is a one time create, then just use some of the built intools and SQL. If this is ongoing, then we need to hear some of the needs to put this in perspective. Al -Original Message- From: [EMAIL PROTECTED][mailto: [EMAIL PROTECTED]] On Behalf Of Kasper Sørensen Sent: Thursday, August 25, 2005 8:29 AM To: ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD andMSSQL 2000 integration? Ohh... Hmm.. okay... Well, THANKS!! MIIS is very expensive.. So thanks.. On 8/25/05, Jerry Welch <[EMAIL PROTECTED] > wrote: Kasper - Or you can buy SimpleSync from CPS Systems (www.cps-systems.com <http://www.cps-systems.com/> ) Provides synchronization between any ODBC DB and AD or other LDAP directories. No additional SQL MetaDirectory. Cost for whatyou describe is about $10K. You can expect to be running in a matter ofhours. 240 major companies and government agencies worldwide. As an example, Northrop Grumman uses SimpleSync betweenPeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts. Online, web based demo anytime you would like. Thanks, Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net<http://www.skype.net/> ) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]> ] On Behalf Of Kasper Sørensen Sent: Thursday, August 25, 2005 7:20 AM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] Microsoft MIIS: Server 2003 ADand MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to importusers that are stored in a MSSQL 2000 database, to Active Directory 2003? -- Best Regards Kasper Sørensen www.mewe.dk <http://www.mewe.dk/> -- Best Regards Kasper Søre
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
So, the ASP pages feed the SQL. If so, then in your case, I'd just extend the
ASP pages to feed AD at the same time. You already have a mechanism in place,
you just need to extend it.
Sincerely,
Dèjì Akómöláfé, MCSE+M MCSA+M MCP+I
Microsoft MVP - Directory Services
www.readymaids.com - we know IT
www.akomolafe.com
Do you now realize that Today is the Tomorrow you were worried about
Yesterday? -anon
From: [EMAIL PROTECTED] on behalf of Kasper Sørensen
Sent: Thu 8/25/2005 8:01 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000
integration?
Hm, Its not a One time..
There is some users in the SQL database..
And they have to be up to date with the users in the Active Directory..
We have som girls in the reception, and they are updating, creating users, by
internet interface... And those users have to be in the active directory,
without changing in the ASP pages..
On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote:
I agree completely completely with Al. For a 1-time load there are a
number of good tools that can get the job done.
SimpleSync is designed for synchronizing LDAP directories and ODBC
data sources on an ongoing basis. I am sure there are members of this group
who use it for Exchange GAL sync.
Jerry
Jerry Welch
CPS Systems
US/Canada: 888-666-0277
International: +1 703 827 0919 (-4 GMT)
IP Phone (Skype): Jerry_Welch ( www.skype.net
<http://www.skype.net/> )
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Al Mulnick
Sent: Thursday, August 25, 2005 9:57 AM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL
2000 integration?
While I agree that Jerry has a good solution, I'm not sure I
understand your complete requirement. Do you have a database that is the
start of the identity lifecycle? Or is this a one time create?
Is this something that you need to have records of? Any reason not
to script it from SQL (very few lines of code to just create a new account
object; to manage that account later is much more work instensive and MIIS or
other is a better fit.)
If this is a one time create, then just use some of the built in
tools and SQL. If this is ongoing, then we need to hear some of the needs to
put this in perspective.
Al
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and
MSSQL 2000 integration?
Ohh... Hmm.. okay...
Well, THANKS!!
MIIS is very expensive.. So thanks..
On 8/25/05, Jerry Welch <[EMAIL PROTECTED] > wrote:
Kasper -
Or you can buy SimpleSync from CPS Systems (
www.cps-systems.com <http://www.cps-systems.com/> )
Provides synchronization between any ODBC DB and AD
or other LDAP directories. No additional SQL MetaDirectory. Cost for what
you describe is about $10K. You can expect to be running in a matter of
hours.
240 major companies and government agencies
worldwide. As an example, Northrop Grumman uses SimpleSync between
PeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts.
Online, web based demo anytime you would like.
Thanks,
Jerry
Jerry Welch
CPS Systems
US/Canada: 888-666-0277
International: +1 703 827 0919 (-4 GMT)
IP Phone (Skype): Jerry_Welch ( www.skype.net
<http://www.skype.net/> )
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@mail.activedir.org
Subject: [ActiveDir] Microsoft MIIS: Server 2003 AD
and MSSQL 2000 integration?
Well..
If i buy MIIS, will it then be possible to import
users that are store
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
And, given that Science has proven cockroaches will survive a nuclear war,
it's even a worse choice than originally thought
:o)
Rick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 9:34 AM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000
integration?
Good point. If it's a one-time thing, I'm thinking even 10K is a killer. And
MIIS will be like nuking a cockroach.
Sincerely,
Dèjì Akómöláfé, MCSE+M MCSA+M MCP+I
Microsoft MVP - Directory Services
www.readymaids.com - we know IT
www.akomolafe.com
Do you now realize that Today is the Tomorrow you were worried about
Yesterday? -anon
From: [EMAIL PROTECTED] on behalf of Al Mulnick
Sent: Thu 8/25/2005 6:56 AM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000
integration?
While I agree that Jerry has a good solution, I'm not sure I understand your
complete requirement. Do you have a database that is the start of the
identity lifecycle? Or is this a one time create?
Is this something that you need to have records of? Any reason not to
script
it from SQL (very few lines of code to just create a new account object; to
manage that account later is much more work instensive and MIIS or other is
a
better fit.)
If this is a one time create, then just use some of the built in tools and
SQL. If this is ongoing, then we need to hear some of the needs to put this
in perspective.
Al
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL
2000 integration?
Ohh... Hmm.. okay...
Well, THANKS!!
MIIS is very expensive.. So thanks..
On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote:
Kasper -
Or you can buy SimpleSync from CPS Systems (
www.cps-systems.com <http://www.cps-systems.com/> )
Provides synchronization between any ODBC DB and AD or other
LDAP directories. No additional SQL MetaDirectory. Cost for what you
describe is about $10K. You can expect to be running in a matter of hours.
240 major companies and government agencies worldwide. As
an
example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD
to
Provision and Maintain 90K user accounts.
Online, web based demo anytime you would like.
Thanks,
Jerry
Jerry Welch
CPS Systems
US/Canada: 888-666-0277
International: +1 703 827 0919 (-4 GMT)
IP Phone (Skype): Jerry_Welch ( www.skype.net
<http://www.skype.net/> )
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@mail.activedir.org
Subject: [ActiveDir] Microsoft MIIS: Server 2003 AD and
MSSQL
2000 integration?
Well..
If i buy MIIS, will it then be possible to import users that
are stored in a MSSQL 2000 database, to Active Directory 2003?
--
Best Regards
Kasper Sørensen
www.mewe.dk <http://www.mewe.dk/>
--
Best Regards
Kasper Sørensen
www.mewe.dk
List info : http://www.activedir.org/List.aspx
List FAQ: http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
List info : http://www.activedir.org/List.aspx
List FAQ: http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Hm, Its not a One time.. There is some users in the SQL database.. And they have to be up to date with the users in the Active Directory.. We have som girls in the reception, and they are updating, creating users, by internet interface... And those users have to be in the active directory, without changing in the ASP pages.. On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote: I agree completely completely with Al. For a 1-time load there are a number of good tools that can get the job done. SimpleSync is designed for synchronizing LDAP directories and ODBC data sources on an ongoing basis. I am sure there are members of this group who use it for Exchange GAL sync. Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Al MulnickSent: Thursday, August 25, 2005 9:57 AMTo: ActiveDir@mail.activedir.orgSubject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? While I agree that Jerry has a good solution, I'm not sure I understand your complete requirement. Do you have a database that is the start of the identity lifecycle? Or is this a one time create? Is this something that you need to have records of? Any reason not to script it from SQL (very few lines of code to just create a new account object; to manage that account later is much more work instensive and MIIS or other is a better fit.) If this is a one time create, then just use some of the built in tools and SQL. If this is ongoing, then we need to hear some of the needs to put this in perspective. Al -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 8:29 AMTo: ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Ohh... Hmm.. okay... Well, THANKS!! MIIS is very expensive.. So thanks.. On 8/25/05, Jerry Welch <[EMAIL PROTECTED] > wrote: Kasper - Or you can buy SimpleSync from CPS Systems ( www.cps-systems.com ) Provides synchronization between any ODBC DB and AD or other LDAP directories. No additional SQL MetaDirectory. Cost for what you describe is about $10K. You can expect to be running in a matter of hours. 240 major companies and government agencies worldwide. As an example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts. Online, web based demo anytime you would like. Thanks, Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to import users that are stored in a MSSQL 2000 database, to Active Directory 2003?-- Best RegardsKasper Sørensen www.mewe.dk -- Best RegardsKasper Sørensen www.mewe.dk -- Best RegardsKasper Sørensenwww.mewe.dk
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Title: Message I agree completely completely with Al. For a 1-time load there are a number of good tools that can get the job done. SimpleSync is designed for synchronizing LDAP directories and ODBC data sources on an ongoing basis. I am sure there are members of this group who use it for Exchange GAL sync. Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al MulnickSent: Thursday, August 25, 2005 9:57 AMTo: ActiveDir@mail.activedir.orgSubject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? While I agree that Jerry has a good solution, I'm not sure I understand your complete requirement. Do you have a database that is the start of the identity lifecycle? Or is this a one time create? Is this something that you need to have records of? Any reason not to script it from SQL (very few lines of code to just create a new account object; to manage that account later is much more work instensive and MIIS or other is a better fit.) If this is a one time create, then just use some of the built in tools and SQL. If this is ongoing, then we need to hear some of the needs to put this in perspective. Al -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 8:29 AMTo: ActiveDir@mail.activedir.orgSubject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Ohh... Hmm.. okay... Well, THANKS!! MIIS is very expensive.. So thanks.. On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote: Kasper - Or you can buy SimpleSync from CPS Systems ( www.cps-systems.com ) Provides synchronization between any ODBC DB and AD or other LDAP directories. No additional SQL MetaDirectory. Cost for what you describe is about $10K. You can expect to be running in a matter of hours. 240 major companies and government agencies worldwide. As an example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts. Online, web based demo anytime you would like. Thanks, Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to import users that are stored in a MSSQL 2000 database, to Active Directory 2003?-- Best RegardsKasper Sørensenwww.mewe.dk -- Best RegardsKasper Sørensenwww.mewe.dk
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Good point. If it's a one-time thing, I'm thinking even 10K is a killer. And
MIIS will be like nuking a cockroach.
Sincerely,
Dèjì Akómöláfé, MCSE+M MCSA+M MCP+I
Microsoft MVP - Directory Services
www.readymaids.com - we know IT
www.akomolafe.com
Do you now realize that Today is the Tomorrow you were worried about
Yesterday? -anon
From: [EMAIL PROTECTED] on behalf of Al Mulnick
Sent: Thu 8/25/2005 6:56 AM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000
integration?
While I agree that Jerry has a good solution, I'm not sure I understand your
complete requirement. Do you have a database that is the start of the
identity lifecycle? Or is this a one time create?
Is this something that you need to have records of? Any reason not to script
it from SQL (very few lines of code to just create a new account object; to
manage that account later is much more work instensive and MIIS or other is a
better fit.)
If this is a one time create, then just use some of the built in tools and
SQL. If this is ongoing, then we need to hear some of the needs to put this
in perspective.
Al
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL
2000 integration?
Ohh... Hmm.. okay...
Well, THANKS!!
MIIS is very expensive.. So thanks..
On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote:
Kasper -
Or you can buy SimpleSync from CPS Systems (
www.cps-systems.com <http://www.cps-systems.com/> )
Provides synchronization between any ODBC DB and AD or other
LDAP directories. No additional SQL MetaDirectory. Cost for what you
describe is about $10K. You can expect to be running in a matter of hours.
240 major companies and government agencies worldwide. As an
example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD to
Provision and Maintain 90K user accounts.
Online, web based demo anytime you would like.
Thanks,
Jerry
Jerry Welch
CPS Systems
US/Canada: 888-666-0277
International: +1 703 827 0919 (-4 GMT)
IP Phone (Skype): Jerry_Welch ( www.skype.net
<http://www.skype.net/> )
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@mail.activedir.org
Subject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL
2000 integration?
Well..
If i buy MIIS, will it then be possible to import users that
are stored in a MSSQL 2000 database, to Active Directory 2003?
--
Best Regards
Kasper Sørensen
www.mewe.dk <http://www.mewe.dk/>
--
Best Regards
Kasper Sørensen
www.mewe.dk
List info : http://www.activedir.org/List.aspx
List FAQ: http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Yes, there is an MS-SQL MA that comes with MIIS Enterprise Edition. http://www.microsoft.com/windowsserversystem/miis2003/evaluation/overview/default.mspx. MIIS may be a little much if this is a one-time import. Configuration is about a day or two depending on your situation. If you need to have on-going sync of those accounts then MIIS would be pretty good solution. Bob From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kasper Sørensen Sent: Thursday, August 25, 2005 7:20 AM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to import users that are stored in a MSSQL 2000 database, to Active Directory 2003? -- Best Regards Kasper Sørensen www.mewe.dk
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Title: Message While I agree that Jerry has a good solution, I'm not sure I understand your complete requirement. Do you have a database that is the start of the identity lifecycle? Or is this a one time create? Is this something that you need to have records of? Any reason not to script it from SQL (very few lines of code to just create a new account object; to manage that account later is much more work instensive and MIIS or other is a better fit.) If this is a one time create, then just use some of the built in tools and SQL. If this is ongoing, then we need to hear some of the needs to put this in perspective. Al -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 8:29 AMTo: ActiveDir@mail.activedir.orgSubject: Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Ohh... Hmm.. okay... Well, THANKS!! MIIS is very expensive.. So thanks.. On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote: Kasper - Or you can buy SimpleSync from CPS Systems ( www.cps-systems.com ) Provides synchronization between any ODBC DB and AD or other LDAP directories. No additional SQL MetaDirectory. Cost for what you describe is about $10K. You can expect to be running in a matter of hours. 240 major companies and government agencies worldwide. As an example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts. Online, web based demo anytime you would like. Thanks, Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to import users that are stored in a MSSQL 2000 database, to Active Directory 2003?-- Best RegardsKasper Sørensenwww.mewe.dk -- Best RegardsKasper Sørensenwww.mewe.dk
Re: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Ohh... Hmm.. okay... Well, THANKS!! MIIS is very expensive.. So thanks.. On 8/25/05, Jerry Welch <[EMAIL PROTECTED]> wrote: Kasper - Or you can buy SimpleSync from CPS Systems ( www.cps-systems.com ) Provides synchronization between any ODBC DB and AD or other LDAP directories. No additional SQL MetaDirectory. Cost for what you describe is about $10K. You can expect to be running in a matter of hours. 240 major companies and government agencies worldwide. As an example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts. Online, web based demo anytime you would like. Thanks, Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to import users that are stored in a MSSQL 2000 database, to Active Directory 2003?-- Best RegardsKasper Sørensen www.mewe.dk -- Best RegardsKasper Sørensenwww.mewe.dk
RE: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Kasper - Or you can buy SimpleSync from CPS Systems ( www.cps-systems.com ) Provides synchronization between any ODBC DB and AD or other LDAP directories. No additional SQL MetaDirectory. Cost for what you describe is about $10K. You can expect to be running in a matter of hours. 240 major companies and government agencies worldwide. As an example, Northrop Grumman uses SimpleSync between PeopleSoft/Oracle and AD to Provision and Maintain 90K user accounts. Online, web based demo anytime you would like. Thanks, Jerry Jerry Welch CPS Systems US/Canada: 888-666-0277 International: +1 703 827 0919 (-4 GMT) IP Phone (Skype): Jerry_Welch ( www.skype.net ) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration? Well.. If i buy MIIS, will it then be possible to import users that are stored in a MSSQL 2000 database, to Active Directory 2003?-- Best RegardsKasper Sørensenwww.mewe.dk
