Re: SQLExpress New DB

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: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Thanks for posting it. ... Hitchhiker's Guide to Visual Studio and SQL Server ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... The SQLCe engine requires the 2.0 Framework. ... Hitchhiker's Guide to Visual Studio and SQL Server ... However, it does build the SSCE database, just some of the definitions are ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
Loading