RE: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Inval

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This ended up being a permissions issues. I had to kick around the schema
owner in the security tab - resetting permissions properties on various
databases this user login was associated with (unsetting/resetting
permissions to various databases and roles). Not sure exactly what fixed it
except that kicking the permissions around a bit seemed to fix it.


"Rich" wrote:

I loaded Sql Server 2005 and then SP3 (also have sql Server 2000 on this
machine). An asp.net project I am working on works find on my other machine
which has Sql Server 2005 SP2 (with Sql Server 2000 SP4), but on this new
machine (both winXP Pro SP3) the asp.net configuration Web Site
Administration Tool gave me this error when I tried to select Create/Manage
Roles


An error was encountered. Please return to the previous page and try again.

The following message may help in diagnosing the problem: ERROR [42S02]
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'afm_groups'. at
System.Web.Administration.WebAdminPage.CallWebAdminHelperMethod(Boolean
isMembership, String methodName, Object[] parameters, Type[] paramTypes) at
ASP.security_roles_manageallroles_aspx.BindGrid() at
ASP.security_roles_manageallroles_aspx.Page_Load() at
System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp, Object o) at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)
<<

Any suggestions appreciated what I could do to fix this - hopefully I don't
have to reload Sql Server 2005 with SP2.

Thanks,
Rich

.

Relevant Pages

  • RE: missing system.mdw file
    ... permissions to create the file, ... >The registry key is not missing. ... Running the SCAN program from the Windows ... >>| I cannot create any new databases in Access 2002 on ...
    (microsoft.public.access.setupconfig)
  • Re: one SQL DB getting info from another - user setup?
    ... It appears from your narrative that the Main and DB1 databases ... EXEC sp_helpdb 'Main' ... SQL 2000 SP3 and is turned off by default. ... > In the permissions for Main, USER1 and USER2 are listed, but have NO ...
    (microsoft.public.sqlserver.security)
  • Re: MDB remembers old MDW
    ... The workgroup file is used for a session of Access - any number of databases ... The mdw defines the usernames/passwords and group memberships. ... permissions are stored in the mdb file with the objects. ...
    (microsoft.public.access.security)
  • Re: Application roles Please Help!
    ... May I point out that with the guest account, any server login will have ... access to any db even without permissions. ... > Other databases can be accessed only via the guest user security context ...
    (microsoft.public.sqlserver.security)
  • Re: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)