Hide Database in SQL SErver 2000

Dear All
I have a question on the security control of sql server 2000.
Now I set a specified sql account can access corresponding database only,
however, how can I hide other database that he not allowed to access, as
well as master, tempdb and other system database?
ThanksYou cannot do that in SQL Server 2000 but only in SQL Server 2005
"a" <a@.l.q> wrote in message
news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Dear All
> I have a question on the security control of sql server 2000.
> Now I set a specified sql account can access corresponding database only,
> however, how can I hide other database that he not allowed to access, as
> well as master, tempdb and other system database?
> Thanks
>|||o....thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uu$cIZIBGHA.1032@.TK2MSFTNGP11.phx.gbl...
> You cannot do that in SQL Server 2000 but only in SQL Server 2005
>
> "a" <a@.l.q> wrote in message
> news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
only,[vbcol=seagreen]
>

HelpSQL Agent Security

We have sensitive data that requires the builtin\administrators group be removed so domain admins are unable to see data. When we do this, SQL can continue to run under the local system account, but the SQL Agent cannot.

Does anyone else have a solution that will lockout NT admins (both local and domain) and allow both SQL and the SQL AGENT to run properly?

TIA

Ryan HuntDid you give the new domain account sysadmin rights?

And configure it to start with that account?|||Thanks for the response. I ended up just creating a local admin account for the agent with specific SA rights to the server. Then, had the only department allowed to have access to the data change the password. This seems like the best choice...

Thanks

Help: No mapping between account names and security IDs was done

Hi,
My report returns this error: "No mapping between account names and security
IDs was done. (Exception from HRESULT: 0x80070534)", I have spent a lot of
time to solve (set up Role/Datasource etc) but fail. I do know what the real
issue is, can you help me or direction to solve this problem.
My reporting server in DMZ zone and talk to internal lan SQL server via
opened 1433 port.
Many Many Thanks.
FRankiePlease help
> Hi,
> My report returns this error: "No mapping between account names and
> security IDs was done. (Exception from HRESULT: 0x80070534)", I have spent
> a lot of time to solve (set up Role/Datasource etc) but fail. I do know
> what the real issue is, can you help me or direction to solve this
> problem.
> My reporting server in DMZ zone and talk to internal lan SQL server via
> opened 1433 port.
> Many Many Thanks.
> FRankie
>
>