Hi all,

I've been getting to grips with the excel services functionality of MOSS
2007 and am having a few problems. I have office 2007 installed on the
sharepoint test server and have been trying to create an Office Data
connection to my analysis services server. I am getting the follow error
when trying to get external data from the analysis service source:

Unable to connect to data source: Unable to locate database server. Verify
that the database server name you entered is correct, or contact the database
administrator for help.

I can access the same server using a database connection so it's not a name
resolution issue. This was also working previously, the only thing i can this
that has been changed is that on out test db/analysis server we had to
install sharepoint services and business scorecard manager for testing
purposes. Could this have caused something to get a little confused?

Any help anyone can provide will be much appreciated as i've been at this
for about 2 days now.

Cheers and thanks in advance,

Grant

Got the problem sorted. I had to repair the office installation and it worked
fine once I'd done that.



"GSwan" wrote:

Hi all,

I've been getting to grips with the excel services functionality of MOSS
2007 and am having a few problems. I have office 2007 installed on the
sharepoint test server and have been trying to create an Office Data
connection to my analysis services server. I am getting the follow error
when trying to get external data from the analysis service source:

Unable to connect to data source: Unable to locate database server. Verify
that the database server name you entered is correct, or contact the database
administrator for help.

I can access the same server using a database connection so it's not a name
resolution issue. This was also working previously, the only thing i can this
that has been changed is that on out test db/analysis server we had to
install sharepoint services and business scorecard manager for testing
purposes. Could this have caused something to get a little confused?

Any help anyone can provide will be much appreciated as i've been at this
for about 2 days now.

Cheers and thanks in advance,

Grant

The gods help those that help themselves.

Good to know that you kept plugging away at it while waiting for an answer -
something some don't do even when they could!

And GREAT of you to post to lets everyone know what the solution was. That
will be helpful to someone sometime in the future.

"GSwan" wrote:

Got the problem sorted. I had to repair the office installation and it worked
fine once I'd done that.



"GSwan" wrote:

Hi all,

I've been getting to grips with the excel services functionality of MOSS
2007 and am having a few problems. I have office 2007 installed on the
sharepoint test server and have been trying to create an Office Data
connection to my analysis services server. I am getting the follow error
when trying to get external data from the analysis service source:

Unable to connect to data source: Unable to locate database server. Verify
that the database server name you entered is correct, or contact the database
administrator for help.

I can access the same server using a database connection so it's not a name
resolution issue. This was also working previously, the only thing i can this
that has been changed is that on out test db/analysis server we had to
install sharepoint services and business scorecard manager for testing
purposes. Could this have caused something to get a little confused?

Any help anyone can provide will be much appreciated as i've been at this
for about 2 days now.

Cheers and thanks in advance,

Grant