newbie setup question

18 May 2009 5:37 PM

Eric

veteran programmer here, new to VB.Net
I installed VB.Net 2008 Express and SQL Server 2008 Express. Then I went
into the SQL Server Management and tried to start setting up with a new set
of file definitions. I clicked Add Database and it said insufficient
premissions. What am I missing? I installed with the default options. Why
would I not have permission to add setup to my own database installed on my
local PC?
(I'm running Vista Premium)

19 May 2009 3:08 PM

Cowboy (Gregory A. Beamer)

It is most likely Vista. Alter the startup to run as administrator. You do
this by going to the shortcut and right clicking and selecting properties.
Do this for both Visual Studio and Management Studio. If your user is admin
(sounds like it is), that should solve all problems.

Make sure you have the service packs for SQL Server and Visual Studio.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************

Show quoteHide quote

| Think outside the box! |
*************************************************

"Eric" <someone@idontwantspam.com> wrote in message
news:uMPpM991JHA.1092@TK2MSFTNGP06.phx.gbl...
> veteran programmer here, new to VB.Net
> I installed VB.Net 2008 Express and SQL Server 2008 Express. Then I went
> into the SQL Server Management and tried to start setting up with a new
> set of file definitions. I clicked Add Database and it said insufficient
> premissions. What am I missing? I installed with the default options.
> Why would I not have permission to add setup to my own database installed
> on my local PC?
> (I'm running Vista Premium)
>

19 May 2009 4:58 PM

Eric

I have to do a "run as" on the install? I don't think I've had to do that
on anything yet in Vista. The user I'm trying to run it under is not admin,
but normally if I run something like an install which requires admin rights,
Vista asks me for the admin password after I start it.
If I do a run as on the install can I still add my database tables running
as a regular user? I don't want the normal processing stuff to all have to
run as admin..

Show quoteHide quote

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:OzWwiOJ2JHA.3988@TK2MSFTNGP05.phx.gbl...
> It is most likely Vista. Alter the startup to run as administrator. You do
> this by going to the shortcut and right clicking and selecting properties.
> Do this for both Visual Studio and Management Studio. If your user is
> admin (sounds like it is), that should solve all problems.
>
> Make sure you have the service packs for SQL Server and Visual Studio.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> *************************************************
> | Think outside the box! |
> *************************************************
>
>
> "Eric" <someone@idontwantspam.com> wrote in message
> news:uMPpM991JHA.1092@TK2MSFTNGP06.phx.gbl...
>> veteran programmer here, new to VB.Net
>> I installed VB.Net 2008 Express and SQL Server 2008 Express. Then I went
>> into the SQL Server Management and tried to start setting up with a new
>> set of file definitions. I clicked Add Database and it said insufficient
>> premissions. What am I missing? I installed with the default options.
>> Why would I not have permission to add setup to my own database installed
>> on my local PC?
>> (I'm running Vista Premium)
>>

20 May 2009 12:10 PM

Eric

So I set SQL Server Express 2008 to run as administrator and I got it to
create a database and add a table. Then I set my normal user account as the
owner of it and tried to add it as a resource in my VB.Net Express 2008 app
and it keeps saying either insufficient permissions or file in use. Are
these 2 apps supposed to work together? It looks like there is a similar
database setup thing in the VB.Net Express 2008 software. I'm testing that
next. I'm not sure what I'm doing. I didn't see any examples from MS on
how to get started on setting up data source, just on setting up forms apps
and database scripts.

Show quoteHide quote

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:OzWwiOJ2JHA.3988@TK2MSFTNGP05.phx.gbl...
> It is most likely Vista. Alter the startup to run as administrator. You do
> this by going to the shortcut and right clicking and selecting properties.
> Do this for both Visual Studio and Management Studio. If your user is
> admin (sounds like it is), that should solve all problems.
>
> Make sure you have the service packs for SQL Server and Visual Studio.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> *************************************************
> | Think outside the box! |
> *************************************************
>
>
> "Eric" <someone@idontwantspam.com> wrote in message
> news:uMPpM991JHA.1092@TK2MSFTNGP06.phx.gbl...
>> veteran programmer here, new to VB.Net
>> I installed VB.Net 2008 Express and SQL Server 2008 Express. Then I went
>> into the SQL Server Management and tried to start setting up with a new
>> set of file definitions. I clicked Add Database and it said insufficient
>> premissions. What am I missing? I installed with the default options.
>> Why would I not have permission to add setup to my own database installed
>> on my local PC?
>> (I'm running Vista Premium)
>>