What is involved in connecting a SQL Server 2000 to Active Directory. My
need is not to register SQL Server but to exchange data.
Hi
There is an article in the April edition of SQL Server Magazine about ADSI
but (it says) it can not be used to update the AD.
http://www.winnetmag.com/Windows/Art...41/pg/1/1.html
also see:
http://msdn.microsoft.com/library/de...qd_12_94fn.asp
John
"Robert E. Flaherty" <Bobf@.TimeVision.Com> wrote in message
news:uojBCBNREHA.1348@.TK2MSFTNGP12.phx.gbl...
> What is involved in connecting a SQL Server 2000 to Active Directory. My
> need is not to register SQL Server but to exchange data.
>
Showing posts with label connecting. Show all posts
Showing posts with label connecting. Show all posts
Sunday, March 11, 2012
Active Directory
What is involved in connecting a SQL Server 2000 to Active Directory. My
need is not to register SQL Server but to exchange data.Hi
There is an article in the April edition of SQL Server Magazine about ADSI
but (it says) it can not be used to update the AD.
http://www.winnetmag.com/Windows/Ar...841/pg/1/1.html
also see:
_94fn.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_94fn.asp
John
"Robert E. Flaherty" <Bobf@.TimeVision.Com> wrote in message
news:uojBCBNREHA.1348@.TK2MSFTNGP12.phx.gbl...
> What is involved in connecting a SQL Server 2000 to Active Directory. My
> need is not to register SQL Server but to exchange data.
>
need is not to register SQL Server but to exchange data.Hi
There is an article in the April edition of SQL Server Magazine about ADSI
but (it says) it can not be used to update the AD.
http://www.winnetmag.com/Windows/Ar...841/pg/1/1.html
also see:
_94fn.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_94fn.asp
John
"Robert E. Flaherty" <Bobf@.TimeVision.Com> wrote in message
news:uojBCBNREHA.1348@.TK2MSFTNGP12.phx.gbl...
> What is involved in connecting a SQL Server 2000 to Active Directory. My
> need is not to register SQL Server but to exchange data.
>
Saturday, February 25, 2012
Account lock outs
I have 50 users connecting to SQL server via ODBC using
TCP/IP to connect. But 2 of the users accounts keep on
having their windows accounts locked out.
Any suggestions?Turn on Windows auditing, maybe even SQL auditing as well. Have your users
log off and back on their computers and watch both security logs. NT
authentication for SQL doesn't ask for a password when connecting, it just
checks your Windows credentials. Are they mapping network drives before
connecting to SQL? Maybe the password credentials there are bad. You might
want to tell them to disconnect any network drives and remap them. Do a net
use as well and check for persistent connections.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Marcus" <anonymous@.discussions.microsoft.com> wrote in message
news:26ee01c3e18d$626c7820$a101280a@.phx.gbl...
TCP/IP to connect. But 2 of the users accounts keep on
having their windows accounts locked out.
Any suggestions?Turn on Windows auditing, maybe even SQL auditing as well. Have your users
log off and back on their computers and watch both security logs. NT
authentication for SQL doesn't ask for a password when connecting, it just
checks your Windows credentials. Are they mapping network drives before
connecting to SQL? Maybe the password credentials there are bad. You might
want to tell them to disconnect any network drives and remap them. Do a net
use as well and check for persistent connections.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Marcus" <anonymous@.discussions.microsoft.com> wrote in message
news:26ee01c3e18d$626c7820$a101280a@.phx.gbl...
quote:
> I have 50 users connecting to SQL server via ODBC using
> TCP/IP to connect. But 2 of the users accounts keep on
> having their windows accounts locked out.
> Any suggestions?
Subscribe to:
Posts (Atom)