how to allow creation of databases

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


Date: Thu, 27 Nov 2003 22:11:28 -0500

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


Relevant Pages

  • 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)
  • Re: how to allow creation of databases
    ... But if I try and use it from Visual Studio to create a database, ... > Since your development server is not a member of a domain, ... You can configure SQL Server to use both authentication ...
    (microsoft.public.sqlserver.security)
  • Re: Fehlerhafte ODBC-Datenerweiterung bei den Reporting Services
    ... MSDN Webcast: Intelligent Reporting: Using the Visual Studio 2005 Report Viewer Controls ...
    (microsoft.public.de.sqlserver)
  • Re: How to move system databases to new SAN drive in cluster serve
    ... I have moved model, msdb, and tempdb on a cluster ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate stand alone sql server to a cluster without downtime
    ... Use backup and restore to create the databases on the new system. ... Run a log backup WITH STANDBY on each database on the old server. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)