Re: how to allow creation of databases

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 11/28/03

  • Next message: anonymous_at_discussions.microsoft.com: "Re: TempDB permissions" 
    Date: Fri, 28 Nov 2003 00:07:05 -0600

    Since your development server is not a member of a domain, you'll probably
    find it easier to use standard SQL security rather than Windows
    authentication. You can configure SQL Server to use both authentication
    methods by right-clicking on the server in Enterprise Manager and selecting
    properties and then the security tab. Select 'SQL Server and Windows' and
    restart SQL Server.

    You can setup a standard SQL login with sysadmin rights by running a script
    like the one below from Query Analyzer:

    EXEC sp_addlogin 'MyLogin', 'MyPassword'
    EXEC sp_addsrvrolemember 'MyLogin', 'sysadmin'
    GO

    Use this account to create databases, etc. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"anthonymelillo" <nospam-tonyvr4@earthlink.net> wrote in message
news:eQJvwrWtDHA.3196@TK2MSFTNGP11.phx.gbl...
> You are a little over my head here.  I have never used SQL server before
and
> only got it installed yesterday.
>
> But, Visual Studio is not on the Windows 2003 Server. I have Visual Studio
> on my Windows XP PC and the SQL is on my Windows 2003 machine.
>
> The server is not setup as a domain controller.  That would not work with
> the Comcast Cable Internet I have through my Linksys Router.  So I had to
> setup the server as a stand alone.  I do not log into anything.
>
> -- 
> Tony
>
>
>
> "Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message
> news:uAq2NBWtDHA.1088@tk2msftngp13.phx.gbl...
> > Assuming that your SQL2000 and Visual Studio are on the same server, you
> can
> > simply log yourself in as the local admin of that machine. By default,
> > SQL2000 would allow the local admin to get in as a  SQL sysadmin, and
> you'll
> > have all the rights in SQL2000 including creating databases.
> >
> > If you have a domain on the home LAN and your Visual Studio is running
on
> a
> > different server, you can add the domain account you use to work with
> Visual
> > Studio to the local administrators group on the server that runs the SQL
> > 2000 instance. As long as you use this domain account, you can get into
> the
> > SQL2000 instance with all the rights.
> >
> > Of course, you need to make sure that you are using Windows
> authentication.
> >
> > If you want to be minimalist and restrict yourself to creating database
> > only, you can first get into SQL2000 as sysadmin and grant login to the
> > account you'll be using with Visual Studio, grant the login access to
the
> > master database, and then grant CREATE DATABASE to the user in the
master
> > database.
> >
> > -- 
> > Linchi Shea
> > linchi_shea@NOSPAMml.com
> >
> >
> > "anthonymelillo" <nospam-tonyvr4@earthlink.net> wrote in message
> > news:OeDHU1VtDHA.2408@tk2msftngp13.phx.gbl...
> > > I am new to SQL server and am trying to learn SQL Server and it's
> > > interaction with Visual Studio 2003.  I have SQL 2000 running on a
> Windows
> > > 2003 server on a home LAN and the server is as a stand alone.
> > >
> > > How can I give myself access to create databases on the server ?  Such
> as
> > in
> > > Visual Studio Server Explorer, where you right click on the SQL Server
> > Name
> > > and do "New Database"
> > >
> > > How can I do this ?
> > > Sorry if this is not the right place to ask.
> > >
> > > Thank for any help
> > > -- 
> > > Tony
> > >
> > >
> > >
> > >
> >
> >
>
>
  • Next message: anonymous_at_discussions.microsoft.com: "Re: TempDB permissions"

    Relevant Pages

    • Re: Slow booting xp home.
      ... I assume Microsoft Fax is not working. ... The LexBce Server service terminated unexpectedly. ... Windows is loading will come on and then the desktop, ... Visual Studio Source Control and SourceSafe -» ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... I assume Microsoft Fax is not working. ... LexBce Server service is used by some Lexmark and some Dell printers. ... Windows is loading will come on and then the desktop, ... Visual Studio Source Control and SourceSafe -» ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... The LexBce Server service terminated unexpectedly. ... Windows is loading will come on and then the desktop, ... I read somewhere that Microsoft ... Visual Studio Source Control and SourceSafe -» ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... Windows is loading will come on and then the desktop, ... I read somewhere that Microsoft ... Visual Studio Source Control and SourceSafe -» ... Foundation Server - Team System Web Access -» ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
      ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
      (microsoft.public.sqlserver.setup)