Windows Pro
VS.Net
..Net Framework
ASP.NET
My 1st time using Web Forms in .Net

I am receiving the following error:

System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in
database 'master'. Could not attach database 'pubs' to file 'D:\Program
Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf'.

I tried the following:

Reboot 4-5 times
Share the folder
Web share the folder


Any ideas?

Thanks for your help,
T.

Hi,

You do not have permission to create a database that is why you are
getting that error. Check your security settings.

In the C:\Program Files\Microsoft Visual Studio .NET
2003\SDK\v1.1\Samples\Setup directory is the instpubs.sql script. From the
command line in that directory try this.

isql /Usa /Psapassword /Sserver -i\instpubs.sql

replace sapassword with your sa password. blank by default (should change
if it is)

replace server with the msde server name it should be your machine
name\VSdotNet

Ken
--------------------------------
"Taishi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Windows Pro
> VS.Net
> .Net Framework
> ASP.NET
> My 1st time using Web Forms in .Net
>
> I am receiving the following error:
>
> System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in
> database 'master'. Could not attach database 'pubs' to file 'D:\Program
> Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf'.
>
> I tried the following:
>
> Reboot 4-5 times
> Share the folder
> Web share the folder
>
>
> Any ideas?
>
> Thanks for your help,
> T.
>
>
>

Hi Taishi,

Mostly this error is because the webform is using the user IUSR and/or
ASPNET I would try if you can give (if you want that) those users rights on
that access file.

I hope this helps,

Cor

Ken,

Do this from the VS.NET command prompt?

isql /Usa /Psapassword /Sserver -i\instpubs.sql

Where is the isql located?

It is not a command on my drive.

Thanks,
T.

Do you mean
"Ken Tucker [MVP]" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi,
>
> You do not have permission to create a database that is why you
are
> getting that error. Check your security settings.
>
> In the C:\Program Files\Microsoft Visual Studio .NET
> 2003\SDK\v1.1\Samples\Setup directory is the instpubs.sql script. From
the
> command line in that directory try this.
>
> isql /Usa /Psapassword /Sserver -i\instpubs.sql
>
> replace sapassword with your sa password. blank by default (should change
> if it is)
>
> replace server with the msde server name it should be your machine
> name\VSdotNet
>
> Ken
> --------------------------------
> "Taishi" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Windows Pro
> > VS.Net
> > .Net Framework
> > ASP.NET
> > My 1st time using Web Forms in .Net
> >
> > I am receiving the following error:
> >
> > System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in
> > database 'master'. Could not attach database 'pubs' to file 'D:\Program
> > Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf'.
> >
> > I tried the following:
> >
> > Reboot 4-5 times
> > Share the folder
> > Web share the folder
> >
> >
> > Any ideas?
> >
> > Thanks for your help,
> > T.
> >
> >
> >
>
>

Hi,

http://msdn.microsoft.com/library/de...intro_3nsj.asp

Ken
----------------------
"Ken Tucker [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> You do not have permission to create a database that is why you are
> getting that error. Check your security settings.
>
> In the C:\Program Files\Microsoft Visual Studio .NET
> 2003\SDK\v1.1\Samples\Setup directory is the instpubs.sql script. From
> the
> command line in that directory try this.
>
> isql /Usa /Psapassword /Sserver -i\instpubs.sql
>
> replace sapassword with your sa password. blank by default (should change
> if it is)
>
> replace server with the msde server name it should be your machine
> name\VSdotNet
>
> Ken
> --------------------------------
> "Taishi" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Windows Pro
>> VS.Net
>> .Net Framework
>> ASP.NET
>> My 1st time using Web Forms in .Net
>>
>> I am receiving the following error:
>>
>> System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in
>> database 'master'. Could not attach database 'pubs' to file 'D:\Program
>> Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf'.
>>
>> I tried the following:
>>
>> Reboot 4-5 times
>> Share the folder
>> Web share the folder
>>
>>
>> Any ideas?
>>
>> Thanks for your help,
>> T.
>>
>>
>>
>
>

I am using MSDE. And I don't know how to change the rights. I found the
following:

http://www.aspenterprisemanager.com/

I unzipped it but I have no clue on how to execute it. It has 4 folders and
3 files.

folders:
_classes
_codeBehinds
app
bin
3 files:
default.asp
global.asax
web.config

How do I run this Enterprise Manager?

Thanks,
T.

"Cor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Taishi,
>
> Mostly this error is because the webform is using the user IUSR and/or
> ASPNET I would try if you can give (if you want that) those users rights
on
> that access file.
>
> I hope this helps,
>
> Cor
>
>

Hi Taishi,

I do not know, how you can run that Enterprise manager this is the first
time I see it.

But when I did want to get an answer on this question I would ask that in a
newsgroup as

microsoft.public.dotnet.framework.adonet

or in a

microsoft SQL server newsgroup.

Cor