Click here to Skip to main content
13,046,562 members (69,885 online)
Rate this:
Please Sign up or sign in to vote.
I a have SQL Server installed in my system , is am using windows authentication to login in .
But when ever my trying to create a database or try runing script it gives Error as: create permission denied in database master sql server 2008 , Error:262

Any suggestions please.
Posted 9-Jan-13 0:22am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You need to give create permissions your user (or all users) - it looks like at present you haven't done that.
The trouble is that you probably need to log in as a sysadmin in order to give yourself the required authority!
Open SSMS, and login as an administrator: you have probably left the default admin in place, so that's user "sa", password blank.
Open the "Security" branch of the tree, and double click your PC/User combination. Change the Roles to include sysadmin and save.
While you are here, change the sa password to something a little more secure!

You should now be able to create a DB from your usual log in.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100