Fresh installation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Fresh installation
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... CREATE DATABASE permission denied in database 'master'. ... name exists, or specified file cannot be opened, or it is located on UNC ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Cant add connection via Visual C# Express
    ... Using SQL Server Express 2008 and SQL Server Management Studio Express 2008 ... When I try to add a database via Management Studio there is no problem, ... and use the same database I receive the message "The FOR ATTACH option ... same name exists or specified file cannot be opened or is located on UNC ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Cant add connection via Visual C# Express
    ... Using SQL Server Express 2008 and SQL Server Management Studio Express 2008 ... When I try to add a database via Management Studio there is no problem, ... same name exists or specified file cannot be opened or is located on UNC ...
    (microsoft.public.dotnet.languages.csharp)
  • 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)