Re: multiple-step ole db operation generated errors? (Member of proble

Hidarisei (Hidarisei@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I get this error when I run my ado query object which in turn runs a
stored proc.

Unfortunately, that's a very generic error, and it can be quite difficult
to say what is going on. Could you post the ADO code as well, in case
that could give a clue?

CREATE PROCEDURE sp_InsertUserLogonDateTime

Generally, you should not call your stored procedures sp_something, as
this prefix is reserved for system procedures. Whether this has anything
to do with your issue, I don't know, but try renaming to rule out the
possibility.

SQLServer is installed on the system where the domain controller/active
directory is.

There is a strong recommendation that you should not run SQL Server on
domain controllers. Again, I don't know if this has anything to do with
your issue. I would not really think so, but I cannot rule it out.

Everything is fine if I set each user to be a member of the builtin
administrator group of the server. But if I set the user to be only a
member of the Domain Users group, or any other groups, I get this error
msg.

And you granted Domain Users access to this procedures?

Which version of SQL Server are you using?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • handling errors from stored procs
    ... SQL Server 2000 ... comprise the call to a stored proc ... the stored proc gets run...if so, it would be nice if the Access app ... - when stored proc encounters error, it returns that error message ...
    (comp.databases.ms-access)
  • RE: OpenDataSource "Unspecified Error" when connecting to local Excel
    ... Are there any another hidden permissions required for the OpenDataSource ... the file is on the local Sql Server. ... > Even if I add domain users to the server administrator role, ... > local administrators group on the Sql Server? ...
    (microsoft.public.sqlserver.connect)
  • Re: Retrieve error text from extended stored proc
    ... was only on first execution, the following executions, error number was 0. ... However, use OSQL with the -m-1 switch, and you will see that the RAISERROR ... Tibor Karaszi, SQL Server MVP ... > When I call the stored proc from Query Analyzer and force an error, ...
    (microsoft.public.sqlserver.programming)
  • Re: {permissions} How should I do this?
    ... We are using Sql Server 2005. ... Our database server is a win2k3 machine. ... that he has access to everything Domain Users has access to. ... If that account is suppose to be of use on a machine it will need to be ...
    (microsoft.public.windows.server.security)
  • Re: best way to retrieve thousands of records.
    ... I understand you should have a chunky not chatty interface, ... i.e code up another stored proc that accepts ... > retrieve records from sql server. ...
    (microsoft.public.dotnet.languages.vb)