P
Paul W Smith
Guest
Re: SQLExpress New DB
I do understand that any assistance I get from this form is given purely on
a volutary basis. I am not sure why you thought otherwise but I am happy to
acknowledge the above fact.
I also am unsure why you think I am trying to get a 'third' party product to
work. All I am try to do is to get my free copy of SQL Express to work on
my VISTA system. The problem I have got is that I have installed it
correctly but cannot create dbs.
The issues seems to be a permissioning one. I have tested this because when
I turn off User Account Contol I am able to create dbs, but when I put it
back on again I cannot. The strange things is I only have one account on my
PC, my account and it says 'administrator' against it. I do not have a
separate adminstrator account.
Your text below says the account I used to install SQL Express had to have
administrator privaliges, and I think this must be true as I am able to
install software on my VISTA system. So my issue is why does this, the only
account on my PC not have enougfh privaiges to allow me to create DBs?
At this point I should say that I have installed exactly the same software
on a XP PC and everything works fine without any issue - no permissioning
problems and I can create DBs without issue.
I have been given a possible solution from the IT guys at work:
Hostname = DELL520
UserName = PWS
At a DOS prompt type:
sqlcmd -S DELL520\SQLExpress -E
At 1> type:
sp_grantlogin [DELL520\PWS]
At 2> type:
go
At 1> type:
sp_addsrvrolemember [DELL520\PWS], dbcreater
At 2> type:
go
I then get a message saying the account does not have sufficient
permissions.
Obviously this is a VISTA related issue, but does anyone here have any idea
how to set whatever permissions my PWS account needs to allow SQLExpress to
work on my VISTA system?
I apologise if this update is too verbose, I thought it best to tryto give
as much information as possible.
PWS
"William Vaughn" <billvaNoSPAM@betav.com> wrote in message
news:%23E3RfJl9HHA.4476@TK2MSFTNGP06.phx.gbl...
>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@NOSPAM.twelve.me.uk> wrote in message
> news:OtqJ$Lk9HHA.1900@TK2MSFTNGP02.phx.gbl...
>> 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@betav.com> wrote in message
>> news:eX5n5vj9HHA.748@TK2MSFTNGP04.phx.gbl...
>>>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@NOSPAM.twelve.me.uk> wrote in message
>>> news:%230q9EEi9HHA.1204@TK2MSFTNGP03.phx.gbl...
>>>> 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@betav.com> wrote in message
>>>> news:%23O3ep7K9HHA.5840@TK2MSFTNGP03.phx.gbl...
>>>>> 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@NOSPAM.twelve.me.uk> wrote in message
>>>>> news:eAS3mQ78HHA.5160@TK2MSFTNGP05.phx.gbl...
>>>>>>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
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
I do understand that any assistance I get from this form is given purely on
a volutary basis. I am not sure why you thought otherwise but I am happy to
acknowledge the above fact.
I also am unsure why you think I am trying to get a 'third' party product to
work. All I am try to do is to get my free copy of SQL Express to work on
my VISTA system. The problem I have got is that I have installed it
correctly but cannot create dbs.
The issues seems to be a permissioning one. I have tested this because when
I turn off User Account Contol I am able to create dbs, but when I put it
back on again I cannot. The strange things is I only have one account on my
PC, my account and it says 'administrator' against it. I do not have a
separate adminstrator account.
Your text below says the account I used to install SQL Express had to have
administrator privaliges, and I think this must be true as I am able to
install software on my VISTA system. So my issue is why does this, the only
account on my PC not have enougfh privaiges to allow me to create DBs?
At this point I should say that I have installed exactly the same software
on a XP PC and everything works fine without any issue - no permissioning
problems and I can create DBs without issue.
I have been given a possible solution from the IT guys at work:
Hostname = DELL520
UserName = PWS
At a DOS prompt type:
sqlcmd -S DELL520\SQLExpress -E
At 1> type:
sp_grantlogin [DELL520\PWS]
At 2> type:
go
At 1> type:
sp_addsrvrolemember [DELL520\PWS], dbcreater
At 2> type:
go
I then get a message saying the account does not have sufficient
permissions.
Obviously this is a VISTA related issue, but does anyone here have any idea
how to set whatever permissions my PWS account needs to allow SQLExpress to
work on my VISTA system?
I apologise if this update is too verbose, I thought it best to tryto give
as much information as possible.
PWS
"William Vaughn" <billvaNoSPAM@betav.com> wrote in message
news:%23E3RfJl9HHA.4476@TK2MSFTNGP06.phx.gbl...
>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@NOSPAM.twelve.me.uk> wrote in message
> news:OtqJ$Lk9HHA.1900@TK2MSFTNGP02.phx.gbl...
>> 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@betav.com> wrote in message
>> news:eX5n5vj9HHA.748@TK2MSFTNGP04.phx.gbl...
>>>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@NOSPAM.twelve.me.uk> wrote in message
>>> news:%230q9EEi9HHA.1204@TK2MSFTNGP03.phx.gbl...
>>>> 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@betav.com> wrote in message
>>>> news:%23O3ep7K9HHA.5840@TK2MSFTNGP03.phx.gbl...
>>>>> 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@NOSPAM.twelve.me.uk> wrote in message
>>>>> news:eAS3mQ78HHA.5160@TK2MSFTNGP05.phx.gbl...
>>>>>>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
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
