Re: Permission Denied error

From: Taishi (taishi_bak_at_hotmail.com)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 11:31:09 -0600

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
> >
> >
>
>

Relevant Pages

  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.sqlserver.msde)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Permission Denied error
    ... You can ue Enterprise manager to set the rights. ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.sqlserver.setup)
  • Re: Allowing Anonymous write access only.
    ... need at least READ permission for login. ... > been set up so that anonymous FTP users have write access only, this> may seem insecure and we do get a certain ammount of hackers or> taggers testing the system by dropping test files and folders onto the> server, but because anonymous users do not have read access they soon> find that they cannot download anything they upload and go elsewhere. ... This is where my problems have started,> I initialy replicated all the IIS setting and NTFS permission from my> NT box on my 2003 box but so far have been unable to achive the same> result, it appaers that I can only grant anonymous write access if I ...
    (microsoft.public.inetserver.iis.ftp)