www.nuneworld.net

September 22, 2011

Event Viwer Error ODBC

Filed under: info — admin @ 8:56 am

Perfmon

Short:

You are runign in services.mcs  Smlogsvc.exe service and that service is run under Network Service account that have no privilege to read  data from MS SQL bin folder. Locate your MSSQL bin folder add permisons to  Network Service to be able to read.

Long: http://support.microsoft.com/kb/912399/en-us

The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Error in d:\nt\enduser\databaseaccess\src\mdac\odbc\core\dm\perf.c(349), Access is denied.

: Failed to create mutex for MS ODBC Perf File Mapping.

Couse:

This problem occurs because the Performance Logs and Alerts service (Smlogsvc.exe) does not have sufficient permissions to access the performance counter DLL or the “bin” directory and “bin\en” directoryfor SQL Server 2005 Analysis Services.

On a Windows XP-based computer, the Performance Logs and Alerts service runs under the Network Service account. However, the Network Service account has limited permissions on the local computer. The Network Service account cannot access the performance counter DLL or the SQL Server 2005 Analysis Services “bin” directory and the “bin\en” directorywhen you collect data from SQL Server 2005 Analysis Services performance counters.

Solution:

To resolve this problem, you must grant the Read & Execute permission to the Network Service account on the performance counter DLL for SQL Server 2005 Analysis Services. The DLL is located in the following folder:

C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Bin\Msmdctr90.dll

Additionally, you must grant Read permissions to the Network Service account on the “bin” directory and the “bin\en” directory for SQL Server 2005 Analysis Services. For example:

  • C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin
  • C:\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\bin\en

Note MSSQL.x represents the corresponding value for the instance ID in the system.

For more information about how to grant permissions to a specific folder in Windows XP, click the following article number to view the article in the Microsoft Knowledge Base:

308419 How to set, view, change, or remove special permissions for files and folders in Windows XP

resource: Microsoft

5 Comments »

  1. I wanted to thank you for this fantastic read!! I absolutely loved every little bit of it.
    I’ve got you book marked to check out new things you post…

    My web blog :: best 24 hour brentwood locksmith service

    Comment by best 24 hour brentwood locksmith service — May 4, 2014 @ 8:39 pm

  2. Do you mind if I quote a couple of your posts as long
    as I provide credit and sources back to your webpage?
    My blog site is in the very same niche as yours and my users
    would genuinely benefit from some of the information you provide here.
    Please let me know if this okay with you. Thank you!

    Comment by Trina — July 9, 2014 @ 10:21 pm

  3. I do accept as true with all of the ideas you’ve offered for your post.
    They’re really convincing and will definitely work. Still, the posts are too brief for starters.
    Could you please lengthen them a bit from next time?
    Thanks for the post.

    Comment by house painting denver colorado — July 10, 2014 @ 1:18 am

  4. Hi, I do believe this is a great website. I stumbledupon it ;) I will return once
    again since I book marked it. Money and freedom is the best way to change, may you be rich and continue
    to guide others.

    Comment by dog training houston prices — July 10, 2014 @ 2:11 am

  5. Ҭhiѕ post іs invaluable. When can I find out more?

    Comment by jimmy — July 10, 2014 @ 11:12 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress