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

    • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
      ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: How to Replicate an SQL Server 2000 Database
      ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
      (microsoft.public.sqlserver.replication)
    • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
      ... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
      (microsoft.public.sqlserver.setup)
    • Re: FCB::RemoveAlternateStreams: Operating system error (null)
      ... Thanks for all your help Ekrem, even if your sugestion does not solve the ... in this edition of SQL Server the ... database so it's opened again and you get this error somehow. ...
      (microsoft.public.sqlserver.setup)
    • Re: Best Way to Distribute a Winform Application
      ... Would I be able to get any help with Visual Studio 2005 beta if I had ... Server or would a server upgrade be needed in order to use Visual Studio 2005? ... > the SQL server machine, you can use msi, xcopy or no-touch deployment as you ... > Using no-touch deployment is a matter of choosing between a couple options. ...
      (microsoft.public.dotnet.distributed_apps)