Re: SQL Server execute permission denied on object

This is a permission problem: the Login account or the required permissions
have not been set up properly on the remote database. However, permission
problems are one of these things that cannot be set up graphically (ie.
using the GUI interface) from Access ADE; so you have to use DDL statement
or use something else like Enterprise Manager.

I don't understand what you mean by "Since I am out of state I can not run
against the SQL server that she is using.". EM or any other client tool
shouldn't have any problem to make a remote connection if you don't have a
firewall blocking the port 1433 somewhere along the line.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Roger Sipson" <sipson@xxxxxxxxxxxxx> wrote in message
news:eugKA7MOGHA.748@xxxxxxxxxxxxxxxxxxxxxxx
I have an Access FE to a SQL BE that has been running fine for several
years. Recently the SQL part was moved to a new server. I changed the
connect string to reflect the new server name and my user can get to the
db
but she has started getting

SQL Server execute permission denied on object

messages that did not appear previously.

Example problem VB code is

Dim cmd As New ADODB.Command
With cmd
.ActiveConnection = glbConnection
.CommandText = "uspStudentExistsArchive"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("RETURN_VALUE", adInteger,
adParamReturnValue)
.Parameters.Append .CreateParameter("@DragonID", adChar,
adParamInput, 8, strDragonID)
.Execute
End With

uspStudentExistsArchive exists and the call is correct.

I am using an ADODB.Connection

I have no problems when I use the BE on my computer, which runs on SQL
Server Developer edition. The problem only appears when my user is
connecting to a BE running on the new server. Since I am out of state I
can
not run against the SQL server that she is using.

This is the only FE to a lot of data so I REALLY would appreciate any
help.

Roger Sipson




.

Relevant Pages

  • Re: Export to Excel
    ... maybe your dts-script has no permission to the file/directory ... server through Enterprise Manager. ... package from SQL server. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSCESA20.DLL - Pull crashes IIS 5.0
    ... are you saying use File Explorer on the SQL Server machine and ... >>> RDA Pull request gets to the IIS server, ... >>> Server is running on SERVER2, you would add permission ... >>> ..NET Compact Framework MVP ...
    (microsoft.public.sqlserver.ce)
  • Re: how to: non-admin user sending email from a SP ?
    ... Check out using XPSMTP for sending emails from inside of SQL Server. ... All you would have to do then is grant the appropriate people permission ... > states that "Only members of the sysadmin fixed server role can run ...
    (microsoft.public.sqlserver.programming)
  • Re: Recommended Procedure for Importing From Access Across LAN
    ... For this the SQL server Service startup account should be ... >a domain account with read only permission in the folder where the file ...
    (microsoft.public.sqlserver.programming)
  • Re: Long delay before Drives & Files appear in My Computer & Address Bar
    ... > SERVICE JEFF-DZP8HX39G2 The machine-default permission settings do not ... > grant Local Activation permission for the COM Server application with ... > Ratcliff JEFF-DZP8HX39G2 The Adobe LM Service service was successfully ... > within the required timeout. ...
    (microsoft.public.windowsxp.help_and_support)