Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How can I allow all users access to named pipes.

Posted on 2007-12-03
2
Medium Priority
?
1,940 Views
Last Modified: 2013-11-28
Im having trouble running reports from a MSAccess 2000 database via tables linked to a SQL 6.5 database. ODBC SQL driver version 2000.85.1022.00

When the reports are run by an administrator the ODBC connection runs via named pipes as expected. However for regular users the ODBC connection defaults to TCP/IP and the queries take an inordinate amount of time to run or fail to complete.

When a user attempts to reconfigure the ODBC connection to named pipes, they get the following message from SQL Client Network Utility.

Your login account does not have the permissions required to make this operation. Consult your system administrator to obtain the required permissions in your windows registry.

If the user is given administrative rights the ODBC connection configuration then defaults to named pipes.
0
Comment
Question by:russell_its
2 Comments
 
LVL 4

Accepted Solution

by:
Sowmya_K earned 1500 total points
ID: 20401194
Hi,
Machine\Users should have access to the following key on the local machine:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo

Local machine users group requires;
Query Value, Enumerate Subkeys, Notify & Read Control

Hope it helps!
0
 

Author Comment

by:russell_its
ID: 20408112
Hi
Thanks for the info. Users had those permissions already but it pointed me in the right direction.
Using regmon I found that when attempting to modify the ODBC connection method, access was being denied to CreateKey in both

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo and HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\DB-Lib.

Consequently I had to add Set Value and Create SubKey to the local machine users group
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

564 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