Error 262 Sql Server Windows 7
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about error 262 in sql server 2008 Stack Overflow the company Business Learn more about hiring developers or posting ads with microsoft sql server error 262 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is sql server for windows 7 64 bit a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “CREATE DATABASE permission denied” error up vote 3 down vote favorite 1 I sql server for windows 7 32 bit have installed SQL SERVER 2008 R2 on my system with Windows XP operating system installed. Whenever I try to create a new database it displays an error: CREATE DATABASE PERMISSION DENIED IN DATABASE 'master'.(Microsoft SQL Server, Error:262) sql-server database sql-server-2008-r2 share|improve this question edited Jan 31 '13 at 15:13 Pondlife 12.6k52242 asked Jan 31 '13 at 12:21 CodeUnderflow 672211 Are you a member of the sysadmin role? –SchmitzIT
Sql Server For Windows 7 Free Download
Jan 31 '13 at 12:22 no,even i don't know how to grant this permission. –CodeUnderflow Jan 31 '13 at 12:47 When you installed it, there was a page where you specified who should be sys admins for the instance. It doesn't sound like you used the right options (one of them was to Add Current User) (unless this is Express) –Damien_The_Unbeliever Jan 31 '13 at 15:20 @CodeUnderflow - Do you have the password for the 'sa' user? This would have been something configured when you installed SQL Server with SQL Authentication mode. –SchmitzIT Jan 31 '13 at 16:17 add a comment| 5 Answers 5 active oldest votes up vote 2 down vote accepted Try to grant the user your loged in the CREATE ANY DATABASE Permission then try again. Take a look at the documentation about creating a new Database share|improve this answer answered Jan 31 '13 at 12:25 CloudyMarble 23.7k1566110 if that user is unable to grant permission to the user I have logged in then? –CodeUnderflow Jan 31 '13 at 12:51 You need to log in with the Admin user to grant this User the needed Permission, this depends on the Option you choosed when
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 03:51:04 GMT by s_ac15 (squid/3.5.20)
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server Express » Error 262 Can not create new DB http://www.sqlservercentral.com/Forums/Topic1154680-324-1.aspx Error 262 Can not create new DB Rate Topic Display Mode Topic Options Author Message http://forums.asp.net/t/1165249.aspx?Cant+create+new+database+CREATE+DATABASE+permission+denied+in+database+master+error+262+ logicinside22logicinside22 Posted Thursday, August 4, 2011 4:08 PM Old Hand Group: General Forum Members Last Login: Tuesday, August 9, 2016 6:58 AM Points: 322, Visits: 1,383 Hi Guys Have SQL Server 2005 Express 32 bit installed on win-7 64 bit.after installation when i am trying to create new data base its doesn't allow me to do .Error show: create sql server database permission denied in database 'master' (microsoft sql server error:262)So any Ideas ?pls reply me ASAPThanks Aim to inspire rather than to teach. SQL Server DBA Post #1154680 GilaMonsterGilaMonster Posted Thursday, August 4, 2011 4:12 PM SSC-Forever Group: General Forum Members Last Login: Today @ 4:26 PM Points: 45,376, Visits: 43,655 A bit more detail on what you mean by 'doesn't allow me' would be useful at this point. Gail ShawMicrosoft Certified Master: SQL Server, sql server for MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enterWe stand on the bridge and no one may pass Post #1154682 george sibbaldgeorge sibbald Posted Thursday, August 4, 2011 4:14 PM SSCertifiable Group: General Forum Members Last Login: Today @ 3:08 PM Points: 6,146, Visits: 13,673 try starting SSMS by right clicking and 'run as administrator' --------------------------------------------------------------------- Post #1154683 george sibbaldgeorge sibbald Posted Thursday, August 4, 2011 4:15 PM SSCertifiable Group: General Forum Members Last Login: Today @ 3:08 PM Points: 6,146, Visits: 13,673 Gail, don't start this 'beat george to the post' thing again --------------------------------------------------------------------- Post #1154684 GilaMonsterGilaMonster Posted Thursday, August 4, 2011 4:23 PM SSC-Forever Group: General Forum Members Last Login: Today @ 4:26 PM Points: 45,376, Visits: 43,655 george sibbald (8/4/2011)Gail, don't start this 'beat george to the post' thing again Ok, I'll go to bed.
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/DataSource Controls - SqlDataSource, ObjectDataSource, etc/Cant create new database / CREATE DATABASE permission denied in datab... Cant create new database / CREATE DATABASE permission denied in database master (error 262) [Answered]RSS 4 replies Last post Sep 02, 2010 03:11 PM by deepak.bca1205 ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply prontonet Member 297 Points 1399 Posts Cant create new database / CREATE DATABASE permission denied in database master (error 262) Oct 02, 2007 06:27 AM|prontonet|LINK I am using SQL express and Visual web developer on windows Vista. When I try to create a new database the following message appears. CREATE DATABASE permission denied in database master (error 262) I log on to my computer as an administrator. Help appreciated Prontonet Reply iainpb Member 715 Points 244 Posts Re: Cant create new database / CREATE DATABASE permission denied in database master (error 262) Oct 02, 2007 07:20 AM|iainpb|LINK How do you login to sql server? Do you use sql authentication? If so, check the account you login with has appropriate permissions. Or are you using windows authentication? ---------------------------------------------- Mark helpful posts as "Answer" Check out my cheese making blog http://cheeseathome.blogspot.com Reply Bo Chen – MS... All-Star 15349 Points 1383 Posts Re: Cant create new database / CREATE DATABASE permission denied in database master (error 262) Oct 04, 2007 04:15 AM|Bo Chen – MSFT|LINK Can youlogintodatabase engine and read data anyway?? You need "CREATE DATABASE" permissiontocreate new database.However, to make things easier, i would suggest you usesys_admin permission over your database.Open sql express and click "security"-->Logins, see if your login name is liste