December 1, 2003 at 12:11 am
Hi All,
I am using Win XP Pro (SP1), SQL Server 2000 Developer (SP3). After installing SP3 when i try to connect to Analysis Services i get an error. "Unable to connect to the registry of the Server <Server Name>". I am dministrator of the system and i dont have any permissions issues. I have tried to reinstall the SQL server but no luck and now i am stuck.
Waiting for urgent reply.
Thanks in advance.
Kind Regards,
Affan
December 4, 2003 at 8:00 am
This was removed by the editor as SPAM
December 4, 2003 at 9:25 am
If you have Analysis Services running on a server and are trying to connect from your desktop, you will get the error you described if you did not install the same Service Pack for Analysis Services on your desktop that you installed on the server.
December 4, 2003 at 10:09 pm
But i amd trying ot connect it to the enterprise manager of Analysis services and i ma using a single machine and it used to work in case of win2k professional.
December 4, 2003 at 10:41 pm
You may want to review and try the things suggested here... http://www.dbforums.com/t880646.html
Also, make sure you have loaded (maybe even reload) SP3 (this was a known issue pre-SP1 http://support.microsoft.com/?id=307365
HTH,
Steve.
Steve.
December 5, 2003 at 12:22 am
Add on to the problem i want ot ask one question, is there any difference between SQL Service Packs and Analysis Server Service Packs. coz i have found in some articles that apply Analysis Services SP1 or later. Does SQL server 2000 SP3a contains fixes for Analysis Services or is there sperate Service Packs which we need to apply. My understanding is that SP3a should conatain fixes for all relevant SQL Server 2000 Products.
Regards,
Affan
December 5, 2003 at 9:11 am
When you get an SP for SQL Server it includes seperated SPs for the database and for Analysis Services.
December 7, 2003 at 5:30 am
Crucker1 is right. If you got your SP on CD, look for the msolap folder, it will contain the Analysis Services service pack (for the server, and the sub-folder of DTS is for your client machines).
If you downloaded it from MSft, you definitely need to download a separate service pack exe for AS and for the relation engine.
HTH,
Steve.
Steve.
December 7, 2003 at 10:16 pm
Thanks every body,
Yes, when i installed SP from CD it had a spereate folder and i installed it and now its working fine, every problem is solved. and downloaded SP does not contain the analysis services SP.
Thanks again,
Regards,
Affam
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply