Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2000 and Active Directory

Author  Topic 

-wing-
Starting Member

12 Posts

Posted - 2006-11-17 : 12:07:29
It's me again guys. First let me say that I truly appreciate the knowledge that I see on this forum. Now on to my question.

How can I use SQL Server to import the active accounts from our Exchange Server? Thanks.

Everything I know I learned from the web.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-11-17 : 12:27:32
you need to create a linked server to active directory

http://www.thescripts.com/forum/thread78906.html



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

-wing-
Starting Member

12 Posts

Posted - 2006-11-17 : 12:56:37
Thank you for the response. The link you had did help but ultimatley it was this link to got the answer for me. I got an error

Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare returned 0x80040e14].


googled it and found the below link. It's a little rough but workable now.

http://adsdsoobject.codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx

Thanks for the lead :)

Everything I know I learned from the web.
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-11-17 : 13:08:47
http://www.codeproject.com/aspnet/LikeDataStores.asp

I like the quote at the end of your postings. "Everything I know I learned from the web." A good practice in troubleshooting errors from SQL Server is to take that first line starting with "Server:" and post it into the Google search bar. You'll find answers pretty quickly to many of the errors.


MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

-wing-
Starting Member

12 Posts

Posted - 2006-11-17 : 16:38:16
Thank you very much Derrick. When I learned about google, I hardly ever hit news groups or forums unless I can't find it on the net somewhere. Most times, it's a combination of 2 or 3 sites that gives me the full answer of whatever I am searching for. I learned more about programming from the internet that anything that college tried to make stick in my head. :)

Everything I know I learned from the web.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-11-18 : 02:33:14
You need to be careful though - there is plenty of useless/bad/harmful code out there.


SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org
Go to Top of Page

-wing-
Starting Member

12 Posts

Posted - 2006-11-18 : 12:12:22
I appreciate the tip Jezemine. One thing I don't like to do is copy and paste code. I use the code that I find as an example and tweek it to what I need. Like I stated in my previous post, very rarely do I find the answer to my question on one site. It's generally a combination of two or more. I am sure I will be posting here again for some solutions or questions. This site seems to have a wealth of knowledge that a sponge like myself can suck up.

Everything I know I learned from the web.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-11-18 : 13:03:57
Here's an example of harmful code that I ran across the other day. It shows you how to "encrypt" connection strings using base64. DO NOT DO THIS! It's totally bogus as it's not a method of encryption at all. This guy would have done better just to keep quiet, as I am sure there are plenty of copy/pasters out there using this code... :) I admit, he does say it's not real encryption in the article. But why not do it right and use DPAPI or some such if you are going to all the trouble of writing an article???

http://www.dotnetbips.com/articles/displayarticle.aspx?id=254


SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org
Go to Top of Page
   

- Advertisement -