Web form error

  • Thread starter Thread starter Taishi
  • Start date Start date
T

Taishi

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
 
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
 
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.
 
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
 
Back
Top