Solved

ODBC connetion to Exchange fails: Verify connection params / credentials?

Posted on 2006-11-20
9
657 Views
Last Modified: 2010-05-18
I am attempting to connect SQL Server 2005 (Express Edition) to a public folder of contacts on Exchange 2003 (both running on the same SBS server).

I have followed the instructions in SQL Server 2005 Online books: (http://msdn2.microsoft.com/en-us/library/ms191461.aspx) creating my link:

EXEC sp_addlinkedserver 'exchange', 'Exchange OLE DB provider', 'exoledb.DataSource.1', 'file:\\.\backofficestorage\localhost\public folders'

and then tried the simple query to verify the connection:

SELECT "urn:schemas:contacts:sn","urn:schemas:contacts:givenname"
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn", "urn:schema:contacts:givenname" FROM SCOPE(''.\Common Contacts'')')

Everytime I do, I receive the following error:

Msg 7304, Level 16, State 2, Line 1
Cannot connect using OLE DB provider "Exoledb.DataSource" to linked server "Exchange". Verify the connection parameters or login credentials associated with this linked server.

The account i am using to login to SQL Server is an admin on the SBS Server as well as an owner of the Public Folder "Common Contacts".
What am i missing?!? This is very urgent!
0
Comment
Question by:mrtgold
  • 4
  • 3
9 Comments
 
LVL 30

Expert Comment

by:nmcdermaid
Comment Utility
What is the SQL Server and SQL Serevr agent service running as? Temporaily change these to domain admin, stop and restart, and try it again.
0
 
LVL 2

Author Comment

by:mrtgold
Comment Utility
Good suggestion - it was running as LocalSystem, but changing it to my account (I am a Domain Admin) didn't work  - still received exactly the same error message.
Created a new Domain Admin account and tried it with that - still same error.
0
 
LVL 30

Expert Comment

by:nmcdermaid
Comment Utility
Did you try doing it to both SQL Server and SQL Server Agent accounts?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 2

Author Comment

by:mrtgold
Comment Utility
Is there a SQL Server Agent with 2005? I don't see it in Services or in the SQL Server Configuration Manager and there is no sqlagent.exe process running...
I changed all the services that were there:
SQL Server
SQL Server Browser
SQL Server FullText Search (just in case...)
0
 
LVL 30

Expert Comment

by:nmcdermaid
Comment Utility
I've got something called SQL Server Agent in my services, also I have SQL Server agent in Management studio.

Maybe you have the express version? Anyhow, that probably isn't it.


That document says:

>> the URL corresponding to the root folder of the Web Store

It sounds like there is some kind of web setup required first, are you aware of anything like that?


Also its a long shot but you could try removing the .1 from provider name as below:

EXEC sp_addlinkedserver 'exchange', 'Exchange OLE DB provider', 'exoledb.DataSource', 'file:\\.\backofficestorage\localhost\public folders'

The .1 is a version specific provider whereas without the .1 it will pick whatever provider version you have... though it is a long shot.

0
 
LVL 2

Author Comment

by:mrtgold
Comment Utility
The lack of the SQL Agent is probably because of it being the Express Version.  I hope that is not the root cause of the problem be cause my client has emphatically stated he's not going to move to the full version.

"Web Store" refers to Exchange server and how you access data in there. I definitely have permissions to the Public Folder i'm attempting to access - or at least i've given both my login as well as the newly created Domain Admin account all privelages i can find - we are owners, administrators, clients, users, etc.

Already tried removing the .1 - no difference.

Given the project deadlines, i have all but abandoned this track and have begun on a different approach - building an intermediary synchronizing app that can access both the Exchange and the SQL datastores - but i really don't like this approach and would much rather use a real data provider so i'm still hoping that someone will come up with a solution...

Thanks,
tim
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
Comment Utility
I suggest that you download FileMon from sysinternals.com and monitor the particular file that you are trying to open. This tool will tell you:

1. What account is trying to open it
2. Whether its successful.

FileMon is a very lightweight and eay to use tool. Even though your timelines are shrinking, its well worth having a go.

0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now