Re: how to allow creation of databases

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

  • Next message: Angus Walker: "Stored procedure names" 
    Date: Fri, 28 Nov 2003 21:12:38 -0600

    Is this message returned from the VS Server Explorer? Can you successfully
    execute the CREATE DATABASE statement below from Query Analyzer?

        CREATE DATABASE MyDatabase 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"anthonymelillo" <nospam-tonyvr4@earthlink.net> wrote in message
news:eMS8SfetDHA.2448@TK2MSFTNGP09.phx.gbl...
> I created the script as you mentioned and created the logon.
>
> But if I try and use it from Visual Studio to create a database, I get the
> error "Can not create databases on this server"
>
> Any idea what is going on ?
>
> -- 
> 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: Angus Walker: "Stored procedure names"

    Relevant Pages

    • 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: 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: 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: SBS 2003 Unable to connect to database STS_Config
      ... Check the database connection information and make sure that the database ... Uninstall SQL Server; ... Reinstall Monitoring and Sharepoint and make sure they work; ...
      (microsoft.public.windows.server.sbs)
    • RE: Need help with copy database
      ... in the event log for the server SQL was running on. ... This was a username from the database ... SQL Server Agent service is run with a domain account that has full admin ... if @backupSetId is null begin raiserror(N''Verify failed. ...
      (microsoft.public.sqlserver.dts)