Logon failure while connecting to named pipe

Posted on 2006-04-21
Last Modified: 2010-04-13
hi all,

I am using a windows 2000 advanced server. I am trying to connect to SQL server using named pipeline. but due to some unknown reasons i am not able to do so.

I am getting following error:
Network error IOException: \\localhost\pipe\sql\query (Logon failure: the user has not been granted the requested logon type at this computer)

I am logged on to system using admin account. but for your information this is a hardened machine to some restrcitions have been but on it.

can some body tell me why am i getting this error.

Question by:navalarya1982
    1 Comment
    LVL 86

    Accepted Solution

    Is you SQL server running as a service under LocalSystem? That account isn't granted the right to log on locally.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now