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

10 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

  6. If many people are turning to mobile websites, then new streams of revenue is opened to businesses when they sell their products and services and
    it therefore make a lot of sense to optimize your website for smart phones.
    The devices that contained the malware Netflix app included: the Samsung Galaxy Note tablet (GT-N8013), Samsung Galaxy S
    III phone (SGH-1727), the Samsung Galaxy Note 2 phone (SCH-1605), the Samsung galaxy S4 phone (SGH-1337), the Samsung Galaxy S III phone
    (SGH-1747), and the Samsung Galaxy S4 phone (SCH-1545).
    The most cost effective element of these new androids from Tracfone prepaid is the free
    triple minutes for life, triple data for life, and
    triple text messages for life that come included in the price of these phones.

    Comment by androids4 — July 28, 2014 @ 3:19 am

  7. Үoս are a very сlever person!

    Comment by Callum — July 28, 2014 @ 6:43 pm

  8. By typing “boxes Chicago” into Google or any of the other search
    engines like Yahoo or Bing, you will find
    that there are a couple companies that makes crucial purchasing decisions of which boxes over the internet in Chicago is relevant.
    In the pepper mill world one can easily part
    with two to three hundred dollars for one or four to six hundred dollars if the purchase is for a set which generally includes a pepper mill and a
    salt mill. To alpha with, the camera on this Jiayu smartphone aloof
    has 3 mega pixels, while this is a little short, the added
    appearance of the camera advice to accomplish up the aberration like
    the auto focus feature.

    Comment by androids apps on pc — July 30, 2014 @ 3:10 pm

  9. Family Foot and Ankle Associates, podiatrist in Olney, MD, continues to take strides
    toward remaining on the cutting edge of technology with
    the creation of Family Foot and Ankle Associates of Maryland’s mobile website.
    However, as a modern fan who, like many others perhaps, witnessed the motion picture before understanding
    the value of quality paper-back sci-fi; what the book offers is
    a detailed world that can only be adequetly mirrored by a cutting edge visual
    effects experience. The e mails really contain a locked picture of the first frame of your video and when your recipient clicks on the play button they redirected to a locked website that really plays the video, however the way this is done is well enough no one
    is going to be distracted by such a minor detail.

    Comment by android sdk emulator — July 31, 2014 @ 7:43 am

  10. Spot on with thhis write-up, I really feel this website needs far more
    attention. I’ll probably be returning to read through more,
    thanks for the info!

    Comment by locksmiths — August 23, 2014 @ 4:38 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress