Error 262
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 Stack Overflow the company Business Learn more about error 414 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges error 626 Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each
Error 267
other. Join them; it only takes a minute: Sign up “CREATE DATABASE permission denied” error up vote 3 down vote favorite 1 I have installed SQL SERVER 2008 R2 on my system with Windows XP operating system installed. Whenever
Error 920
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 Jan 31 '13 at 12:22 no,even i don't know how to grant this permission. –CodeUnderflow Jan 31 '13 at 12:47 error 608 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 you installed the Server, you can use a Windows authentication or a SQL Server one where you provide the Username and Password, this User should be used. –CloudyMarble Jan 31 '13 at 13:04 add a comment| up vote 2 down vote When you start SQL server management stud
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Error 440
and policies of this site About Us Learn more about Stack Overflow error 303 the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation error 909 Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it http://stackoverflow.com/questions/14625682/create-database-permission-denied-error only takes a minute: Sign up SQL Server 2012- Create Database permission denied in database master (Error 262) up vote 0 down vote favorite I want to create a new database on SQL Server 2012 using SQL Server Management studio. I ran SQL Server Management studio as administrator and logged in using Windows Authentication, but I still get this error: Create http://stackoverflow.com/questions/34866014/sql-server-2012-create-database-permission-denied-in-database-master-error-262 Database permission denied in database master (Microsoft SQL Server, Error 262) sql-server database permissions share|improve this question asked Jan 18 at 23:28 Mehrdad Babaki 4461718 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote From this blog and also from this link share|improve this answer answered Jan 19 at 1:19 Doc Holliday 831110 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged sql-server database permissions or ask your own question. asked 8 months ago viewed 243 times active 8 months ago Linked 1 How to fix Microsoft SQL Server, Error: 262? Related 11SQL Server 2008 R2 Express permissions — cannot create database or modify users1Backup with verify gives CREATE DATABASE permission denied in database 'master'0Permission Denied Accessing
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 03:59:27 GMT by s_ac15 (squid/3.5.20)
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) SQL Server > SQL Server Tools Question 0 Sign in to vote How exactly do I correct this problem on Vista? TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Database 'kkl'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476 I have ensured that I am logged into the system as Admin but cannot find where on the Server, I assign my login to the dbcreator group. I have gone into Security >> Server Roles >> dbcreator. of which I am not a member. On a different system, where all works, however, I am not a member of this group either. Any suggestions on how to kill this one? Thanks in Advance. Klaus Tuesday, August 07, 2007 9:47 PM Reply | Quote Answers 1 Sign in to vote and this fixed my problem: http://msdn2.microsoft.com/en-us/library/bb326612.aspx Wednesday, August 08, 2007 4:21 PM Reply | Quote All replies 1 Sign in to vote and this fixed my problem: http://msdn2.microsoft.com/en-us/library/bb326612.aspx Wednesday, August 08, 2007 4:21 PM Reply | Quote 2 Sign in to vote BTW, if you are using Windows Vista which I assume you are....then this problem is easily fixed by running SQLServer as an Administrator Proposed as answer by CalinIlie Saturday, October 02, 2010 4:31 PM