473,554 Members | 3,191 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Permission denied error 2nd Post

New user of SQL
Everything is on the same machine
My error is close to the bottom
After reading it today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'
There are also some comments from the group:
---microsoft.publi c.sqlserver.odb c-- subject: Permission Denied -- Thanks
for help guys

I was able to find a trial version of the Enterprise Manager.

It was suggested to make the post over in dotnet.framewor k. I am new to
SQL. I can see the following in the MSDE manager:

sql server(my machine name\??SDK)
after I right click on 'PUBS'
---Users/Roles/Public
---public
---machine_name\as pnet
---guest

guest is the only one with 5 check marks going across from left to right for
the following:
Create Table, Create View, Create SP, Create Default, Create Rule

the following 3 are blank:
Create Function, Backup DB, and Backup Log

public has just 1 check mark on
Create SP

machine_name\as pnet is blank from left to right.

CREATE DBASE right is not displayed.

How can I solve my Permission denied error problem?

Thanks for the help,
Taishi



---Comments---
Hi Tashi!

You can ue Enterprise manager to set the rights. Locate the table, and right
click. Select All Tasks, then Manage Permissions. Locate the user that you
are using in your connection object, and then grant the rights. I agree with
Greg that the web user should not normally have that level of permission.
One false move and your server and data could be toast. If you are really
trying to create a table, or attach a database, you should be doing that
through Enterprise Manager, and not the web interface.

Sloan

"Taishi" <ta********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.phx.gbl...
How can I check the permissions/rights?

How can I grant the correct permissions/rights?

Thanks,
T

"Greg Obleshchuk" <gr************ ***@ag-s-o-f-t-w-a-r-e.com> wrote in
message news:ud******** ******@TK2MSFTN GP10.phx.gbl...
Hello,
What are you trying to do here? Can you post the commands

To create databases you need system administrator rights and dbcreator

Permissions (from BOL)
CREATE DATABASE permission defaults to members of the sysadmin and dbcreator
fixed server roles. Members of the sysadmin and securityadmin fixed server
roles can grant CREATE DATABASE permissions to other logins. Members of

the
sysadmin and dbcreator fixed server role can add other logins to the
dbcreator role. The CREATE DATABASE permission must be explicitly granted; it is not granted by the GRANT ALL statement.

CREATE DATABASE permission is usually limited to a few logins to maintain control over disk usage on an instance of SQL Server.

I wouldn't suggest granting the owner of a .NET IIS app either of these
rights
--
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe

Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx. Free icon

extraction
program
http://www.ag-software.com. Free programming tools


"Taishi" <ta********@hot mail.com> wrote in message
news:eJ******** *****@TK2MSFTNG P12.phx.gbl...
Windows Pro
VS.Net
.Net Framework
ASP.NET
My 1st time using Web Forms in .Net
1st time using SQL
I am receiving the following error:

System.Data.Sql Client.SqlExcep tion: CREATE DATABASE permission denied in database 'master'. Could not attach database 'pubs' to file 'D:\Program Files\Microsoft SQL Server\MSSQL$NE TSDK\Data\pubs. mdf'.

I tried the following:

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

Here is some advanced help from another SQL forum.
sp_helpsrvrolem ember 'sysadmin' ----> command is not on my box.
isql /usa/p/server\sdk -i\instpubs.sql ----> did not work. isql is

not a command found on my box.
Any ideas?

Thanks for your help,
T



Nov 18 '05 #1
2 3669
You might want to investigate this open source solution:
"ASP Enterprise Manager is a web-based interface for Microsoft SQL Server
and MSDE written using ASP.Net, VB.Net and C#.Net. This project was
developed to allow many SQL Server and MSDE design and administration tasks
to be performed from any computer with a web browser. "

http://www.aspenterprisemanager.com/

http://sourceforge.net/projects/asp-ent-man/
"Taishi" <ta********@hot mail.com> wrote in message
news:ed******** ******@tk2msftn gp13.phx.gbl...
New user of SQL
Everything is on the same machine
My error is close to the bottom
After reading it today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'
There are also some comments from the group:
---microsoft.publi c.sqlserver.odb c-- subject: Permission Denied -- Thanks
for help guys

I was able to find a trial version of the Enterprise Manager.

It was suggested to make the post over in dotnet.framewor k. I am new to
SQL. I can see the following in the MSDE manager:

sql server(my machine name\??SDK)
after I right click on 'PUBS'
---Users/Roles/Public
---public
---machine_name\as pnet
---guest

guest is the only one with 5 check marks going across from left to right
for
the following:
Create Table, Create View, Create SP, Create Default, Create Rule

the following 3 are blank:
Create Function, Backup DB, and Backup Log

public has just 1 check mark on
Create SP

machine_name\as pnet is blank from left to right.

CREATE DBASE right is not displayed.

How can I solve my Permission denied error problem?

Thanks for the help,
Taishi



---Comments---
Hi Tashi!

You can ue Enterprise manager to set the rights. Locate the table, and
right
click. Select All Tasks, then Manage Permissions. Locate the user that you
are using in your connection object, and then grant the rights. I agree
with
Greg that the web user should not normally have that level of permission.
One false move and your server and data could be toast. If you are really
trying to create a table, or attach a database, you should be doing that
through Enterprise Manager, and not the web interface.

Sloan

"Taishi" <ta********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.phx.gbl...
How can I check the permissions/rights?

How can I grant the correct permissions/rights?

Thanks,
T

"Greg Obleshchuk" <gr************ ***@ag-s-o-f-t-w-a-r-e.com> wrote in
message news:ud******** ******@TK2MSFTN GP10.phx.gbl...
> Hello,
> What are you trying to do here? Can you post the commands
>
> To create databases you need system administrator rights and dbcreator
>
> Permissions (from BOL)
> CREATE DATABASE permission defaults to members of the sysadmin and

dbcreator
> fixed server roles. Members of the sysadmin and securityadmin fixed server > roles can grant CREATE DATABASE permissions to other logins. Members of

the
> sysadmin and dbcreator fixed server role can add other logins to the
> dbcreator role. The CREATE DATABASE permission must be explicitly granted; > it is not granted by the GRANT ALL statement.
>
> CREATE DATABASE permission is usually limited to a few logins to maintain > control over disk usage on an instance of SQL Server.
>
> I wouldn't suggest granting the owner of a .NET IIS app either of these
> rights
>
>
> --
> I hope this helps
> regards
> Greg O MCSD
> http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe

Documentation
> Builder, the quickest way to document your database
> http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended > Property Extended properties manager for SQL 2000
> http://www.ag-software.com/IconExtractionProgram.aspx. Free icon

extraction
> program
> http://www.ag-software.com. Free programming tools
>
>
>
>
> "Taishi" <ta********@hot mail.com> wrote in message
> news:eJ******** *****@TK2MSFTNG P12.phx.gbl...
> > Windows Pro
> > VS.Net
> > .Net Framework
> > ASP.NET
> > My 1st time using Web Forms in .Net
> > 1st time using SQL
> > I am receiving the following error:
> >
> > System.Data.Sql Client.SqlExcep tion: CREATE DATABASE permission denied in > > database 'master'. Could not attach database 'pubs' to file 'D:\Program > > Files\Microsoft SQL Server\MSSQL$NE TSDK\Data\pubs. mdf'.
> >
> > I tried the following:
> >
> > Reboot 4-5 times
> > Share the folder
> > Web share the folder
> >
> > Here is some advanced help from another SQL forum.
> > sp_helpsrvrolem ember 'sysadmin' ----> command is not on my box.
> > isql /usa/p/server\sdk -i\instpubs.sql ----> did not work. isql is

not
a
> > command found on my box.
> >
> >
> > Any ideas?
> >
> > Thanks for your help,
> > T
> >
> >
>
>




Nov 18 '05 #2
Hello! Ken:

I posted that website on my other posting(Permiss ion Denied). I will do
some more research and investigating but you told me that I had to install
it on a ASP.net web server???? I am a uninitiated, so I'm trying to grasp
the concept.

Hi Tashi!

You'll have to install it on a local ASP.net web server, and then use your
browser to go to the site.

Sloan

Taishi
"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:u2******** ******@TK2MSFTN GP11.phx.gbl...
You might want to investigate this open source solution:
"ASP Enterprise Manager is a web-based interface for Microsoft SQL Server
and MSDE written using ASP.Net, VB.Net and C#.Net. This project was
developed to allow many SQL Server and MSDE design and administration tasks to be performed from any computer with a web browser. "

http://www.aspenterprisemanager.com/

http://sourceforge.net/projects/asp-ent-man/
"Taishi" <ta********@hot mail.com> wrote in message
news:ed******** ******@tk2msftn gp13.phx.gbl...
New user of SQL
Everything is on the same machine
My error is close to the bottom
After reading it today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'
There are also some comments from the group:
---microsoft.publi c.sqlserver.odb c-- subject: Permission Denied -- Thanks for help guys

I was able to find a trial version of the Enterprise Manager.

It was suggested to make the post over in dotnet.framewor k. I am new to
SQL. I can see the following in the MSDE manager:

sql server(my machine name\??SDK)
after I right click on 'PUBS'
---Users/Roles/Public
---public
---machine_name\as pnet
---guest

guest is the only one with 5 check marks going across from left to right
for
the following:
Create Table, Create View, Create SP, Create Default, Create Rule

the following 3 are blank:
Create Function, Backup DB, and Backup Log

public has just 1 check mark on
Create SP

machine_name\as pnet is blank from left to right.

CREATE DBASE right is not displayed.

How can I solve my Permission denied error problem?

Thanks for the help,
Taishi



---Comments---
Hi Tashi!

You can ue Enterprise manager to set the rights. Locate the table, and
right
click. Select All Tasks, then Manage Permissions. Locate the user that you are using in your connection object, and then grant the rights. I agree
with
Greg that the web user should not normally have that level of permission. One false move and your server and data could be toast. If you are really trying to create a table, or attach a database, you should be doing that
through Enterprise Manager, and not the web interface.

Sloan

"Taishi" <ta********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.phx.gbl...
How can I check the permissions/rights?

How can I grant the correct permissions/rights?

Thanks,
T

"Greg Obleshchuk" <gr************ ***@ag-s-o-f-t-w-a-r-e.com> wrote in
message news:ud******** ******@TK2MSFTN GP10.phx.gbl...
> Hello,
> What are you trying to do here? Can you post the commands
>
> To create databases you need system administrator rights and dbcreator >
> Permissions (from BOL)
> CREATE DATABASE permission defaults to members of the sysadmin and
dbcreator
> fixed server roles. Members of the sysadmin and securityadmin fixed

server
> roles can grant CREATE DATABASE permissions to other logins. Members of the
> sysadmin and dbcreator fixed server role can add other logins to the
> dbcreator role. The CREATE DATABASE permission must be explicitly

granted;
> it is not granted by the GRANT ALL statement.
>
> CREATE DATABASE permission is usually limited to a few logins to

maintain
> control over disk usage on an instance of SQL Server.
>
> I wouldn't suggest granting the owner of a .NET IIS app either of these > rights
>
>
> --
> I hope this helps
> regards
> Greg O MCSD
> http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe
Documentation
> Builder, the quickest way to document your database
> http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server

Extended
> Property Extended properties manager for SQL 2000
> http://www.ag-software.com/IconExtractionProgram.aspx. Free icon
extraction
> program
> http://www.ag-software.com. Free programming tools
>
>
>
>
> "Taishi" <ta********@hot mail.com> wrote in message
> news:eJ******** *****@TK2MSFTNG P12.phx.gbl...
> > Windows Pro
> > VS.Net
> > .Net Framework
> > ASP.NET
> > My 1st time using Web Forms in .Net
> > 1st time using SQL
> > I am receiving the following error:
> >
> > System.Data.Sql Client.SqlExcep tion: CREATE DATABASE permission
denied in
> > database 'master'. Could not attach database 'pubs' to file

'D:\Program
> > Files\Microsoft SQL Server\MSSQL$NE TSDK\Data\pubs. mdf'.
> >
> > I tried the following:
> >
> > Reboot 4-5 times
> > Share the folder
> > Web share the folder
> >
> > Here is some advanced help from another SQL forum.
> > sp_helpsrvrolem ember 'sysadmin' ----> command is not on my box.
> > isql /usa/p/server\sdk -i\instpubs.sql ----> did not work. isql is

not
a
> > command found on my box.
> >
> >
> > Any ideas?
> >
> > Thanks for your help,
> > T
> >
> >
>
>


Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1616
by: -g00t©- | last post by:
--------------( oo )-------------- I don't know if there's a beginner board, just tell me if it's the place; I tried Python this weekend. I'm java coder and I was looking for handling names in os. I tried the os.raname('file.ext','nuFile.ext') and I got a Permission denied error. In the docs, it say that it should work only for UNIX, than...
6
7859
by: Jon Montana | last post by:
CDONTS was working well until I installed Exchange 2000. I thought it might be a relay problem, but I allowed the server IP address to relay. Thanks for anything you can offer. here's the error: HTTP 500.100 - Internal Server Error - ASP error Internet Information Services
1
2317
by: Benny | last post by:
Dear All, My ASP-MS Access application works fin in our local server and in our hosting I get this errors, while adding/editing or deleteing. When deleting a product: error Microsoft VBScript runtime error '800a0046' Permission denied /webadmin/Products.asp, line 27 When deleting an image from a product: error Microsoft VBScript runtime...
1
4311
by: Mark E. Hamilton | last post by:
Sorry, I probably should have re-stated the problem: We're using Python 2.3.5 on AIX 5.2, and get the follow error messages from some of our code. I haven't yet tracked down exactly where it's coming from: sem_trywait: Permission denied sem_wait: Permission denied sem_post: Permission denied
10
4560
by: Florian G. Pflug | last post by:
Hi I installed a postgres-application (which was developed on debian woody) on red hat 9 today, using the postgres 7.3 rpms from redhad. One of my the triggers uses the pg_settings table (more precisely, it updates that table to change the search_path temporarily). With the postgres 7.3 (and 7.4 too) installed on my debian development...
4
9746
by: Russell Warren | last post by:
I've been having a hard time tracking down a very intermittent problem where I get a "permission denied" error when trying to rename a file to something that has just been deleted (on win32). The code snippet that gets repeatedly called is here: ... if os.path.exists(oldPath): os.remove(oldPath) os.rename(newPath, oldPath)
4
9074
by: stephen | last post by:
Hi, I am getting an error while trying to create an excel file. "Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details:...
0
3186
by: debug03 | last post by:
I am executing a DTS package on a Windows 2000 sp4 server running SQL Server 2000 and IBM DB2 V7 client. The DTS package source data(SQL Server) is selected from SQL server table and inserts data to the destination table(DB2). I get the following error when the package is executed: The execution of the following DTS Package succeeded: ...
4
2659
by: xzzy | last post by:
I have a v1.1 web app that works on my local computer. However, running it at the host computer, the following breaks: when a viewer selects a different country, the State dropdown should repopulate with the new country's state/proviences. Running on the host, the dropdown does not repopulate and says 'Permission Denied', I take this to...
0
7584
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7512
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7783
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7547
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6129
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5426
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3548
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1117
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
828
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.