Re: how to allow creation of databases

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

  • Next message: Dan Guzman: "Re: how to allow creation of databases" 
    Date: Thu, 27 Nov 2003 23:48:55 -0500

    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: Dan Guzman: "Re: how to allow creation of databases"

    Relevant Pages