title: "could not find stored procedure"
body: <p>I am maintaining a classic ASP website that has a SQL Server 2005 backend.  For a small piece of new functionality I wrote a stored procedure to do an insert.  This is the only user stored procedure in the database.</p>
  
  <p>When I attempt to call the stored procedure from code I get the following error:</p>
  
  <pre>
  Microsoft OLE DB Provider for SQL Server error '80040e14' 
  Could not find stored procedure 'InsertGroup'. 
  /newGroup.asp, line 84 
  </pre>
  
  <p>The DB uses SQL Server authentication.  When I connect to the DB server in Visual Studio using the same user/pw as in the connection string the stored procedure is not visible but all tables are.</p>
  
  <p>The user has datareader and datawriter roles and explicit execute permission on the stored procedure.</p>
  
  <p>What am I missing?</p>
  
  <p>UPDATE: My apologies, the server admin misinformed me that it was a 2000 server when it is actually a 2005 server (running on Windows Server 2003 x64).</p>