Re: Permission denied error 2nd Post
From: Ken Cox [Microsoft MVP] (BANSPAMken_cox_at_sympatico.ca)
Date: 02/11/04
- Next message: gbpackfan: "Re: MSDE install sees Windows 98 upgrade as 95 and fails"
- Previous message: Al Kaufman: "Installation: "The cabinet fiel sqlrun.cab required for this installation is corrupt""
- In reply to: Taishi: "Permission denied error 2nd Post"
- Next in thread: Taishi: "Re: Permission denied error 2nd Post"
- Reply: Taishi: "Re: Permission denied error 2nd Post"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Feb 2004 19:24:54 -0500
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" <taishi_bak@hotmail.com> wrote in message
news:edfyhn97DHA.3860@tk2msftngp13.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.public.sqlserver.odbc-- 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.framework. 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\aspnet
> ---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\aspnet 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" <taishi_bak@hotmail.com> wrote in message
> news:u54GDcN7DHA.1428@TK2MSFTNGP12.phx.gbl...
>> How can I check the permissions/rights?
>>
>> How can I grant the correct permissions/rights?
>>
>> Thanks,
>> T
>>
>> "Greg Obleshchuk" <greg-n-o-s-p-a-m-@ag-s-o-f-t-w-a-r-e.com> wrote in
>> message news:udfB$CE7DHA.2568@TK2MSFTNGP10.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" <taishi_bak@hotmail.com> wrote in message
>> > news:eJuJfV16DHA.360@TK2MSFTNGP12.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.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
>> > >
>> > > Here is some advanced help from another SQL forum.
>> > > sp_helpsrvrolemember '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
>> > >
>> > >
>> >
>> >
>>
>>
>
>
- Next message: gbpackfan: "Re: MSDE install sees Windows 98 upgrade as 95 and fails"
- Previous message: Al Kaufman: "Installation: "The cabinet fiel sqlrun.cab required for this installation is corrupt""
- In reply to: Taishi: "Permission denied error 2nd Post"
- Next in thread: Taishi: "Re: Permission denied error 2nd Post"
- Reply: Taishi: "Re: Permission denied error 2nd Post"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
