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 ?!?
>

creat a solution in SQLServer 2005 and intall that solution in SQLServer 2005 Express

Hi,

can i develop a solution in SQLServer 2005 with the analysis Services (OLAP cubes) and then put that solution in a client that only have the SQLServer 2005 Express?

Thaks

Larokas

Analysis Services are not part of SQL Server 2005 Express installation.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.