hi

My SQL server was installed with Service Pack 2 and with
some hotfixes upto the last one issued in January for
MDAC. The new patch for MDAC is applied on server. Before
that MDAC version was MDAC 2.7 SP1 Refresh.

This server is used for OLAP purposes. User is using Excel
to connect to Analysis Manager and retrieving the records
from the Cube.

After installing the service Pack 3, user was unable to
connect to the servers. MultiDimensional Connection Box
will come up first. Then a message box (named : open
connection failed) will come with a message
saying ..."Unable to open connection. Cannot Load
databases;version may not be valid. Connection to the
server is lost." But using a administrator account I am
able to connect.

I found no way to connect as user....so I uninstalled
everything..and revert to old service pack..Now i am able
to connect.

I need to patch SQL server with service pack 3. Is the
above situation can be solved? Thanks in advance for any
help regarding this...

Regards
sajith S

I have seen a similar problem myself moving to SP3. Have you installed PTSLite on the client ? This is the client side install for SP3. I have not managed to get a pre-SP3 client to connect to an SP3 server.

You can find this buried in the bowels of the AS SP3 package. There are two versions PTSFull and PTSLite the former comes with MDAC but it seems you have done that step already.

This is definitely the issue. You have to upgrade the
client machines PTS also.

side install for SP3. I have not managed to get a pre-SP3
client to connect to an SP3 server.
former comes with MDAC but it seems you have done that
step already.