Programming

Programming Questions? Ask a Programmer for Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Programming

Running Sql Server Express 14.Using Windows Authority.Using

Customer Question
Running Sql Server Express 14. Using...
Running Sql Server Express 14.
Using Windows Authority.
Using WorkGroup (not domain).
Running Windows 7 on 2 computers.
Programming in Delphi and ADO.
Wrote a stored proc that runs OK on the server.
When I run the program on the client computer, it access a table on the server, but, when the program attempts to execute the stored proc, I get the message:
MultiWait Error= The user does not have permission to perform this action
I need help to eliminate the error message.
Submitted: 2 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Customer reply replied 2 years ago
(Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from yo. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Customer reply replied 2 years ago
I do not understand "Let me know if you need more information, or send me the service offer(s) so we can proceed".
Answered in 4 hours by:
6/8/2015
Programmer: Ingo U, Software Engineer replied 2 years ago
Ingo U
Ingo U, Software Engineer
Category: Programming
Satisfied Customers: 757
Experience: Over 25 years experience in software development. Expert in Microsoft .Net, C#, C++, VB, SQL
Verified
You probably need to explicitly grant execute access to the stored procedure for remote user on the server. Maybe more. If you can remotely "access" the table in some form, it sounds like basic authentication for the remote user is in place.
See
https://msdn.microsoft.com/en-US/library/ms345484.aspx
Ask Your Own Programming Question
Customer reply replied 2 years ago
Thanks for the reference to "Grant Permission on a Stored Procedure".
I completed the steps down to
7.Click Browse to display the list of users or roles. Select the users or roles to whom permissions should be granted.
I Need to grant permission to a program running on the client Windows 7 computer.
In SMSS, how do I do authorize or give permission to a login or user on the client computer?
Dave
Programmer: Ingo U, Software Engineer replied 2 years ago
well the SQL/windows authentication scheme has been a recurring cause of headscratching seemingly forever.
As an easy attempt, I would try giving access to 'guest' and/or 'public' (since you seem to be on an isolated home network that should be OK). Once you click that Browse button at step 7, those should be among the choices you can select.
Depending on how you've set up your windows user accounts on both machines, it's unclear exactly how your client program is authenticating itself to the server. Are you using a connection string with an explicit username/password? Or does it contain "Integrated Security=True" somewhere?
Ask Your Own Programming Question
Customer reply replied 2 years ago
I have previously given access to guest and/or public.
I have tried client authentication with 1) explicit username/password ***** 2) Integrated Security=True".
So far, the client computer continues to produce the message:
"MultiWait Error= The user does not have permission to perform this action"
From above:
I Need to grant execute permission to a program running on the client Windows 7 computer.
In SMSS, how do I do authorize or give permission to a login or user on the client computer?
The answer will be complete when we can eliminate the MultiWait message.
Programmer: Ingo U, Software Engineer replied 2 years ago
My apologies,
I am out of ideas on this one at the moment.
I am opting out and opening the question up to other professionals here who may be able to help.
Regards,
Ingo U
Ask Your Own Programming Question
Programmer: Ingo U, Software Engineer replied 2 years ago
I do have one additional idea. In some cases, I've had better luck when user accounts were named the same on multiple workgroup machines, and had the same password. So if your SQl server machine has a user named "Tom", try creating an identical "Tom" user on the client machine, with the same password, and access the server from the client machine while using the "Tom" account.
There is some info out there to support this:
http://dba.stackexchange.com/questions/15056/howto-use-windows-authentication-with-sql-server-2008-express-on-a-workgroup-net
Ask Your Own Programming Question
Ask Ingo U Your Own Question
Ingo U
Ingo U
Ingo U, Software Engineer
Category: Programming
Satisfied Customers: 757
757 Satisfied Customers
Experience: Over 25 years experience in software development. Expert in Microsoft .Net, C#, C++, VB, SQL

Ingo U is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,131 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

800 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I need to locate or reset the password on. I have gmail on
I need to locate or reset the password ********@******.*** … read more
Isaac Franklin
Isaac Franklin
Associate of Science in Social Sciences
976 satisfied customers
Can not log in to excel or word---: Microsoft stopped
can not log in to excel or word---: Microsoft stopped working" … read more
Isaac Franklin
Isaac Franklin
Associate of Science in Social Sciences
976 satisfied customers
Using Windows 7 and Excel 2010. In the first (labeled
Using Windows 7 and Excel 2010. In the first (labeled 'Date') column, several of the dates have been replaced by a series of pound (#) signs. The computer knows and retains the correct date (it shows … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I can't open an existing excel spread sheet from the file
I can't open an existing excel spread sheet from the file itself. I have to open excel first then select the file to see the data. I'm unable to do a mail merge to word by selecting the data file. I h… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
I was wondering how easy it is to edit transactions on my
I was wondering how easy it is to edit transactions on my bank statement … read more
Isaac Franklin
Isaac Franklin
Associate of Science in Social Sciences
976 satisfied customers
I need to return an x,y from a ArcGIS rest service. Trying
I need to return an x,y from a ArcGIS rest service. Trying to use use a requests module. no luck. I am a beginner in python, but got a task at work that I can not do. … read more
Kris R
Kris R
IT Manager
Computing
2,654 satisfied customers
I do have one workbook and within one sheet, I try to insert
I do have one workbook and within one sheet , I try to insert 6 Lines and paste with others lines which I want to same format . Excel not response and freeze … read more
Dustin
Dustin
Support Technician
7,623 satisfied customers
I'm having problems with using my bank app. Banking on line.
Banking on line. The java I'm using I have no idea I just want to delete it … read more
Dustin
Dustin
Support Technician
7,623 satisfied customers
How do I within Excel do you write within the same box on
Hello Pearl, How do I within Excel do you write within the same box on the second or third line? … read more
Lorenz Vauck
Lorenz Vauck
Computer Expert
Electrical Engineering
71 satisfied customers
I am on Windows 7. At times either google chrome, adobe, or
I am on Windows 7. At times either google chrome, adobe, or excel will stop running while I am using them. I received a message stating the "saver screen" had stopped working. How do I correct this pr… read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
Can i talk to you on the phone cause i really really need
can i talk to you on the phone cause i really really need help … read more
Dustin
Dustin
Support Technician
7,623 satisfied customers
I need an Excel macro to list a value X<50, but<100 for a
I need an Excel macro to list a value X<50, but<100 for a work sheed. … read more
George Sibiya
George Sibiya
PhD
217 satisfied customers
Wondering whether there's a compression software for word
Wondering whether there's a compression software for word docs I can use to reduce my wordpress files? Dave C. … read more
Mr.Med
Mr.Med
945 satisfied customers
I brought in my computer to get fixed and now when I type in
Pearl, I brought in my computer to get fixed and now when I type in the password ***** Wordpress that I've used for 7 weeks, it doesn't work. Then I go to their help and it doesn't work, resetting the… read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
581 satisfied customers
I have an excel question. I have 300 excel files all mapped
I have an excel question. I have 300 excel files all mapped to a master sheet. I need the 300 excel files to auto update without me having to open them, how do I do this? … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
800 satisfied customers
I updated java now I cant get any games to work on Interner
I updated java now I cant get any games to work on Interner explorer or Firefox … read more
R LAFAYETTE
R LAFAYETTE
Intel Technology Provider 2017 GOLD
37 satisfied customers
I need help upgrading a SQL2005 Express to SQL 2012 - any
Hi I need help upgrading a SQL2005 Express to SQL 2012 - any experience? … read more
Cody
Cody
Computer Science
1,716 satisfied customers
I cannot download Javascript, Windows 7 64 bit home premium,
I need to get on certain websites that require Java Script, I have never had this problem before … read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x