Hello,
I am learning .NET 3.0. I am writing application using MIMProjekty SQL
Server 2005 database.
At C# command (identifiers are in Polish language):
SqlConnection Po³±czenie = new
SqlConnection(ConfigurationManager.ConnectionStrings["MIMProjekty"].ConnectionString);

Po³±czenie.Open();

I receive the following error:

CREATE DATABASE permission denied in database 'master'.
Could not attach file
'E:\Inetpub\wwwroot\MIMProjekty\App_Data\MIMProjekty.mdf' as database
'MIMProjekty'.

Could you help me please? The error is strange for me.
I use mixed mode in my SQL Server 2005 Express Edition. The database
'MIMProjekty' looks fine in Management Studio Express.

Here's my connection string from web.config:

<add name="MIMProjekty" connectionString="Data
Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial
Catalog=MIMProjekty;Integrated Security=True;uid=sa;pwd=sqlserver"
providerName="System.Data.SqlClient" />

Hi,

First, thanks for sharing admin password, appreciated ;-)
Other than that, try switching off Integrated Security (it uses asp.net
account right now, not the credentials provided).

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"R.A.M." <(E-Mail Removed)> wrote in message
news:em0ao9$nu0$(E-Mail Removed)...
> Hello,
> I am learning .NET 3.0. I am writing application using MIMProjekty SQL
> Server 2005 database.
> At C# command (identifiers are in Polish language):
> SqlConnection Po³±czenie = new
> SqlConnection(ConfigurationManager.ConnectionStrings["MIMProjekty"].ConnectionString);
>
> Po³±czenie.Open();
>
> I receive the following error:
>
> CREATE DATABASE permission denied in database 'master'.
> Could not attach file
> 'E:\Inetpub\wwwroot\MIMProjekty\App_Data\MIMProjekty.mdf' as database
> 'MIMProjekty'.
>
> Could you help me please? The error is strange for me.
> I use mixed mode in my SQL Server 2005 Express Edition. The database
> 'MIMProjekty' looks fine in Management Studio Express.
>
> Here's my connection string from web.config:
>
> <add name="MIMProjekty" connectionString="Data
> Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial
> Catalog=MIMProjekty;Integrated Security=True;uid=sa;pwd=sqlserver"
> providerName="System.Data.SqlClient" />
>

Thanks.
After I switched off Integrated Security I have error:

Database 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\MIMProjekty.mdf' already exists.
Could not attach file
'E:\Inetpub\wwwroot\MIMProjekty\App_Data\MIMProjekty.mdf' as database
'MIMProjekty'.

I have MIMProjekty attached in Management Studio. Why ADO.NET tries to
attach it again?
How to solve the problem?
Please help.
Thank you.
/RAM/

U¿ytkownik "Miha Markic [MVP C#]" <miha at rthand com> napisa³ w wiadomo¶ci
news:%(E-Mail Removed)...
> Hi,
>
> First, thanks for sharing admin password, appreciated ;-)
> Other than that, try switching off Integrated Security (it uses asp.net
> account right now, not the credentials provided).
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "R.A.M." <(E-Mail Removed)> wrote in message
> news:em0ao9$nu0$(E-Mail Removed)...
>> Hello,
>> I am learning .NET 3.0. I am writing application using MIMProjekty SQL
>> Server 2005 database.
>> At C# command (identifiers are in Polish language):
>> SqlConnection Po³±czenie = new
>> SqlConnection(ConfigurationManager.ConnectionStrings["MIMProjekty"].ConnectionString);
>>
>> Po³±czenie.Open();
>>
>> I receive the following error:
>>
>> CREATE DATABASE permission denied in database 'master'.
>> Could not attach file
>> 'E:\Inetpub\wwwroot\MIMProjekty\App_Data\MIMProjekty.mdf' as database
>> 'MIMProjekty'.
>>
>> Could you help me please? The error is strange for me.
>> I use mixed mode in my SQL Server 2005 Express Edition. The database
>> 'MIMProjekty' looks fine in Management Studio Express.
>>
>> Here's my connection string from web.config:
>>
>> <add name="MIMProjekty" connectionString="Data
>> Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial
>> Catalog=MIMProjekty;Integrated Security=True;uid=sa;pwd=sqlserver"
>> providerName="System.Data.SqlClient" />
>>
>

On Server Explorer, right click on the database and select detach. The
problem is likely due to the fact that the database is already attached, and
you are using different credentials to connect.

Regards:

Jesús López



"R.A.M." <(E-Mail Removed)> escribió en el mensaje
news:em0ncv$orp$(E-Mail Removed)...
> Thanks.
> After I switched off Integrated Security I have error:
>
> Database 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\DATA\MIMProjekty.mdf' already exists.
> Could not attach file
> 'E:\Inetpub\wwwroot\MIMProjekty\App_Data\MIMProjekty.mdf' as database
> 'MIMProjekty'.
>
> I have MIMProjekty attached in Management Studio. Why ADO.NET tries to
> attach it again?
> How to solve the problem?
> Please help.
> Thank you.
> /RAM/
>
> U¿ytkownik "Miha Markic [MVP C#]" <miha at rthand com> napisa³ w
> wiadomo¶ci news:%(E-Mail Removed)...
>> Hi,
>>
>> First, thanks for sharing admin password, appreciated ;-)
>> Other than that, try switching off Integrated Security (it uses asp.net
>> account right now, not the credentials provided).
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "R.A.M." <(E-Mail Removed)> wrote in message
>> news:em0ao9$nu0$(E-Mail Removed)...
>>> Hello,
>>> I am learning .NET 3.0. I am writing application using MIMProjekty SQL
>>> Server 2005 database.
>>> At C# command (identifiers are in Polish language):
>>> SqlConnection Po³±czenie = new
>>> SqlConnection(ConfigurationManager.ConnectionStrings["MIMProjekty"].ConnectionString);
>>>
>>> Po³±czenie.Open();
>>>
>>> I receive the following error:
>>>
>>> CREATE DATABASE permission denied in database 'master'.
>>> Could not attach file
>>> 'E:\Inetpub\wwwroot\MIMProjekty\App_Data\MIMProjekty.mdf' as database
>>> 'MIMProjekty'.
>>>
>>> Could you help me please? The error is strange for me.
>>> I use mixed mode in my SQL Server 2005 Express Edition. The database
>>> 'MIMProjekty' looks fine in Management Studio Express.
>>>
>>> Here's my connection string from web.config:
>>>
>>> <add name="MIMProjekty" connectionString="Data
>>> Source=.\SQLEXPRESS;AttachDBFileName=|DataDirectory|\MIMProjekty.mdf;Initial
>>> Catalog=MIMProjekty;Integrated Security=True;uid=sa;pwd=sqlserver"
>>> providerName="System.Data.SqlClient" />
>>>
>>
>
>