While creating database with Microsoft SQL Server I have faced this problem

Asked By desiraealexa 50 points N/A Posted on - 09/26/2012

Hi,

While creating database with Microsoft SQL Server I have faced this problem. I have no idea about this exception. If you have any idea regarding this issue please help me.

Microsoft SQL Server Management Studio

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

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)

• Status: Open
• Question Views: 954
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Lgoy Budion

Go To Solution

Answered By Nicke Baker 0 points N/A #141890

While creating database with Microsoft SQL Server I have faced this problem

Hello Desirae,

To resolve that issue:

• Open SQL Server Management Studio, and then from the [Object Explorer] expand the server instance.
• After that right Click on the [Database] name, and the select [Tasks] > [Restore] > [Database].
• In the [Restore Database] Dialog window, select the [To database:] from the drop down selection menu.
• After that select [From the device:], and then click the ellipse button to open the [Specify Backup] dialog box.
• After that you will click [Add] to go where you stored your .bak database.
• After you get the .bak file, you will need to put a [Check] in the [Restore] box beside its name.

Get more details here

Regards,

Nicke

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 09/26/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Lgoy Budion 0 points N/A #141891

While creating database with Microsoft SQL Server I have faced this problem

You cannot create a table on the master database because the master database holds all the configurations and security settings of your SQL Program, you need to create a new database for your table which can be done with these simple steps:

1. Open your SQL Management.

2. On the Databases Right Click on the Databases.

3. Name and Create a new Database where you will create your table.

4. After creating the database, click the "+" sign at the side of your database.

5. On the Tables Folder, Right click on it and Create New Table.

6. After defining every column of your table, Press Ctrl+s to save your table.

About Lgoy Budion

Questions
5

Answers
112

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 09/26/2012
• Question Category: MS SQL Server