newbie setup question

  • Thread starter Thread starter Eric
  • Start date Start date
E

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)
 
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! |
*************************************************
 
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! |
*************************************************
 
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..
 
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..
 
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.
 
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.
 
Back
Top