Creat trusted user

hi every one ,
I used many different way to creat trusted user in SQL Server2000 runing on
WinServer2003 but any of them din't work!!!
Do u have any suggestion ?!?By 'trusted user' I assume you mean an existing Windows account. You can
grant a Windows account permissions to connect to SQL Server using
sp_grantlogin:
EXEC sp_grantlogin 'MyDomain\MyAccount'
You can then grant the account access to a particular database using
sp_grantdbaccess:
USE MyDatabase
EXEC sp_grantdbaccess 'MyDomain\MyAccount'
The user will also need object permissions. This is normally accomplished
by creating roles, granting object permissions to roles and using role
membership to control user object access.
EXEC sp_addrole 'MyRole'
GRANT SELECT ON MyTable TO MyRole
EXEC sp_addrolemember 'MyRole', 'MyDomain\MyAccount'
Hope this helps.
Dan Guzman
SQL Server MVP
"F_ps10" <f_ps510@.yahoo.uk.co> wrote in message
news:%2347s2mxdEHA.3732@.TK2MSFTNGP11.phx.gbl...
> hi every one ,
> I used many different way to creat trusted user in SQL Server2000 runing
on
> WinServer2003 but any of them din't work!!!
> Do u have any suggestion ?!?
>