[dba-SQLServer] Fixing MS SQL catalogue

Jim Lawrence accessd at shaw.ca
Wed Aug 20 16:58:24 CDT 2008


Hi All:

I have been trying to fix my MS SQL’s catalogue on the main Server.

The process to fairly simple to do this:
1. Go to the command prompt, in adminstration mode, with all limits off.
2. Stop the service: net stop cryptsvc  stops fine. (I also turn off the SQL)
3. Rebuild the catalogue file: esentutl /p <%systemroot%>\System32\catroot2\{F750E6C3-38EE-11D1-85E5-00C04FC295EE}\catdb
4. …and then it should be as simple as restarting things: net start cryptsvc

The problem is that stage number 3 ‘access is denied’? Example:
C:\Program Files\Support Tools>esentutl /p <%systemroot%>\System32\catroot2\{F750E6C3-38EE-11D1-85E5-00C04FC295EE}
Access is denied.

Seeing all attached processes have been stopped and I am in GOD mode what is this????

Any thoughts??

Jim





More information about the dba-SQLServer mailing list