Re: Connecting To SSE with MSE
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 19 Aug 2009 11:31:25 +0000 (UTC)
Gilles Nambert (gntools@xxxxxxxxxx) writes:
I've an SSE Database on a ASP .NET application, with the folowing :
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\LPA.mdf;Integrated
Security=True;User Instance=False;Database=LPA"
providerName="System.Data.SqlClient"
Then, i try to connect Management Studio Express, but i get an error :
Autorisation CREATE DATABASE refusée dans la base de données 'master'.
Impossible de joindre le fichier 'D:\Sites\Lpa\App_Data\LPA.mdf' en tant
que base de données 'LPA'.
I did not find much help in the doc on line. So, is it possible and how
?
The error messeage should be pretty clear: it means that you don't have
CREATE DATABASE permission. Do you expect to have this permission?
You say this this is an ASP. Net application. Do you get this error when
you run the above from the web server? In that case it is the service
account for the web server that needs to have this permission.
If you get this error when you run this directly, it may be that you are
on Vista, and you have not set up your own account as administrator in
SQL Server. In this case you need to start Mgmt STtudio Express by right-
clicking it and select Run As Administrator.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Connecting To SSE with MSE
- From: Gilles Nambert
- Connecting To SSE with MSE
- Prev by Date: Connecting To SSE with MSE
- Next by Date: Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
- Previous by thread: Connecting To SSE with MSE
- Next by thread: Connecting to SSE with MSE
- Index(es):
Relevant Pages
|
