Re: SQLExpress New DB

I responded as I did in a serious way. As an author I stand behind and support the readers of my books. If there are instructions or walk-throughs that don't work (or no longer work) I figure out what's wrong and post addenda to the book on my support site. I would expect the author of the book you're reading to do the same. Incidentally, the men and women (boys and girls) that contribute their time to this newsgroup are under no obligation to respond to you, provide you with an answer or even respond to your questions. We volunteer our time and experience without expectation of recompense.

Now as to Vista and SQL Server Express. I have used both along with Visual Studio Express without incident. Without sitting in front of your system I doubt if I could add more than I already have. But let's try to figure it out.

It would help to know the name of this free program and what it's supposed to do. As I understand, it's supposed to somehow permit you to create a database. Without a bit more information we would be guessing at its intent or how to make it work.

Basically it appears that you have an application that accesses SQL Server. This means you must have SQL Server Express installed on the target system--I can only assume that this was done when the application was installed. Only the system administrator can do this. You log on to the system as a normal (non-admin) user. There is no domain but you also say there is no workgroup either. Is that right? So the user is logged on to the local system. That user, if they are granted rights to execute the program should be able to run SQL Express and act as System Administrator (SA) on the database (essentially have the rights to do anything). It seems that you have access to the ConnectionString. Again this seems like you're running Visual Studio, Visual Basic or the like. Is this the case?

I can see that we need a lot more information to be able to help... and again, I think you need to (also) contact the author to clarify what's going on.

--
____________________________________
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:OtqJ$Lk9HHA.1900@xxxxxxxxxxxxxxxxxxxxxxx
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: How To Add/Update Record In ADO.NET
    ... If the row is already there (there is already someone with the same name in the database), ... Hitchhiker's Guide to Visual Studio and SQL Server ... "Jeff Gaines" wrote in message ... SQL Server Compact Edition or Express Edition come to mind. ...
    (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)