Re: SQLExpress New DB
- From: "Paul W Smith" <pws@xxxxxxxxxxxxxxxxxxx>
- Date: Thu, 13 Sep 2007 18:13:27 +0200
You should understand that I am a simple user, who is trying to learn
SQLExpress.
I have installed the program from the disk which came free with a Book in
SQLEXpress onto my PC which is running VISTA Home Premium.
When I click on the icon the program seesm to open up correctly, and as far
as I can tell I have connect to the server.
My book says I should right click on the 'databases' item and add a new
database. I give it a name and then the error message listed below occurs.
I am pretty certain it is a rights issue, but cannot understand how this can
be. I have nothing installed on my new VISTA PC other than Office 2007. How
can Microsoft be touting the use of a new product SQLEXpress over Access
when you cannot even use it with their latest operating systsem.
I do not expect to have to 'tinker' around with permissions for an
application to work. However I suppose I am going to have to, hence my
request for clear explicit instructions on what I need to do. From your
questions, some of which I have no idea how to answer, I wonder whether you
think I am trying to configure a full installation of SQL server?
PWS
"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message
news:%23O3ep7K9HHA.5840@xxxxxxxxxxxxxxxxxxxxxxx
What mechanisms have you used to create the database? The Visual Studio
Server/Database Explorer, the SQL Server tools or a TSQL command batch?
Can you connect to the server? Is the database being created on the same
system as the server? (It must be). If this is a rights issue, it means
you need SA rights to create a new database. Are you logged on as a user
in the Administrator's group?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Paul W Smith" <pws@xxxxxxxxxxxxxxxxxxx> wrote in message
news:eAS3mQ78HHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
I have a new computer with Windows VISTA on it.
I have installed SQLExpress and everything appears correct - i did not
have issues during set-up, that I can remember, I did this some while
ago.
I have just started to consider using SQLExpress, my issue is I cannot
create a new database. I get an message box...
Create failed for Database 'MCCL'. (Microsoft.SqlServer.Express.Smo)
Additional information
An exception occured while executing a Transact_SQL statment or batch.
(Microsoft.SqlServer.Express.ConnectInfo)
CREATE DATABASE permission denied in database 'master'. (Microsft SQL
Server, Error: 262)
From a little reasearch I understand it seems to be a premissioning
problem, but do not udnerstand what to do to solve this issue.
I intend to use the new DB when created as the back end for an ASP
application - not sure if this is relevant to how my problem will be
solved.
PWS
.
- Follow-Ups:
- Re: SQLExpress New DB
- From: William Vaughn
- Re: SQLExpress New DB
- References:
- SQLExpress New DB
- From: Paul W Smith
- Re: SQLExpress New DB
- From: William Vaughn
- SQLExpress New DB
- Prev by Date: Session disconnects
- Next by Date: Re: SQLExpress New DB
- Previous by thread: Re: SQLExpress New DB
- Next by thread: Re: SQLExpress New DB
- Index(es):
Relevant Pages
|
Loading
