permission to log in

how can I give users, permission to log in to the msde
server?
Do I need a msde-manager program? Where can I find this?
hi,
wouter wrote:
> how can I give users, permission to log in to the msde
> server?
> Do I need a msde-manager program? Where can I find this?
as MSDE is only provided with oSql.exe, you can perform this task from this
command line utility as exposed in
http://support.microsoft.com/default...;EN-US;q325003
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||How can I add a user (as administrator)in 'DbaMgr2K' ?
"Andrea Montanari" schreef:

> hi,
> wouter wrote:
> as MSDE is only provided with oSql.exe, you can perform this task from this
> command line utility as exposed in
> http://support.microsoft.com/default...;EN-US;q325003
> for your convenience, you can have a look at a free prj of mine, available
> at the link following my sign., which provides a graphical user interface
> similar to Enterprise Manager in order to accomplish management tasks,
> including the one here discussed..
> futher tools for MSDE, both commercial and free, are listed
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
korsakow wrote:
> How can I add a user (as administrator)in 'DbaMgr2K' ?
>
you can not add a user as administarator... you can add a login as
sysadmin..
you can use SQL-DMO object model to perform this task like
Dim oServer As SQLDMO.SQLServer
Dim oLog As SQLDMO.Login
Set oServer = New SQLDMO.SQLServer
With oServer
.AutoReConnect = True 'enables auto-reconnect when connection is
broken
.ApplicationName = "application name"
.LoginTimeout = 30
.LoginSecure = True
.Connect "(local)"
End With
Set oLog = New SQLDMO.Login
With oLog
.Name = "Login Name"
.Type = SQLDMOLogin_Standard
.Database = "Database name"
.Language = "english"
End With
oServer.Logins.Add oLog
oServer.ServerRoles("sysadmin").AddMember oLog.Name
Set oLog = Nothing
oServer.DisConnect
Set oServer = Nothing
or using straight Transact-SQL code with help of sp_addlogin and
sp_addsrvrolemember system stored procedures like
EXEC sp_addlogin @.loginame = 'login name'
, @.passwd = 'password'
, @.defdb = 'Pubs'
, @.deflanguage = 'english'
EXEC sp_addsrvrolemember @.loginame = 'login name'
, @.rolename = 'sysadmin'
GO
please have a look at
http://msdn.microsoft.com/library/de..._adda_0q7i.asp
for sp_addlogin synopsis..
for WindowsNT users and groups you have to use sp_grantlogin instead of
sp_addlogin
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply