VB 2008 And SQL Database

[Martin Racette]

Hi,

I have installed VB2008 Express a few months ago, and yesterday I was trying
to create a new program and that program requires the use of a database, so
I tried to create the SQL database, but I get an error message that tells me
that I do not have the appropriate autorisation to create an SQL database,
and I need to create it manually

How do I do that, or better yet how do I correct VB so that I can create the
database from within

 

[Cor Ligthert[MVP]]

Hi,

This has nothing to do with VB, the same problem you can have with notepad,
install your SQL server in the way that you are authorisezed as user to use
it.

Cor

 

[Michel Posseth [MCP]]

You might start by providing the apropriate rights



Michel

 

[Miro]

Are you running vista?

Before you run vb, try right clicking on it, and click on "run as
administrator"

If that works, that means that you installed it somehow so your regular user
does not have all the rights.

 

[Martin Racette]

But it was runnig just fine in VB2005 Express, and I did not touch the
installation of SQL

 

[Martin Racette]

And how do I do that, when I was using VB2005 Express, everything was
working fine

 

[Martin Racette]

I'm running Vista, and whether I start it in Administrator mode or not I
still can not create a .mdf database