Location: List Archives

List Archives

This forum is an archive of all posts to our mailing list over the past few years.  The forum is set read only therefore to contribute you will need to join our list community.  See more info about this here.

 

When subscribed to the list you should use your standard email client to send your posts to ActiveDir@mail.activedir.org.

List Archives

Subject: [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?
Prev Next
You are not authorized to post a reply.

AuthorMessages
kaspers@xxxx.yyy

08/25/2005 11:21 AM  
Message body was not found.
Alm@xxxx.yyy

08/25/2005 1:55 AM  
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:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx]
On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005
8:29 AMTo: ActiveDir@xxxxxxxxxxxxxxxxxxSubject: 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 jwelch@xxxxxxxxxxxxxxx>
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper
SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@xxxxxxxxxxxxxxxxxxSubject:
[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

RobertBobelUser is Offline

Posts:13

08/25/2005 2:18 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On
Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005
7:20 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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
dejiUser is Offline

Posts:262

08/25/2005 2:37 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx on behalf of Al Mulnick
Sent: Thu 8/25/2005 6:56 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx
] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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


--
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/
AD00000307User is Offline

Posts:0

08/25/2005 2:47 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Al
MulnickSent: Thursday, August 25, 2005 9:57 AMTo:
ActiveDir@xxxxxxxxxxxxxxxxxxSubject: 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:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx]
On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005
8:29 AMTo: ActiveDir@xxxxxxxxxxxxxxxxxxSubject: 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 jwelch@xxxxxxxxxxxxxxx>
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper
SørensenSent: Thursday, August 25, 2005 7:20 AMTo: ActiveDir@xxxxxxxxxxxxxxxxxxSubject:
[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
kaspers@xxxx.yyy

08/25/2005 3:04 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Al MulnickSent: Thursday, August 25, 2005 9:57 AMTo:
ActiveDir@xxxxxxxxxxxxxxxxxxSubject: 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:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of
Kasper SørensenSent: Thursday, August 25, 2005 8:29 AMTo: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo:
ActiveDir@xxxxxxxxxxxxxxxxxxSubject: [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
rkingsla@xxxx.yyy

08/25/2005 3:22 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of deji@xxxxxxxxxxxxxx
Sent: Thursday, August 25, 2005 9:34 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx on behalf of Al Mulnick
Sent: Thu 8/25/2005 6:56 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx
] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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


--
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/
dejiUser is Offline

Posts:262

08/25/2005 3:30 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx on behalf of Kasper Sørensen
Sent: Thu 8/25/2005 8:01 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx
] On Behalf Of Al Mulnick
Sent: Thursday, August 25, 2005 9:57 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx
] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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


--
Best Regards
Kasper Sørensen

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/
kaspers@xxxx.yyy

08/25/2005 3:49 AM  
Message body was not found.
Alm@xxxx.yyy

08/25/2005 4:33 AM  
________________________________

From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx on behalf of Kasper Sørensen
Sent: Thu 8/25/2005 11:48 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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, deji@xxxxxxxxxxxxxx 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx on behalf of Kasper Sørensen
Sent: Thu 8/25/2005 8:01 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx
] On Behalf Of Al Mulnick
Sent: Thursday, August 25, 2005 9:57 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto: ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 8:29 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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 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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx
] On Behalf Of Kasper Sørensen
Sent: Thursday, August 25, 2005 7:20 AM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
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




--
Best Regards
Kasper Sørensen

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/



--
Best Regards
Kasper Sørensen

www.mewe.dk
>
kaspers@xxxx.yyy

08/25/2005 8:41 AM  
Message body was not found.
AD00000307User is Offline

Posts:0

08/25/2005 11:42 AM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper
SørensenSent: Thursday, August 25, 2005 7:20 AMTo:
ActiveDir@xxxxxxxxxxxxxxxxxxSubject: [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
kaspers@xxxx.yyy

08/25/2005 12:29 PM  
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: ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Kasper SørensenSent: Thursday, August 25, 2005 7:20 AMTo:
ActiveDir@xxxxxxxxxxxxxxxxxxSubject: [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
You are not authorized to post a reply.
Forums >ActiveDir Mail List Archive >List Archives > [ActiveDir] Microsoft MIIS: Server 2003 AD and MSSQL 2000 integration?



ActiveForums 3.7
Friends

Friends

VisualClickButoton
Members

Members

MembershipMembership:
Latest New UserLatest:MrPTSai
New TodayNew Today:0
New YesterdayNew Yesterday:0
User CountOverall:5234

People OnlinePeople Online:
VisitorsVisitors:35
MembersMembers:0
TotalTotal:35

Online NowOnline Now:

Ads

Copyright 2009 ActiveDir.org
Terms Of Use