January 23, 2010 at 1:14 am
Hi...
i am trying to start the sql server but i could not. when i check the error log file i found the following error message. can you explain what does it mean and how to resolve this issues ? let me know if you need more information on this to find out the cause.
2010-01-23 11:08:06.46 Server Error: 8313, Severity: 16, State: 1.
2010-01-23 11:08:06.46 Server Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.
2010-01-23 11:08:06.46 Server Error: 3409, Severity: 16, State: 1.
2010-01-23 11:08:06.46 Server Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
Sql server 2005 Standard version
Thanks in advance.
January 23, 2010 at 4:04 pm
It looks like you might have a corrupted registry string.
Check the following:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 27, 2010 at 12:28 am
CirquedeSQLeil (1/23/2010)
It looks like you might have a corrupted registry string.Check the following:
i coud not resovle this issue by using the link which you have mentioned above. can you tell me how to restore the sql server registry ?
January 27, 2010 at 12:38 am
Just running through the items in that post:
1. unlodctr/lodctr was unsuccessful? There was a link to a microsoft article on the subject.
2. Is remote registry service running?
3. You have disabled VIA in NETWORK SETTING using SQL Server Configuration Manager?
4. This list of permissions has been verified?
The following rights need to be added (manualy) to the new account via Local security Policy:
Log on as Service
Log on as a batch job
Locks pages in memory
Act as part of the operating system
Bypass traverse checking
Replace a process level token
note1: being local administrator on the machine is not enough
note2: for a non local administrator you also need access to read the registry and read-write access on all sql server files
note3: if you fill in the correct sql service account in the installation procedure, all this is done automatically.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 27, 2010 at 3:43 am
This gentleman had the same issue and was able to resolve. It might be helpful for you...
http://www.sqlservercentral.com/Forums/Topic288705-149-1.aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply