SQL Server Named Instance - SQL 2005 SP2

[patemarie]

We upgraded our SQL 2000 to SQL 2005, SP2 and all seems well with Project
Server 2003 and its components. However, I am attempting to initiate a Cube
and when I input the new server name (which is using a named instance) on the
"Update resource tables and OLAP cube" page in PWA, I receive the error
message that illegal characters are being used. The named instance is
yatta-DEV\STI1,1123. I've tried every variation and still get the illegal
character error message. Is there any work around? I've tried the IP
address and receive the "Could Not Connect to OLAP Cube" which I believe is
attributed to some components of SQL 2005 which need to be installed on the
app server. But I think I need to get past the server instance name issue
first.

Thanks for any suggestions.

 

[Gary L. Chefetz [MVP]]

The comma is a list separator for SQL running under English. This is likely
your problem.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[patemarie]

I have tried removing the last piece of the server instance name and still
get the error message. But, Gary, when I try the IP address on our
Production box it works fine and will build a cube. Logically, I would think
that would be the same in our test environment but I do get the "Could Not
Connect to OLAP Cube" which, again, I believe is attributed to some
components of SQL 2005 which need to be installed on
the app server.

But, if all SQL 2005 components were installed on the app box (per
http://support.microsoft.com/default.aspx/kb/921116) I should be able to use
the IP address in lieu of the server instance name, correct?

Thanks, again!

 

[Ben Howard]

You'll need to install the SP mentioned in KB921115. Any client accessing
Portfolio Analyser will need the AS 9.0 OLE DB provider also.

I just blogged some of this earlier this week, so its worth checking out the
link below.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

 

[patemarie]

Yes, definitely, that is a pre install to the KB921116 I mentioned
previously. But with all that installed, can anyone tell me if I would be
able to build an OLAP cube using the IP address of the database server
instead of the named instance (yatta-DEV\STI1,1123) which the "Update
resource tables and OLAP cube" page in PWA will not accept in any form?

Using the IP address is accepted on our production box but that is still SQL
2000, hence the question now using SQL 2005, SP2.

Thanks for any assistance.

 

[Ben Howard]

Hi, what do you mean it won't accept it? With a named instance, on some
screens, you should cut and paste the server\instance as the \ is not a valid
typed character.

IMHO you should be then able to build the cube. Let me know

 

[patemarie]

I have cut and pasted it but the "Update resource tables and OLAP cube" page
in PWA will not accept the named instance in the form provided. We'll try
installing the Project Server SP2a hotfix and then the subsequent SQL 2005
components and will attempt it again. I'll post back with our results.
Thanks Ben!

Patti

 

[Ben Howard]

Hi Patti,
I think the issue might be this - when PS2003 was developed it was written
to support SQL2000, and AS wasn't available on a named instance. SQL2005 is
different, but PS2003 hasn't been updated to support this featre.