Problem in SQL New database creation

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Database 'Style'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.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.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

------------------------------
BUTTONS:

OK
------------------------------

How can i fix this problem........

Posted 27-Aug-13 23:45pm

Ashutosh_jha

Add a Solution

Comments

[no name] 28-Aug-13 5:51am

"permission denied"... you fix "permission denied" problems by giving the account permission.

Ashutosh_jha 28-Aug-13 5:55am

please guide me with process

Ashutosh_jha 28-Aug-13 6:00am

how i do?

Ashutosh_jha 28-Aug-13 6:16am

what is the process to account permission

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ZurdoDev · Answer 1 · 2013-08-28T03:50:00

Solution 1

Whatever account you are using does not have permissions to create a database. You need to change the account you are using or if you have admin permissions you could grant that permission to whatever user you are using.

Posted 28-Aug-13 3:50am

ZurdoDev

Mubin M. Shaikh · Answer 2 · 2013-09-04T03:50:00

Solution 2

Hi,

users Admin group of SQL server can provide rights to your user, if you do not have permission to create database.

your error says it clearly that user is not allowed to create database in master.

if you need further detail let me know.

Regards,
Mubin shaikh

Posted 4-Sep-13 3:50am

Mubin M. Shaikh