SQL Server Credentials Problem

We're having some users get the following message, periodically, when using an internal, home-grown SQL Server application.
"You do not have sufficient credentials in SQL Server to use this program. Please contact the system admin."

Now I've searched all over the place, and I cannot find ANYTHING referencing this message. I see lots that reference one that uses the word "privileges", but not one with the word "credentials". I have no idea what this is about, or why no one else has, apparently, ever seen this message. I have no idea what this is about, or what to do about it. (I'm attaching a screen shot of the message.)

Anyone else ever hear of this?
SufficientCredentials.png
LVL 8
David SpigelmanPresident / CEOAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
This is a custom message of a custom application. you need to ask the developer/administrator of this application.

Possible issues:
- Removed, dropped permissions.
- Bad error handling in the application.
- When Windows Authentication is used, network issues interfering while creating/transferring Kerberos tickets.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David SpigelmanPresident / CEOAuthor Commented:
Not sure it's a custom message, per se. We'll have to talk with the developer, who is aware of the problem so we'd have thought she might have mentioned something if she knew she coded it. Who knows. But your last suggestion is along the lines of what we're thinking. We think it's a problem with the NETLOGON service, which is throwing events showing that it is losing its connection. It eventually regains it, though. We're trying a few things to see if we can figure out what's going on. I'll keep you posted. Thanks. (I'm a network guy, not a database guy.)
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's not a SQL Server error message so it must really be a custom error from the application. Look what it says:
"You do not have sufficient credentials in SQL Server to use this program. Please contact the system admin."
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ste5anSenior DeveloperCommented:
But I'm sure :)

NETLOGON??
0
David SpigelmanPresident / CEOAuthor Commented:
NETLOGON. Go figure.
0
ste5anSenior DeveloperCommented:
With more than 20 years experience, I know what NETLOGON is..

This was the short form of:
Explain why do you think the NETLOGON process has something to do with it.

Cause "SQL Server credentials"  - either SQL Authentication or Windows Authentication - has nothing to do with NETLOGON.

SQL Authentication means additional user/password credentials, Windows Authentication means Kerberos delegation. Any error here should throw a different error message.
0
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Can you ask the developer if they are checking for any specific permissions that a user must have on the database? Also, if the user needs access on any system databases?

It is very easy to use a function or access a view that needs either administrator rights or at least access to more than one database. In the production deployment, users are fairly restricted and typically have only the required access to the required database. Hence, if the application is trying to use something that's locked out for the user, the application may be throwing this custom error about "SQL Server Credentials".
0
David SpigelmanPresident / CEOAuthor Commented:
@ste5an - No offense intended. It's something that we have noticed a possible correlation with, on the machines that have problems. We were thinking that, if that service crashes on those machines, they might lose their ability to authenticate to the SQL server, which might trigger the error. That was the thought. Now maybe it's incorrect, but I didn't think it was entirely crazy.

Based on this discussion, we did go back to the developer, who did acknowledge that the original error was her own text. She said that it is being triggered by an underlying connection error to SQL Server. The error she thinks it's tied to is one that says:

Failed to open a connection to the database

"A network-related or instance-specific error occurred while establishing a connection the SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error 0 - the wait operation times out.)"

Check the connections and try again.

The problems we see are:
  1. It's not happening on all machines. And even the ones it does seem to affect, don't have it happen all the time, or even at the same time.
  2. It doesn't happen consistently.
  3. We've checked cables to the affected computers. They all test out fine.

So it seems to be a "connection" issue, but there doesn't seem to be a connection problem. We were thinking about whether changing timeout periods might help. But mostly, we're lost as to how to explain this problem. Any other thoughts?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Changing the timeout won't solve this. You said that's not happening on all machines but in those machines that are happening, they have any difference from the others?
0
David SpigelmanPresident / CEOAuthor Commented:
That is correct. Just on a few machines.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
What's different from those machines to other machines?
Are they in a different domain or network?
0
David SpigelmanPresident / CEOAuthor Commented:
Problem went away. Probably a developer problem. Nothing in this thread helped it, so I'm not really sure how to award points for it.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just delete the question.
Cheers
0
ste5anSenior DeveloperCommented:
Problem went away. Probably a developer problem.
So, exactly what I first wrote :)
0
David SpigelmanPresident / CEOAuthor Commented:
Okay, ste5an. I couldn't figure out how to delete the question, so I just awarded it to you. Done.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.