RE: User rights issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I think I narrowed the issue down. I can see db.sysdiagrams, but I cant see
any of the other schema users tables. Shouldn't the sa account be able to
see all shemas?

"Scotty7" wrote:

Hi I'm having the following issue with user rights.

My ADP connection is using the sa account, and I save the password.

I can see all the tables, however, after each table it has (NT
Authority\Auth Users)
When I try to open a table I get the following error;
ADO error: Object '[NTT Authority\Auth Users].t_table1' does not exist.

I believe it's a sql server rights issue, but sa is the owner of the db - so
I'm confused. sql server is running in mixed auth mode.

Thanks for any help.

Scott
.

Relevant Pages

  • Re: sa loginname being hacked
    ... I still have the sa account which is active....so they still can get in via ... >> But if we dont do anything about it they will get it. ... >> So changing the sa loginname will be a good place to start, I cant ... >> But I guess that the security of SQL server isnt that good or I am ...
    (microsoft.public.sqlserver.security)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: sbs 2003 network slow why?
    ... Issue: Local Account Password Test ... SQL Server and/or MSDE authentication mode is set to Windows Only. ... The Everyone group does not have more than Read access to the SQL Server and/or MSDE registry keys. ... BUILTIN\Administrators group should not be part of sysadmin role. ...
    (microsoft.public.windows.server.sbs)
  • Re: Error 0x80070534 when changing service account
    ... The only solution that I have been able to find for this error is to RDP into the SQL Server using the new Service account you want the SQL server to run under. ... prefix, an error 0x80070056 "The specified network password is not correct." ...
    (microsoft.public.sqlserver.security)