Re: how to allow creation of databases

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

Date: Sat, 29 Nov 2003 14:24:14 -0500

That error is coming from the Visual Studio Server Explorer. I think I know
at least part of the problem.

It seems that you can not create databases in the Professional version of
Visual Studio. I don't know what version you need, but I guess it must be
either one of the enterprise versions.

I will try creating the database directly and see if that works. 

-- 
Tony
"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:%23DebmaitDHA.2464@TK2MSFTNGP12.phx.gbl...
> 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
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages