Re: Permission Denied error
From: Greg Obleshchuk (greg-n-o-s-p-a-m-_at_ag-s-o-f-t-w-a-r-e.com)
Date: 02/05/04
- Next message: RobotDog: "Need SQLAppSetupWiz for VB 6 to install app with SQL database"
- Previous message: Girish: "xml support"
- In reply to: Taishi: "Permission Denied error"
- Next in thread: Taishi: "Re: Permission Denied error"
- Reply: Taishi: "Re: Permission Denied error"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 6 Feb 2004 10:35:10 +1100
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: RobotDog: "Need SQLAppSetupWiz for VB 6 to install app with SQL database"
- Previous message: Girish: "xml support"
- In reply to: Taishi: "Permission Denied error"
- Next in thread: Taishi: "Re: Permission Denied error"
- Reply: Taishi: "Re: Permission Denied error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
