Showing posts with label removing. Show all posts
Showing posts with label removing. Show all posts

Wednesday, March 21, 2012

Re-Installation of SQLExpress on XP SP2 Chinese Tra Version

When I installed SQL Express first time a few days ago, it work ok. But, after removing all sql server componets through 'control panel'->'add or remove programs,' something seems wrong in the registry because the re-installation of SQLExpress will never success with an error

-

- Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online.

in setup configuration checker. I follow the instructions in help page and try to set the values "Last Counter" and "Last Help" in '[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]' as same as the values "Counter" and "Help" in '[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]'.........but the data type are dword and string resp. So, setup checker will think the values are different and no way to reinstall the SQLExpress.

Can anyone tell me how to fix it or just let me know SQLExpress not for Chinese XP SP2?

Thank you

Hi Andrew,

I've looked over the instructions that you're reading and they are a bit difficult to follow, but they do work once you figure it out. The issue is that you need to find the maximum value for the Counter and Help keys, but because of the data type of the key, the maximum value is not necesarily the last one in the list because they are not sorted numerically. Try to follow the instructions again, but this time when you're looking up the values, be sure to examine all the numbers to get the highest one. Remember they are sorted as strings, so the value list may look like...

1, 10, 11, 12, 13, 14, 2, 3, 4, 5

In this case the highest number if 14, which is in the middle of the list, not the 5 at the end. The first time I went though this myself I automactically picked the last number in the value list assuming it was numerically sorted; I was wrong. Hopefully this will solve the issue for you.

Mike

|||Thanks for your explanation and the problem is solved. sql

Reinstall of RS on a 64 bit box

We have had the same issue on three 64 bit boxes when we tried to
reinstall RS. After removing RS and reinstalling when running the RS
configuration tool, when we hit the 'find' button it just blinks and
nothing happens. When running a profile in the back ground we see it
is trying to run the 'getverison' stored procedure in the master
database. This sp exists in the RS database. Since we have just done
a reinstall and not yet configured the system should realize the RS db
does not exsist and not even run this sp. I have tried restoring the
RS dbs from backup. Creating all of the RS objects in the master db
(I know not a good idea) nothing helps. I opened a PS case with
Microsoft. They suggested removing RS as well as the client tools.
This worked on 32 bit boxes, but not 64. I spent a month on this PS
case and they could only suggest rekicking the box.
Any ideas?On Aug 23, 5:14 pm, jim.stei...@.rackspace.com wrote:
> We have had the same issue on three 64 bit boxes when we tried to
> reinstall RS. After removing RS and reinstalling when running the RS
> configuration tool, when we hit the 'find' button it just blinks and
> nothing happens. When running a profile in the back ground we see it
> is trying to run the 'getverison' stored procedure in the master
> database. This sp exists in the RS database. Since we have just done
> a reinstall and not yet configured the system should realize the RS db
> does not exsist and not even run this sp. I have tried restoring the
> RS dbs from backup. Creating all of the RS objects in the master db
> (I know not a good idea) nothing helps. I opened a PS case with
> Microsoft. They suggested removing RS as well as the client tools.
> This worked on 32 bit boxes, but not 64. I spent a month on this PS
> case and they could only suggest rekicking the box.
> Any ideas?
You might want to make sure that you removed all of the Reporting
Services components in the registry and possibly even the Assembly
references in the GAC. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant