Re: Fresh installation

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try adding :"Initial Catalog=<your database name>" to the ConnectionString.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
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)
-----------------------------------------------------------------------------------------------------------------------

"Stig Kulvedrøsten" <stig@xxxxxxxx> wrote in message
news:4A52FEF9-10FA-4B75-867A-5CEB534F5CA8@xxxxxxxxxxxxxxxx
I've just installed Windows Vista with Visual Studio.Net 2005 and SQL
Server Express Advanced Edition.
When installation of vs.net and sql server was finished I tried to run one
of my sites right away.

This is the error I got:
CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file
E:\Websites\Site\App_Data\site_db.mdf failed. A database with the same
name exists, or specified file cannot be opened, or it is located on UNC
share.

My connectionstring looks like this: "Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\site_db.mdf;Integrated
Security=True;User Instance=False"

Any suggestions?

Stig


.

Relevant Pages

  • Re: Replacing tables in SQL EXPRESS
    ... I have posted an updated example on the Hitchhiker's Guide support site. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... > SQL EXPRESS database file? ...
    (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)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: How do you clear a datatable?
    ... When i look at the database in Server Explorer, ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)