June 12, 2007 at 3:36 am
The users use a utility to login to the database and remove some table entries and then the utility does some re-insertion into the same tables. The only stipulation is that the user be 'dbo'.
They are using windows 2003, SQL 2000 SP3 and get the following message when logging in with SA or any other user:
The following errors have occurred:
1. [frmDistribute.cmdLogin_Click Line 0][ERROR NO. -2147217900 - Could not find stored procedure 'sp_helpUser'.]
When running profiler get error message similar to: Msg 2812, Level 16,
Found something online that there may be a problem with Service Pack 4, but being they were on 3, didn't seem to apply. Upgraded the sql to SP 4 and now the 'SA' user can login but no other user.
The stored procedure is there and public has execute permission.
Any ideas greatly appreciated!
Thank you
June 12, 2007 at 6:32 am
If the utility is taken out of the equation do the users login without issues or the have the same/different errors.
Mike
June 12, 2007 at 7:36 am
There is a client application that resides on the workstations that accesses the database. That seems to work fine with any of the users.
It's just the utility that seems to return these issues. But this is the first issue that has been run into with the utility. Everywhere else it works fine. The only difference that I can find so far is that they are running a novell network...
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply