 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / December 2008SQL Server to Microsoft Exchange
Hi I'm not sure if this is the right group, but I'm looking for information on how to get our Contacts database (which is in SQLServer) into a Public Address book on Microsoft Exchange. I trawled the net and found the following article on SQLServerCentral... http://www.sqlservercentral.com/articles/Miscellaneous/2985/ - however, I cannot find the website for xp_sql2exchange to download the scripts or find out more. First of all, does anybody have any information as to what happened to this set of scripts, where I might be able to download it, etc. Alternatively, can anyone point me in the direction of anything that does the same or a smilar job? Thanks, Dan > Hi > [quoted text clipped - 19 lines] > > Dan Hi Hopefully you are using Active Directory for contacts and you will need an ADSI connection. You can retrieve this information but not set/create it in this way. http://support.microsoft.com/kb/299410 should get you started. John > > Hi > > [quoted text clipped - 27 lines] > > John John, Thanks for the info. Currently we are using an SQL Server table to store our contacts database. From your response, I get the feeling you believe this to be a bad idea. Can you explain why using AD for contacts is better than putting them directly into Exchange or pulling them from SQL Server?! >> > Hi >> > [quoted text clipped - 44 lines] > Can you explain why using AD for contacts is better than putting them > directly into Exchange or pulling them from SQL Server?! Hi You can only query AD from a SQL Server linked server and not update it! AD may offer more availability than exchange, but you may want to look at the example http://msdn.microsoft.com/en-us/library/bb508823.aspx which uses exchange web services. John John, Thanks for the info. As far as I can work out, contacts in the AD / exchange store have to be "mail-enabled" in order to appear in the GAL. If we mail-enable a contact, they are given an @ourdomain.com email address. Is there any way to prevent this? We don't want 2000+ email accounts creating in Exchange for contacts that don't work here! Alternatively, the only way I can think of doing this is to poll sQL for the contacts, not sure if there are any examples of this anywhere?! Cheers Dan > >> > Hi > >> > [quoted text clipped - 53 lines] > > John > John, > [quoted text clipped - 13 lines] > > Dan Hi Dan You may want to ask these questions in and exchange newsgroup. My guess is that you don't need the local email address if this is a SMTP contact. John |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.