Re: how to allow creation of databases

From: anthonymelillo (nospam-tonyvr4_at_earthlink.net)
Date: 11/28/03

  • Next message: anthonymelillo: "Re: how to allow creation of databases" 
    Date: Fri, 28 Nov 2003 13:17:23 -0500

    I already setup the security configuration as you mentioned.

    But, how can I create and execute the script you mentioned ? 

    -- 
Tony
"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:%23xR6aXXtDHA.2448@TK2MSFTNGP12.phx.gbl...
> 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: anthonymelillo: "Re: how to allow creation of databases"

    Relevant Pages

    • Re: Linksys PSUS4 Printserver
      ... >Slottech wrote: ... from here you can do all the setups without using windows ... Yes it does work as I have the same print server and using ... If you need the info I have to setup I will post for you for my ...
      (alt.os.linux.suse)
    • RE: Windows 2008 FTPS Virtual Directory
      ... we are Windows Server General newsgroup and we mainly focus on ... Windows Server side issues here. ... If you setup your FTP server using Microsoft Internet Information Services ...
      (microsoft.public.windows.server.general)
    • Re: SQL Server 2005 Login Problem
      ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
      (microsoft.public.sqlserver.clients)
    • RE: My Documents Redirection error
      ... We can upgrade the instance SharePoint ... >> is no need to manually migrate data from MSDE to SQL server and all dada ... >> How to back up and restore http://companyweb data in Windows Small ...
      (microsoft.public.windows.server.sbs)
    • Re: Link to Install Windows Server 2003
      ... To do a clean install, boot the Windows 2003 Server install CD-Rom. ... the Setup and driver files. ...
      (microsoft.public.windows.server.setup)