I've created an MSDE instance. I need to grant domainName\userName rights
to the instance, specifically to add it to
- security administrator group, and
- database creator group.

I'm unable to concoct correct commands. Can some good soul give me a
working example?

Thank you.

hi bill,
[quoted text, click to view]

EXEC sp_grantlogin 'AndreaNet\Guest'
EXEC sp_addsrvrolemember 'AndreaNet\Guest', 'dbcreator'
GO

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ga-gz_8dri.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_6ndx.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply