Re: Admin User Account from Front -end Interface

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 12/24/03

  • Next message: Roy Goldhammer: "Re: Converting to SQL authentication" 
    Date: Tue, 23 Dec 2003 20:28:06 -0600

    You can create a new SQL Server login account using sp_addlogin:

        EXEC sp_addlogin 'AdminAccount', 'AdminPassword'

    Or you can grant an existing windows account access to SQL Server with
    sp_grantlogin:

        EXEC sp_grantlogin 'MyDomain\AdminAccount'

    If the account is to be a server administrator, you can add it to the
    sysadmin server role:

        EXEC sp_addsrvrolemember 'AdminAccount', 'sysadmin'
        or
        EXEC sp_addsrvrolemember 'MyDomain\AdminAccount', 'sysadmin'

    Note that you shouldn't use a sysadmin login for routine application access.
    See the Books Online for more information. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
<thankch@hotmail.com> wrote in message
news:045b01c3c9c3$6b3384d0$a301280a@phx.gbl...
> Hi all,
>
> I would like to create User Account(mean user can admin
> user account) from Front-end (using VB 6.0), pls give How
> to, sample program or manual how to.
>
> TIA
>
  • Next message: Roy Goldhammer: "Re: Converting to SQL authentication"

    Relevant Pages

    • Re: sqlserver connection - need help desperately!
      ... > You are connecting to a remote SQL Server ... > The SQL Server accepts both Windows and SQL Server authentication. ... > SQL Server login that's authorized to use your database. ... > the ASP.NET account in the SQL Server. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
      ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
      (microsoft.public.sqlserver.security)
    • Re: SharePoint V3 Install Error
      ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
      (microsoft.public.sharepoint.windowsservices)
    • RE: Problems with WebParts
      ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Authenticating in SQL Server via MS Access 2002
      ... account and this account will be used by Access to authenticate with ... > 1.Database is on SQL Server 2000 ... > SQL using Windows authentication. ... > it is then that they are asked for their SQL Server login. ...
      (microsoft.public.access.externaldata)
    • Quantcast