Re: SQLExpress New DB

My message was a serious request for help, sorry you felt unable to answer
it.

It seems to me that SQLExpress requires some additional configuration when
used with VISTA, but I do not understand how to do this. I hoped for some
assistance or as I am sure that there must have been other users who
experienced the same issue, a standard explanation of what to do.

If this is the wrong forum to ask this question please advise me where to
address my enquiry.

PWS



"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message
news:eX5n5vj9HHA.748@xxxxxxxxxxxxxxxxxxxxxxx
I suggest you pose this question to the author...

--
____________________________________
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:%230q9EEi9HHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: Which Method to Create a Database Do I Use?
    ... To be fair, VS is a "generic" tool designed to front a variety of backend databases, but each of the serious engines have rights management needs as well. ... But the more I think about how connecting to a database is setup and the trouble it's been, the more it just pisses me off. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... when I was working on the team) to get rights management tools integrated ... Hitchhiker's Guide to Visual Studio and SQL Server ... actually be able to connect to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... Okay, once the database is built, you have to get rights to access it. ... SSPI and "SQL Server" ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Assume SQL Server Rights for apps, any cons?
    ... Since your customer is the sysadmin on his SQL Server box, ... >administrates the underlying SQL Server 2000 database by himself. ... >wants that my software assumes the user rights automatically from the SQL ... >My application offers a GUI to manage customers. ...
    (microsoft.public.dotnet.framework)
  • Re: Newbie: I dont understand user permissions for table access
    ... >My database is remote to my workstation. ... >> HOW are you connecting to SQL Server? ... >> If you are using NT auth, what rights does your NT ... the PUBLIC role? ...
    (microsoft.public.sqlserver.server)