Microsoft Sql Server Error 262 Sql Server 2008
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings microsoft sql server error 15247 and policies of this site About Us Learn more about Stack Overflow create database permission denied in database 'master' error 262 sql server 2012 the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags error 262 in sql server 2005 Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only create database permission denied in database 'master' sql server 2008 r2 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 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
Microsoft Sql Server Error 15151
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 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
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 15:32:16 GMT by s_wx1196 (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: Error 262 SQL Server R2 http://social.msdn.microsoft.com/Forums/sqlserver/hu-HU/8dd0b7aa-2e37-4028-bfc4-77dc71a1165e on windows server 2008 SQL Server > Getting started with SQL Server Question 0 Sign in to vote I can't create new database. getting error 262 running sql http://www.sqlservercentral.com/Forums/Topic1154680-324-1.aspx server 2008, windows server 2008 R2 thank for your help Friday, March 11, 2011 6:29 PM Reply | Quote Answers 0 Sign in to vote C:\Program Files\Microsoft sql server SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DAT\acton_log.ldf correct file path is : C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\acton_log.ldf the A in DATA makes a lot of different Marked as answer by EladRez Saturday, March 12, 2011 1:10 AM Saturday, March 12, 2011 1:10 AM Reply | Quote All replies 0 Sign in to vote Starting with SQL 2008, windows administrator are not granted microsoft sql server sysadmin permission inside SQL server unless explictly granted during the SQL server setup. So your cannot create database even though you are admin of the local computer. If you chose to use mixed mode or sql authentication during the setup thenuse sa(sysadmin) account andadd your windows login as sysadmin fixedserver role. Otherwise, you will have to start SQL Server service in **single user mode**after that anywindows administrator of thelocal computer can connect to sql serveras a syadmin fixed server role.It will for sure then let you add your login to sysadmin role. Reference: Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out http://msdn.microsoft.com/en-us/library/dd207004.aspx Proposed as answer by Naomi NModerator Friday, March 11, 2011 9:36 PM Friday, March 11, 2011 6:48 PM Reply | Quote 0 Sign in to vote i was able to loging using the ssms and added my user as a sysadmin account now i am getting thefollowingerror ------------------------------ Create failed for Database 'acton'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemp
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 Error 262 Can not create new DB Rate Topic Display Mode Topic Options Author Message 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 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 @ 9:32 AM Points: 45,423, Visits: 43,752 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, 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: Thursday, October 13, 2016 6:09 AM Points: 6,147, Visits: 13,676 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: Thursday, October 13, 2016 6:09 AM Points: 6,147, Visits: 13,676 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 @ 9:32 AM Points: 45,423, Visits: 43,752 george sibbald (8/4/2011)Gail, don't start this 'beat george to the post' thing again Ok, I'll go to bed.